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: Save the Date

 SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!

Save the date!

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