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...
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?
PG
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?
PG
Thanks for reply. This is the generic question i have asked. i will put conditions in where clause.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.