topic Re: sum several variables by group in SAS Procedures

sum several variables by group

hua — Wed, 10 May 2017 15:24:05 GMT

Hello All,

I have several columns: station year a b c d e f g ....

And I want to sum a,b,c,d,e,f,g,... by year.

DO I need to use macro or sql? And how to do it?

I would greatly appreciate it if any one can have any ideas!

Thanks a lot!

LinusH — Wed, 10 May 2017 15:25:41 GMT

SQL
MEANS/SUMMARY

Tom — Wed, 10 May 2017 16:26:07 GMT

Use PROC SUMMARY.

proc summary  data=have nway ;
  by station year;
  var  a b c d e f g ....;
  output out=want sum= ;
run;

hua — Wed, 10 May 2017 17:06:33 GMT

Thanks you!
output out=want sum=a_sum b_sum c_sum ... ;
Is this correct? Will this give me the corresponding sum for all the variables?

hua — Wed, 10 May 2017 17:07:07 GMT

Do you know how to do sql?

hua — Wed, 10 May 2017 17:07:18 GMT

Thank you!

Reeza — Wed, 10 May 2017 17:46:08 GMT