Hello Guys, need your help in macro. below is my code. %let a1=1; %let a2=2; %let a3=3; %let a4=4; %let a5=5; %let a6=; %let a7=; %let a8=; %let a9=; %let a10=; %macro export; %do i = 1 %to &nod; %let nm&i = &&nm&i; proc sort data = db.&&nm&i out = &&nm&i; by &subject; run; data db1.&&nm&i; set &&nm&i; by &subject; where &subject in (&a1,&a2,&a3,&a4,&a5); ***************provide subject/patient number for output data set***********************; run; %end; %mend export; %export; now i want the result on the base of my macroparameters means if i fillup 5 macro para then in my where condition it should took only 5 variables and if i fill up 10 then it should take 10 values.i have highlited the part. is it possible ? kindly guide me. Thanks, Chirayu
... View more