sum several variables by group

[hua]

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]

SQL
MEANS/SUMMARY

[hua]

Do you know how to do sql?

[Reeza]

http://support.sas.com/kb/25/279.html

[hua]

Thank you!

[Tom]

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]

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?