DATA Step, Macro, Functions and more

create a prompt to select multiple items

Reply
Contributor
Posts: 36

create a prompt to select multiple items

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?

PROC Star
Posts: 1,282

Re: create a prompt to select multiple items

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!

 

 

Super User
Posts: 10,609

Re: create a prompt to select multiple items

%let n=Alfred Barbara;

proc sql;
select *
from sashelp.class
where indexw(symget('n'),strip(name));
quit;
Ask a Question
Discussion stats
  • 2 replies
  • 77 views
  • 0 likes
  • 3 in conversation