CODEWITHSUNDEEP
sassas-macro
Sheldon
Sheldon

Reputation: 1215

Create SAS macro to create a macro variable

I have created a SAS macro, macro A, that takes in a variable name and returns transformed versions of that name i.e. if you run %A(asdf) you get out asdf_log asdf_exp asdf_10. I want to write another macro, macro B, that takes the output from the first macro and appends it together into a new macro variable.

%macro B(varList, outputName);
    %let &outputName = 
        %A(var1);
        %A(var2);
        ;
%mend

Is almost what I want to do, except that it obviously doesn't compile. I am also not sure if this is possible in SAS. As a further complication, the input to macro B is a list of variable that I want to run macro A for and append into one long list of variable names.

Why? Because I have a macro that runs on a list of variables and I want to run it on a transformed variable list.

Example: I have %let varList = x y; and I want as an output x_log x_exp x_10 y_log y_exp y_10. To do this I want two macros one, macro A, that returns the transformed variables names:

%macro A(var);
    &var._log
    &var._exp
    &var._10
%mend

I can't get the second macro (B as written above) to work properly.

Upvotes: 1

Views: 160

Answers (2)

Tom
Tom

Reputation: 51566

So if the inner macro is just returning characters, that is it doesn't actually generate any non macro statements, then why not make the outer one work the same way?

%macro inner(x);
  &x._log &x._exp &x._10
%mend;

%macro outer(list);
%local i;
%do i=1 %to %sysfunc(countw(&list));
 %inner(%scan(&list,&i))
%end;
%mend outer;

%let want=%outer(X y Z);

Upvotes: 2

DomPazz
DomPazz

Reputation: 12465

This is not too hard. You need to loop over the values in varList, appending results to outputName. You also need to declare outputName as GLOBAL so it will be accessible outside %B

%macro B(varList, outputName);
%global &outputName;
%let &outputName = ;

%local i n var;
%let n = %sysfunc(countw(&varList));

%do i=1 %to &n;
   %let var = %scan(&varList,&i);
   %let &outputName = &outputName %A(&var);
%end;
%mend;

Upvotes: 2

Related Questions