02-10-2018 08:42 PM
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?
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;
Need further help from the community? Please ask a new question.