https://communities.sas.com/t5/SAS-Programming/efficient-sum-for-many-columns/m-p/436042#M108392 <PRE><CODE class=" language-sas">proc means data=have; var agerisk:; output out=want(drop=_type_ _freq_) sum=/autoname; run;</CODE></PRE> Sun, 11 Feb 2018 02:09:49 GMT novinosrin 2018-02-11T02:09:49Z https://communities.sas.com/t5/SAS-Programming/efficient-sum-for-many-columns/m-p/436039#M108389 <P>I'd like to calculate 55 separate column totals for agerisk1-agerisk55. There must be efficient way doing it right? My Sql shown below is tedious. Any suggestions?</P><P>&nbsp;</P><PRE><CODE class=" language-sas">data temp; input tot_pop agerisk; datalines; 15286 0.055 57522 0.217 28017 0.066 21669 0.064 17853 0.071 ; proc sql; select sum(agerisk1) as sum_agerisk1, ....sum(agerisk55) as sum_agerisk55 from test; quit;</CODE></PRE><P>&nbsp;</P> Sun, 11 Feb 2018 01:42:53 GMT https://communities.sas.com/t5/SAS-Programming/efficient-sum-for-many-columns/m-p/436039#M108389 Cruise 2018-02-11T01:42:53Z https://communities.sas.com/t5/SAS-Programming/efficient-sum-for-many-columns/m-p/436042#M108392 <PRE><CODE class=" language-sas">proc means data=have; var agerisk:; output out=want(drop=_type_ _freq_) sum=/autoname; run;</CODE></PRE> Sun, 11 Feb 2018 02:09:49 GMT https://communities.sas.com/t5/SAS-Programming/efficient-sum-for-many-columns/m-p/436042#M108392 novinosrin 2018-02-11T02:09:49Z