topic Re: proc means 12 months in SAS Procedures

proc means 12 months

jenim514 — Wed, 24 Feb 2016 17:47:19 GMT

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!!

Re: proc means 12 months

Reeza — Wed, 24 Feb 2016 17:51:42 GMT

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;