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
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.
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
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.
Thanks for your assistance. I was able to find another solution that worked.
Best,
Jordana
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.