topic Re: create two macro variables in proc sql in SAS Programming

create two macro variables in proc sql

kumarK — Mon, 18 May 2015 17:46:23 GMT

Hi,

Why this code is giving error? How can we create two macro variables through into option.

Proc sql noprint outobs=1;

select name into:bname, age into:bage from sashelp.class;

quit;

%put &bname &bage;

Thanks...

PGStats — Mon, 18 May 2015 17:55:24 GMT

Because the code hasn't the proper syntax, which is :

Proc sql noprint;

select name, age into:bname, :bage from sashelp.class;

quit;

%put &bname &bage;

Which record do you want anyway?

kumarK — Mon, 18 May 2015 18:08:10 GMT

Thanks for reply. This is the generic question i have asked. i will put conditions in where clause.