BookmarkSubscribeRSS Feed
Taliah
Obsidian | Level 7

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: Call for Content

Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!

Submit your idea!

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
  • 313 views
  • 0 likes
  • 2 in conversation