Help using Base SAS procedures

INTO Clause issue storing values in macro

Accepted Solution Solved
Reply
Contributor
Posts: 41
Accepted Solution

INTO Clause issue storing values in macro

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.


Accepted Solutions
Solution
‎05-20-2014 12:21 AM
PROC Star
Posts: 7,492

Re: INTO Clause issue storing values in macro

Posted in reply to chirumalla

select num into: nu

   separated by ' '


View solution in original post


All Replies
Solution
‎05-20-2014 12:21 AM
PROC Star
Posts: 7,492

Re: INTO Clause issue storing values in macro

Posted in reply to chirumalla

select num into: nu

   separated by ' '


🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 1 reply
  • 135 views
  • 0 likes
  • 2 in conversation