Advantages and disadvantages comparison of time-series forecast computing via microsoft excel and three different SAS products

Dewi Rahardja
DOI: https://doi.org/10.47974/jsms-983
2024-01-01
Journal of Statistics and Management Systems
Abstract:Forecasts are never as accurate as organizations need or desire them to be. Yet, lots of forecasting consultants and software vendors are willing to take organizations money in exchange for unfulfilled promises (SAS, 2019). Hence, for users and/or organizations to manage their expectations, we emphasized that it is unrealistic to expect any computation software to produce perfect outputs or forecasts since nothing works perfectly in this world. Therefore, in this paper, we compared the advantages and disadvantages (pros and cons) of Time-Series (TS) forecast computation via the Microsoft Excel (FORECAST.ETS) built-in function and the three different SAS products, prescribed as a roadmap (Rahardja, 2020). Those three SAS products are the SAS Forecast Studio 14.1 drop-down menu, the SAS/ETS 9.4 drop-down menu, and the SAS/ETS 9.4 manual coding procedures or PROCs. Finally, we summarize our conclusion and recommendations for users and/or organizations.
What problem does this paper attempt to address?