topic Re: Calculating Sum Across Rolling Years in SAS Enterprise Guide

Calculating Sum Across Rolling Years

Jordana_Anthem — Tue, 27 Jun 2017 17:32:02 GMT

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

Re: Calculating Sum Across Rolling Years

Reeza — Tue, 27 Jun 2017 18:36:24 GMT

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.

Re: Calculating Sum Across Rolling Years

Jordana_Anthem — Tue, 27 Jun 2017 18:44:10 GMT

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

Re: Calculating Sum Across Rolling Years

Reeza — Tue, 27 Jun 2017 18:49:57 GMT

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.

Re: Calculating Sum Across Rolling Years

Jordana_Anthem — Mon, 10 Jul 2017 13:43:18 GMT

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

Best,

Jordana