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;
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.