Solved: Macros - SAS Support Communities

🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.

Fluorite | Level 6

Fluorite | Level 6

Macros

Posted 12-05-2018 12:49 AM (933 views)

how can we pass different values of a variable to macro variable?

1 ACCEPTED SOLUTION

Accepted Solutions

Barite | Level 11

Barite | Level 11

Re: Macros

Posted 12-05-2018 01:04 AM (929 views) | In reply to ravindra2

With proc sql like so:

Data A;
  Do n = "ASFE", "ISFE", "SFXE";
    Output;
  End;
Run;

Proc SQL NoPrint;
  Select n Into :n Separated By "," From A;
Quit; 
%Put **&n.***;
* **ASFE,ISFE,SFXE***;

View solution in original post

1 REPLY 1

Barite | Level 11

Barite | Level 11

Re: Macros

Posted 12-05-2018 01:04 AM (930 views) | In reply to ravindra2

With proc sql like so:

Data A;
  Do n = "ASFE", "ISFE", "SFXE";
    Output;
  End;
Run;

Proc SQL NoPrint;
  Select n Into :n Separated By "," From A;
Quit; 
%Put **&n.***;
* **ASFE,ISFE,SFXE***;