BookmarkSubscribeRSS Feed
Calcite | Level 5

I have attached the code I have used to generate the outputs in the pdf below. 


I am struggling to find the right statements in my forecasts that would accurately forecast November 2020 and further months.Covid-19 has impacted the data and created a new level starting March 2020 to October 2020. This new level should be the starting point I know but I want to apply this level at the seasonality shown in 2017 through 2019. 


All of which routinely shows November and December taking a big dip from October. The drop from October to November in the years 2017 to 2019 is around 6,000. So I would expect to create a forecast that could predict November being between 22k and 25k. I would want to forecast for 12 months and show the trend gradually getting back to pre covid volumes. 


Thank you SAS community!


ods graphics on;
proc arima data=Nonship_Labor_Combined_Date plots(only)=(forecast(forecast forecastonly));
identify var=trans;
estimate p=1 q=1;
/*outlier type=(ls tc(6 12)) alpha=0.001 sigma=mse maxnum= 5 id=new_date; */
forecast lead=12 interval=month id=new_date nooutall out=results;


ods graphics on;
proc ucm data=shift_trans plots=all;
id new_date interval=month;
model trans = shiftMar2020;
slope variance=0 noest;season length=12 type=trig print=smooth;
forecast lead=12 print= (decomp forecasts);



Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.

If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website. 

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
  • 0 replies
  • 1 in conversation