INTO Clause issue storing values in macro

chirumalla — Tue, 20 May 2014 04:05:41 GMT

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 ν

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

Re: INTO Clause issue storing values in macro

art297 — Tue, 20 May 2014 04:21:33 GMT

select num into: nu

separated by ' '

topic INTO Clause issue storing values in macro in SAS Procedures

INTO Clause issue storing values in macro

Re: INTO Clause issue storing values in macro