Help using Base SAS procedures

proc means 12 months

Accepted Solution Solved
Reply
Frequent Contributor
Posts: 121
Accepted Solution

proc means 12 months

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


Accepted Solutions
Solution
‎02-24-2016 01:09 PM
Super User
Posts: 17,724

Re: proc means 12 months

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;

View solution in original post


All Replies
Solution
‎02-24-2016 01:09 PM
Super User
Posts: 17,724

Re: proc means 12 months

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;
☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 1 reply
  • 215 views
  • 0 likes
  • 2 in conversation