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)
try something like this
Proc sql noprint;
select cats("sum(", name,")") into :sum_count SEPARATED by " , " from x13
where upper(name) like 'COUNT%' ;
quit;
try something like this
Proc sql noprint;
select cats("sum(", name,")") into :sum_count SEPARATED by " , " from x13
where upper(name) like 'COUNT%' ;
quit;
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.