sas-macro
Macro returning a value
I created the following macro. Proc power returns table pw_cout containing column Power. The data _null_ step assigns the value in column Power of pw_out to macro variable tpw.I want the macro to retu[详细]
2023-04-04 18:09 分类:问答SAS -> Shell DB2 Passthrough and macro resolving
I\'m trying to automate a job that involves a lot of data being passed across the network and between the actual db2 server and our SAS server.What I\'d like to开发者_C百科 do is take a traditional pa[详细]
2023-04-02 16:47 分类:问答SAS variable concatenation through data step
I am looking for a way to create a string variable containing certain values of the dataset while going through the data step.[详细]
2023-03-01 07:14 分类:问答Transform literal date parameter to SAS date value in macro
I want to create a SAS macro which takes a literal date (eg. \'31may2011\'d) as parameter. Inside the macro I want to transform this into a SAS date value (eg. 18778).[详细]
2023-02-28 00:29 分类:问答SAS Macro-variable reference concatenation
The following code reads in a cellphone bill from an excel file and do a lot of cleaning / reports. %LET month = March;[详细]
2023-02-20 15:20 分类:问答SAS macro variable change
In general how do we deal with th开发者_如何学运维e situation where macro variables need to be modified inside a macro; for example, suppose I have this macro:[详细]
2023-02-20 05:43 分类:问答Regex to convert a space separated list to a SQL where clause
I\'m almost开发者_StackOverflow embarassed, but I\'m struggling to create a regular expression to change something like cat dog mouse to a SQL where clause:[详细]
2022-12-19 06:47 分类:问答clearing a library which is being used for stored compiled SAS macro
开发者_JS百科I have a program which creates a stored compiled macro in a library using the syntax:[详细]
2022-12-09 18:40 分类:问答