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;
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
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.