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

SAS Innovate 2025: Call for Content

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!

Submit your idea!

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

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