BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
Aaron_01
Calcite | Level 5

Hi All,

 

 

I have an ARIMA model that was generated by Forecast Studio. The model has an input series (independent variable) used to forecast the dependent variable. As I have not provided any future values for the input series, Forecast Studio must be generating a forecast for the input series which it then feeds into the model for the dependent variable. I am trying to find the specific model formulation used to generate a forecast for the input series but cannot figure out how to see this in Forecast Studio.

 

Any help would be appreciated.

1 ACCEPTED SOLUTION

Accepted Solutions
alexchien
Pyrite | Level 9

To be a bit more specific, by default Forecast Studio uses one of the following smoothing models to extend the future input variable values:
• simple
• double
• linear
• damped trend
• seasonal
• Winters method (additive and multiplicative)
The model with the smallest in-sample MAPE is used to forecast the future values of the input.

 

You can use PROC HPF method = BEST to reproduce the Forecast Studio result if you have the Forecast Server license. If you only have the license for Forecast Studio Desktop version, you will have to run PROC ESM for all the models listed above and pick the model with the smallest in-sample MAPE. 

 

I would suggest feeding the Forecast Studio with future input values (and set the lead = 0) if you do have them available. Often time it is inappropriate to forecast future input variable values if they are not stochastic. For example, promotions, events, etc. Having Forecast Studio to generate forecasts for non-stochastic input variables could distort the shape of the forecasts into the future.

View solution in original post

2 REPLIES 2
Ksharp
Super User
use PROC ESM to that input variable.

alexchien
Pyrite | Level 9

To be a bit more specific, by default Forecast Studio uses one of the following smoothing models to extend the future input variable values:
• simple
• double
• linear
• damped trend
• seasonal
• Winters method (additive and multiplicative)
The model with the smallest in-sample MAPE is used to forecast the future values of the input.

 

You can use PROC HPF method = BEST to reproduce the Forecast Studio result if you have the Forecast Server license. If you only have the license for Forecast Studio Desktop version, you will have to run PROC ESM for all the models listed above and pick the model with the smallest in-sample MAPE. 

 

I would suggest feeding the Forecast Studio with future input values (and set the lead = 0) if you do have them available. Often time it is inappropriate to forecast future input variable values if they are not stochastic. For example, promotions, events, etc. Having Forecast Studio to generate forecasts for non-stochastic input variables could distort the shape of the forecasts into the future.

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
  • 2 replies
  • 1063 views
  • 0 likes
  • 3 in conversation