I'm have a code as show below:
proc sql;
select *
from table
where ID in %bquote('&ID');
quit;
and I want it to do the equvilant of:
proc sql;
select *
from table
where ID in ('1','2');
quit;
however, no matter how hard I try, I only get one ID with the prompt..
what could be the issue?
May i know how your macr var id was created? can you provide a sample plz?
%let n='Alfred','Barbara';
proc sql;
select *
from sashelp.class
where name in (&n);
quit;
the above illustration works without the need of macro quoting, so more info from you would be helpful. Thanks!
%let n=Alfred Barbara;
proc sql;
select *
from sashelp.class
where indexw(symget('n'),strip(name));
quit;
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.