SAS Procedures

Help using Base SAS procedures
BookmarkSubscribeRSS Feed
hua
Obsidian | Level 7 hua
Obsidian | Level 7

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!

6 REPLIES 6
LinusH
Tourmaline | Level 20
SQL
MEANS/SUMMARY
Data never sleeps
hua
Obsidian | Level 7 hua
Obsidian | Level 7
Do you know how to do sql?
hua
Obsidian | Level 7 hua
Obsidian | Level 7
Thank you!
Tom
Super User Tom
Super User

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
Obsidian | Level 7 hua
Obsidian | Level 7
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?

sas-innovate-wordmark-2025-midnight.png

Register Today!

Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.


Register now!

What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 6 replies
  • 1374 views
  • 0 likes
  • 4 in conversation