INTO Clause issue storing values in macro

[chirumalla]

Hi,

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. 

data export;

input id num;

cards;

1 10

2 20

3 30

;

run;

proc sql;

select num into: nu from work.export;

quit;

%PUT ν

15         proc sql;

16         select num into: nu from work.export;

17         quit;

18         %PUT ν

10

I need all value 10 20 30 in &nu please help me and is their any alternate way suggest me.

[art297 · Accepted solution]

select num into: nu

   separated by ' '