Hello,
Working on forecasting sales for my business. I have weekly sales data from 01/07/18 to 6/19/22.
I generated a Seasonal ARIMA(0,1,1)(0,1,1) 7 No Intercept model. I am running the code below and am getting the messages. I am new to this and am unsure how to correct to see forecasted values. Thank you.
| Warning: | More values of input variable AO104 are needed. |
| Warning: | More values of input variable AO153 are needed. |
| The value for option LEAD= has been reduced to 0. |
data SalesWeatherWeeklyData10_25_22;
set SalesWeatherWeeklyData10_25_22;
if _N_ = 104 then AO104 = 1; else AO104 = 0;
if _N_ = 153 then AO153 = 1; else AO153 = 0;
run;
PROC ARIMA DATA = SalesWeatherWeeklyData10_25_22 PLOTS=ALL;
IDENTIFY VAR = Sales(1, 7) crosscorr = (AO104(1,7) AO153(1,7));
ESTIMATE p=2 q=(7 ) NOCONSTANT input = (AO104 AO153) METHOD = ML ;
outlier maxnum=20 alpha=0.001;
forecast printall lead=4 out=results1;
RUN;
QUIT;
April 27 – 30 | Gaylord Texan | Grapevine, Texas
Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.