topic create a prompt to select multiple items in SAS Programming

create a prompt to select multiple items

mrdlau — Tue, 10 Apr 2018 04:22:23 GMT

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?

novinosrin — Tue, 10 Apr 2018 04:36:25 GMT

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!

Ksharp — Tue, 10 Apr 2018 13:02:21 GMT

%let n=Alfred Barbara;

proc sql;
select *
from sashelp.class
where indexw(symget('n'),strip(name));
quit;