This works:- proc sql ; select distinct(AETOXGRC) into :var1-:var9999 from ae; quit; %let varcount = &Sqlobs; %put &&var&varcount; %macro putit; %do i=1 %to &sqlobs; %put var&i = &&var&i; %end; %mend putit; %putit Thanks for your time,The challenge will come when we call seperate (&var1,&var2...) macro varaible for other calculation again we need to check data , i will try standize this as well... thanks alot
... View more
