create a prompt to select multiple items

[mrdlau]

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]

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]

%let n=Alfred Barbara;

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