topic Re: Macro for multiple values in SAS Programming

Macro for multiple values

BrahmanandaRao — Mon, 07 Feb 2022 08:51:14 GMT

proc sql;
 select name,sex,age into  :n  seperated by ', ' from sashelp.class
 where name='William';
quit;

%put &=n. ;
%put &=a. ;
%put &=b. ;

I want name ,sex and age values in log window

Re: Macro for multiple values

PeterClemmensen — Mon, 07 Feb 2022 09:11:28 GMT

Do you want the values in separate macro variables or in one macro variable?

Re: Macro for multiple values

s_lassen — Mon, 07 Feb 2022 11:06:32 GMT

I assume what you want is something like this:

proc sql noprint;
 select name,sex,age into  :n,:s,:a from sashelp.class
 where name='William';
quit;

%put &=n. ;
%put &=a. ;
%put &=b. ;

I put in the NOPRINT option for the procedure, as I assume you do not want the print as well as the log lines.

The guide to SELECT ... INTO is here

Re: Macro for multiple values

andreas_lds — Mon, 07 Feb 2022 11:31:39 GMT

Storing data in macro-variables almost always leads to unnecessary difficult code. So, because i am curious, what are the next steps?

Re: Macro for multiple values

PaigeMiller — Mon, 07 Feb 2022 12:05:30 GMT

@BrahmanandaRao wrote:
proc sql;
 select name,sex,age into  :n  seperated by ', ' from sashelp.class
 where name='William';
quit;

%put &=n. ;
%put &=a. ;
%put &=b. ;
I want name ,sex and age values in log window

Others have given valuable advice.

Please, @BrahmanandaRao, from now on let's get the terminology correct so we can all avoid confusion. You are not talking about a "macro". You are talking about macro variables. Do not call macro variables by the name "macro". A macro is something different.

Re: Macro for multiple values

ballardw — Mon, 07 Feb 2022 16:18:22 GMT

@BrahmanandaRao wrote:
proc sql;
 select name,sex,age into  :n  seperated by ', ' from sashelp.class
 where name='William';
quit;

%put &=n. ;
%put &=a. ;
%put &=b. ;
I want name ,sex and age values in log window

data _null_;
   set sashelp.class;
   put name sex age;
run;

SQL does not write much to the log. The data step Put statement will unless you provide a target File. Or use the PUTLOG statement to limit output to the log only.