select from a list stored in a macro

SIgnificatif — Tue, 07 May 2019 08:24:44 GMT

Hi all,

I'm creating the following program:

data test;
set WORK.table1;
where id like &myid;
run;

and the contents of the %let myid variables are like this :

%let myid =
11544,
1244,
12477
;

Ho to make this work ? ( select where id = 11544, 1244 and 12477) ? I mean selecting values from a list in a macro ? in the standard sas and the proc SQL ?

Thank you for your response.

Re: select from a list stored in a macro

Jagadishkatam — Tue, 07 May 2019 08:46:44 GMT

try the in operator

data test;
set WORK.table1;
where id in (&myid);
run;

topic Re: select from a list stored in a macro in New SAS User

select from a list stored in a macro

Re: select from a list stored in a macro