Forecasting using SAS Forecast Server, SAS/ETS, and more

help on SAS code...

Reply
Occasional Contributor
Posts: 6

help on SAS code...


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

Attachment
SAS Employee
Posts: 416

Re: help on SAS code...

Hello Karteek -

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

Thanks,

Udo

SAS Employee
Posts: 416

Re: help on SAS code...

Hello -

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

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

Ask a Question
Discussion stats
  • 2 replies
  • 439 views
  • 3 likes
  • 2 in conversation