The data I am working with consists of airline revenue, passenger, and airfare by week and split by four travel regions, dating back to year 2011. The goal for me is to produce a weekly forecast of the three metrics mentioned before. I need to be able to account for when a holiday is occurring for a particular week and what I learned from SAS' support team is that both ARIMA and UCM can be used to account for such events so I decided to try out ARIMA. To account for the holiday effect I set up some variables for each holiday of interest (Christmas, Thanksgiving, Independence Day, etc.) that have 1's to indicate if the holiday occurred or will occur on that week. Then in PROC ARIMA I use the crosscorr option in the identify statement and the input option in the estimate statement to list the holiday variables. The results are not working as well as I expected as some of the predictions for some of the holidays don't make as much of an adjustment as I would expect. Am I going about this the correct way? Are there other ways of tackling this problem? proc arima data=fare_data
plots=all
out=fare_fcast;
identify
var=log_fare(1,52)
crosscorr=(christmas independence_day thanksgiving memorial_day labor_day new_year)
stationarity=(adf=(1,2));
estimate
q=(1)(52)
input=(christmas independence_day thanksgiving memorial_day labor_day new_year)
method=ml
outest=estimates;
outlier id=wk_end_dt;
forecast lead=57 id=wk_end_dt interval=week align=middle printall;
run;
... View more