DATA Step, Macro, Functions and more

concatenate string to macro variable

Accepted Solution Solved
Reply
Contributor
Posts: 58
Accepted Solution

concatenate string to macro variable

Proc sql;
select name into :sum_count SEPARATED by " ," from x13
where upper(name) like 'COUNT%' ;
quit;

%put &sum_count;

my output is  : 

Count_121117 ,Count_121817 ,Count_122617 ,Count_010218 ,Count_010818 ,Count_011518 ,Count_012218 ,Count_012918

But I want my output : Sum(Count_121117) , Sum(Count_121817) , Sum(Count_122617 ),  Sum(Count_010218 ), Sum(Count_010818)Sum(Count_011518) , Sum(Count_012218 ), Sum(Count_012918)

Accepted Solutions
Solution
‎02-01-2018 01:09 AM
PROC Star
Posts: 549

Re: concatenate string to macro variable

[ Edited ]

try something like this 

Proc sql noprint;
select cats("sum(", name,")")  into :sum_count SEPARATED by " , " from x13
where upper(name) like 'COUNT%' ;
quit;

View solution in original post


All Replies
Solution
‎02-01-2018 01:09 AM
PROC Star
Posts: 549

Re: concatenate string to macro variable

[ Edited ]

try something like this 

Proc sql noprint;
select cats("sum(", name,")")  into :sum_count SEPARATED by " , " from x13
where upper(name) like 'COUNT%' ;
quit;
☑ This topic is solved.

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

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