BookmarkSubscribeRSS Feed
Chrkoch93
Calcite | Level 5

We are using Proc ARIMA to estimate daily mortality using daily time series data from the previous 4 years. There are daily trends that we would like to be captured in our model, which is why we prefer to use daily time series data instead of monthly.

 

Our issue is that we want to present our daily estimates as monthly estimates. Is there a method we could use to sum our daily estimates and calculate a 95% confidence limit around those aggregates? 

Here is the code used to produce our daily estimates:

proc arima data=filename;
identify var=COUNT (1,365) 
crosscorr=monday  
crosscorr=tuesday
crosscorr=wednesday
crosscorr=thursday
crosscorr=friday
crosscorr=saturday
crosscorr=sunday
nlag=1000 stationarity=(adf=100);
run;
estimate p=(1 2 7 30)(365) q=(1)(7)(30)(365) nostable maxiter=250 method=ml;
run; 
forecast alpha=0.05 lead=366 interval=Day id=DATE;
run;
quit;

Thank you

1 REPLY 1
Rick_SAS
SAS Super FREQ

Since no one has responded with an analytical method, I suggest using a bootstrap to compute the CIs. For time series, here are some references 

- the stationary bootstrap

- the moving block bootstrap

 

SAS INNOVATE 2024

Innovate_SAS_Blue.png

Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.

If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website. 

Register now!

Multiple Linear Regression in SAS

Learn how to run multiple linear regression models with and without interactions, presented by SAS user Alex Chaplin.

Find more tutorials on the SAS Users YouTube channel.

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