Desktop productivity for business analysts and programmers

Calculating Sum Across Rolling Years

Reply
Occasional Contributor
Posts: 7

Calculating Sum Across Rolling Years

Good afternoon,

 

I need to calculate a number of events (sum) within rolling 12 month periods. The date format is 'DDMMMYYYY'  with a 2 year (24 month) range, and I need to report this at person level.  I haven't developed any code yet.  I am using SAS EG and would like some guidance at your earliest convenience please.

 

Kind Thanks,

Jordana

Super User
Posts: 19,039

Re: Calculating Sum Across Rolling Years

Do you have a license for SAS/ETS?

If so, look at PROC EXPAND, the third example in the documentation shows how to calculate rolling stats.

 

Otherwise, there are many ways...a temporary array is a common method:

 

Here's an example for a moving window of 4 and min/max. You can replace that with SUM/MEAN or whatever rolling stats you're interested in.

Occasional Contributor
Posts: 7

Re: Calculating Sum Across Rolling Years

Hi Reeza,

 

Thanks for your response.  I only have access to SAS EG.  Is there an example that was attached with your reply, if so, it didn't come across.  I am ready to try a solution any time.

 

Kind thanks,

Jordana

Super User
Posts: 19,039

Re: Calculating Sum Across Rolling Years

Sorry, here it is:

 

https://gist.github.com/statgeek/27e23c015eae7953eff2

 

ETS is a module, you may still have it in EG.

It's under Tasks>Time Series>Prepare Time Series Data

On the left hand menu there's something called transformations that will allow you to create rolling/moving stats.

 

Occasional Contributor
Posts: 7

Re: Calculating Sum Across Rolling Years

Thanks for your assistance.  I was able to find another solution that worked. 

 

Best,

 

Jordana

Ask a Question
Discussion stats
  • 4 replies
  • 204 views
  • 0 likes
  • 2 in conversation