BookmarkSubscribeRSS Feed
sassygrl
Calcite | Level 5
I'm attempting to self-study time series analysis and the SAS/ETS system. Using Proc ARIMA, I think I've established some decent methods for identifying/evaluating trend, seasonality, stationarity, and potential models.

However, today I walked through the process of fitting models automatically using the Time Series Forecasting System (point & click), and a "Winters Method -- Additive" model was suggested as the best. When I select to "Show Source Statements" nothing is shown for this model, so I'm not sure how to reproduce it programmatically (except in Proc Forecast, but I don't see how to evaluate model fit with this procedure).

My question is, how might I have identified "Winters Method -- Additive" as a candidate model, and compared with other candidate models, programmatically? I realize this may be more of a theoretical question than syntax, but either form of insight would be welcome. I'd prefer to understand the process than to rely on an automatic procedure. Thanks!


****** (update) ******
I want to add, I did read that "The ARIMA model equivalency to the additive version of Winters method is the ARIMA(0,1,p+1)(0,1,0)p model." When I tried the following code,

identify var=sales(1,12);
estimate q=13;

I get the error message that there is not enough data to fit the model. Am I misinterpreting (p+1)? Thanks again!

Message was edited by: sassygrl
2 REPLIES 2
udo_sas
SAS Employee
Hello -
Although the Time Series Forecasting System (TSFS) uses PROC ARIMA behind the scenes to generate the parameter estimates and forecasts for the ARIMA models, the TSFS uses SCL and C routines to generate the parameter estimates and forecasts for the exponential smoothing models. There is no procedure in the SAS/ETS product in SAS 9.1.3 which can be used to reproduce the forecasts for the exponential smoothing models generated by the TSFS. Although PROC FORECAST can be used to fit a class of exponential smoothing models, this procedure does not optimize the smoothing weights and it uses a different start-up algorithm than the one used in TSFS.
In SAS 9.2, we have a new procedure in the SAS/ETS product called PROC ESM which can be used to reproduce or come very close to the results generated for the exponential smoothing models fit and forecasted by the Time Series Forecasting System.
Link to the SAS 9.2 documentation on PROC ESM:
http://support.sas.com/documentation/cdl/en/etsug/60372/HTML/default/esm_toc.htm
Hope that helps,
Udo
sassygrl
Calcite | Level 5
Wonderful insight. Thank you very much!!

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