BookmarkSubscribeRSS Feed
Taliah
Quartz | Level 8

Hello

I need to build a statistical model using monthly data (each row is one month) predicting for each row the sum of variable Y for the next 12 months. I am using proc autoreg, and am getting Durbin Watson below or around 1 (i.e., autocorrelation in the data even after including AR variables). I understand why that is happening, as the model is predicting the sum of variable y for the following 12 rows. Any solution will be helpfull. Thank you.

1 REPLY 1
sbxkoenk
SAS Super FREQ

I'm not sure I understand the full "depth" of your question and you haven't shared any code that could make me wiser.

But why don't you proceed with monthly data doing monthly forecasting (for the next 12 months ... lead=12)?

That yearly sum you need, can be done later in a post-processing data step. If you only need point forecasts, that may be the way-to-go. If you also need interval forecasts (confidence interval) then it becomes a bit more complicated.

 

Koen

SAS Innovate 2025: Register Now

Registration is now open for SAS Innovate 2025 , our biggest and most exciting global event of the year! Join us in Orlando, FL, May 6-9.
Sign up by Dec. 31 to get the 2024 rate of just $495.
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
  • 669 views
  • 0 likes
  • 2 in conversation