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

hackathon24-white-horiz.png

The 2025 SAS Hackathon has begun!

It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.

Latest Updates

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
  • 750 views
  • 1 like
  • 2 in conversation