248 – Contributed Oral Poster Presentations: Section on Statistical Computing
Comparison of Forecasting Approaches Using SAS Proc Reg and Proc Arima with SAS Macros vs. SAS Time Series Forecasting System
Martin Selzer
Chatham Decision Sciences
This paper describes a SAS macro based program using Proc Reg and Proc Arima developed for forecasting. The program is compared to a separate forecasting process using the SAS Time Series Forecasting System (SASTSFS). Advantages of using SAS macros to automate outcomes are discussed. Forecasts are prepared with the macro based program and compared to those produced by other programs and SASTSFS. Results show that the new program gives results quite near those generated by SASTSFS. While no effort was made to compare the accuracy of the two approaches against actual results, the mathematical formulation of the statistical models used in the macro based program suggest the program would provide more accurate outcomes. The macro based approach has fewer manual interventions and produces forecasts more quickly and less prone to error.