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
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
I am looking for a way to create a string variable containing certain values of the dataset while going through the data step.
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).
The following code reads in a cellphone bill from an excel file and do a lot of cleaning / reports. %LET month = March;
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:
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:
开发者_JS百科I have a program which creates a stored compiled macro in a library using the syntax: