BookmarkSubscribeRSS Feed
kwilz
Calcite | Level 5

Hello,

Working on forecasting sales for my business. I have weekly sales data from 01/07/18 to 6/19/22.

 

kwilz_0-1668408194992.png

 

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;

 

 

1 REPLY 1

Catch up on SAS Innovate 2026

Nearly 200 sessions are now available on demand with the SAS Innovate Digital Pass.

Explore Now →
How to Concatenate Values

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 1 reply
  • 1293 views
  • 1 like
  • 2 in conversation