proc means 12 months

[jenim514]

Hi I have a table with health encounters over a 5 year period.  I want to find the 12 month mean.  Is there are way to specifiy this in a proc means statement?

I have

proc means data= mf_encounterdays;

var tot_enc;

run;

But Im obviuously getting the mean over the 5 years.

Thanks!!

[Reeza · Accepted solution]

Filter your data to a 12 month period using a WHERE statement.

I've included 2 samples below, they will evaluate to the same condition. Only one should be included at a time. Depending on your data there may be other ways.

proc means data= mf_encounterdays;
where date between "01Jan2015"d and "31Dec2015"d;
*Where year(date) = 2015;
var tot_enc;
run;