concatenate string to macro variable

subrat1 — Thu, 01 Feb 2018 05:08:22 GMT

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)

Re: concatenate string to macro variable

kiranv_ — Thu, 01 Feb 2018 06:06:37 GMT

try something like this

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

topic Re: concatenate string to macro variable in SAS Programming

concatenate string to macro variable

Re: concatenate string to macro variable