BookmarkSubscribeRSS Feed
Karteek
Calcite | Level 5


hi ..I'm trying to fit a Forecast Model using Proc Forecast. I would like to translate the Estimates into equation. Could anyone help me to code the equation and how Forecast Values in the output are calculated.

Attached is the data and forecast values (got using Method=Expo Trend=2 lead=3).

Thanks,

Karteek

2 REPLIES 2
udo_sas
SAS Employee

Hello Karteek -

Would you mind to send your PROC FORECAST code as well?

Thanks,

Udo

udo_sas
SAS Employee

Hello -

Never mind my earlier response - I guess you are running something like this (otherwise please do mind my earlier response :smileylaugh:):

proc forecast data=have method=expo trend=2 outall outest=est lead=3;

   id time;

   var actual;

run;

You will find plenty of details of how the EXPO method of the FORECAST procedure works, here:  http://support.sas.com/documentation/cdl/en/etsug/63939/HTML/default/viewer.htm#etsug_forecast_sect0...

(scroll down to EXPO Method). In particular you will find how to interpret the values of the OUTEST data set.

May I also suggest to have a look at the ESM procedure instead - for your data set the code will look similar to this (I'm proposing to consider a DAMPTREND model, but you can change that of course):

proc esm data=have out=outesm lead=3 outest=est2 plot=forecasts back=3;

   id time interval=obs;

   forecast actual / method=damptrend;

run;


which results in:

ForecastsPlot.png

Note that in this case the parameters listed in the OUTEST data set are easier to read:

OUTEST.JPG

Thanks,

Udo

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