BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
lizzy28
Quartz | Level 8

Hi SAS Community,

 

I am running forecast for retail sales using ARIMA model. There is an input vairable available, retail_day, which is an indicator whether a day is a retail date or not: 1 for a retail date, and 0 for non-retail date. A retail date means that stores are open and that retail sales are happening.

 

As the retail calendar is planned based on the calendar, the future values are known. For example, 2/2/2016 is the first day of the retail calendar month, and 2/29/2016 is the last day/the 24th day of the retail calendar. The retail sales are low at the beginning of each month and high at the end of each month.Please see the sample data as attached.

 

Is there anyway to incorporate the input variable, retail_day, in the ARIMA model to capture the retail calendar effect? Moreover, I only have 3 year historical data, which makes it hard to do seasonal adjustment. 

 

Any suggestions?

 

Thanks a lot!

 

1 ACCEPTED SOLUTION

Accepted Solutions
YueLi
SAS Employee

Have you tried using the input option in PROC ARIMA to include the retail_day in the model? There are some examples documented in http://support.sas.com/documentation/cdl/en/etsug/66840/HTML/default/viewer.htm#etsug_arima_gettings...

View solution in original post

1 REPLY 1
YueLi
SAS Employee

Have you tried using the input option in PROC ARIMA to include the retail_day in the model? There are some examples documented in http://support.sas.com/documentation/cdl/en/etsug/66840/HTML/default/viewer.htm#etsug_arima_gettings...

sas-innovate-2024.png

Don't miss out on SAS Innovate - Register now for the FREE Livestream!

Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.

 

Register now!

Multiple Linear Regression in SAS

Learn how to run multiple linear regression models with and without interactions, presented by SAS user Alex Chaplin.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 1 reply
  • 2009 views
  • 0 likes
  • 2 in conversation