04-10-2018 12:22 AM
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?
04-10-2018 12:36 AM
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!