05-20-2014 12:05 AM
I am using below code to store values in macro variable based on this vales I need to delete vales from target table but INTO clause default taking only first value pls help me how to get all values in macro variable.
input id num;
select num into: nu from work.export;
15 proc sql;
16 select num into: nu from work.export;
18 %PUT ν
I need all value 10 20 30 in &nu please help me and is their any alternate way suggest me.
Need further help from the community? Please ask a new question.