topic Macro in SAS Programming

Macro

georgel — Thu, 23 Sep 2021 08:31:06 GMT

Hi all,

I would like to include more than one arguments in each parameter of following macro. For example, in the position of ys to have more than one ys and the parameter xs to have more than one x. Please see the code below


%macro multireg(ys=, yhats= ,xs=);
       
proc robustreg data=want outest=est noprint;
      model &ys = &xs  lnnum_lu ;
   output out=want
      p= &yhats;
quit;

%mend multireg;


%multireg(ys=bhared_3y , yhats= bhared_3yhatm1, xs=lupe);

I want to run a code for multiple regressions e.g

%multireg(ys=bhared_3y bhared_2y bhared_1y, yhats= bhared_3yhatm1 bhared_2yhatm1 bhared_1yhatm1, xs=lupe x1 x2);

Thank you very much in advance

Regards

George

Re: Macro

Patrick — Thu, 23 Sep 2021 09:51:57 GMT

Couldn't you just call the macro multiple times passing in different parameter values?

Re: Macro

ballardw — Thu, 23 Sep 2021 15:30:33 GMT

Show the code you want to generate without macro variables that uses 2 or more response variables (Ys) that generates desired output.

Then we can help you.

Re: Macro

Quentin — Thu, 23 Sep 2021 15:58:57 GMT

Agree, show the generated code you would want from your macro call where you past the lists. Would you want 3 PROC steps? 3 model statements? 9 proc steps?...