select from a list stored in a macro

[SIgnificatif]

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.

[Jagadishkatam · Accepted solution]

try the in operator

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