topic Re: How to use the MEAN function in Statistical Procedures

How to use the MEAN function

valerieyim — Thu, 08 Oct 2020 03:07:30 GMT

Hello SAS Communities,

I would need to use the MEAN function to to calculate the average daily rainfall.

Suppose I have data on the rainfall in my city, with the variables 'Day1', 'Day2,'...,'Day365' containing the value of rainfall for each day of the year.

How should I write my MEAN function?

Thanks!

Re: How to use the MEAN function

novinosrin — Thu, 08 Oct 2020 03:12:58 GMT

avg=mean(of day1-day365);

Re: How to use the MEAN function

Reeza — Thu, 08 Oct 2020 03:14:25 GMT

That isn't enough information to answer you question.
SAS processes data differently if it's in rows or columns so what works for one data structure won't work for a different data structure.

Here's a rough idea of how to do By group processing within PROC MEANS which seems to be what you're trying to do....there really isn't a good paper or guide on PROC MEANS that I've seen yet to recommend 😞

https://github.com/statgeek/SAS-Tutorials/blob/master/proc_means_basic.sas

Re: How to use the MEAN function

Kurt_Bremser — Thu, 08 Oct 2020 06:13:07 GMT

First transpose to a long dataset, then use PROC MEANS.

For detailed help, post usable example data in a data step with datalines.