concatenate string to macro variable

[subrat1]

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)

[kiranv_ · Accepted solution]

try something like this 

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