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

Thanks for response , when we use &&var&varcount; we get  Severe that is last value but in dataset we have 3 unique macrovaribles all these three need to store in your macro varaible.   I am trying create a macro varaible which should contain all unique values  , For example if in var1- mild var2-moderate v3-severe but i want to use :var9999 because when there is update to my data i should not change my macro varaible to var4 etc....   Thanks for your help ... View more

@Kurt_Bremser@Yes ur correct, but when I call macro I need to suppress warning. ... View more