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

Hi,

I have built some ARIMA models based on the true drivers of the response variable.

I want to generate forecasts of the response based on new values of the predictors with same set of parameter estimates.

Please help me understand how to achieve this and how prepare the new dataset required.

Thanks very much in advance.

Regards

1 ACCEPTED SOLUTION

Accepted Solutions
udo_sas
SAS Employee

Hello -

Thanks for clarification - the p-values should not matter, indeed.

At this point in time it is probably better to open a ticket with Technical Support, who can assist with tracking down this problem.

Thanks,

Udo

View solution in original post

6 REPLIES 6
udo_sas
SAS Employee

Hello -

If using Forecast Studio all you have to do is to append the new history to the data set which you used to build the models.

Then, when you open your project you will be prompted what you would like to do.

One of the options if to reuse existing models and existing parameter:

"Forecast: refresh the current forecast model, using the same parameter values"

That should do the trick.

You can accomplish the same by using HPFENGINE of course.

Thanks,

Udo

udo_sas
SAS Employee

PS: by the way - using the scenario analysis feature of SAS Forecast Studio you will be able to change future values of your predictor variables interactively.

DrSharma
Calcite | Level 5

Hi Udo,

Actually, I had some 20 time series to model and project for next 6 months.

Initially I had kept 50 data points (Apr'08 till May'12) to train the model and next 12 data points (Jun'12 to May'13) for validation.

So, I had 62 data points in the dataset for each of the 20 series being analyzed.

After building the models I replaced the dataset with new updated one having the next 6 future values of the x variables with response

variable values as missing.

I chose the same option as you've mentioned "Forecast: refresh the current forecast model, using the same parameter values".

But I still obtained the same future forecast values as I saw before updating the dataset with new values of x variables.

I thought I was making some mistake. Could you please shed some light?

Thanks once again.

udo_sas
SAS Employee

Hello -

Please excuse for asking the obvious, but were the x variables included to your winning models?

Also, when you say validation data points, are you talking about hold-out samples or out-of-sample data?

How different are your next x values from the previous values and what do the parameter estimates for the x values look like?

Maybe your expectation about the impact of the x variables does not hold true?

Thanks,

Udo

DrSharma
Calcite | Level 5

Hi Udo,

Yes, the winning models were having the the x variables included.

By validation data I meant the holdout sample.

The new x values are significantly different but within the expected range, look normal as the rest of the values.

The parameter estimates of the transfer model components take different combinations, sometimes with very small p-values, and sometime with very high values. But the p-values do matter here?

Thanks for your time

udo_sas
SAS Employee

Hello -

Thanks for clarification - the p-values should not matter, indeed.

At this point in time it is probably better to open a ticket with Technical Support, who can assist with tracking down this problem.

Thanks,

Udo

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

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