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; run; quit;   ods graphics on; proc ucm data=shift_trans plots=all; id new_date interval=month; model trans = shiftMar2020; level; slope variance=0 noest;season length=12 type=trig print=smooth; irregular; estimate; forecast lead=12 print= (decomp forecasts); run; ... View more

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; run; quit;   ods graphics on; proc ucm data=shift_trans plots=all; id new_date interval=month; model trans = shiftMar2020; level; slope variance=0 noest;season length=12 type=trig print=smooth; irregular; estimate; forecast lead=12 print= (decomp forecasts); run; ... View more

I currently have Loc_NO, Trns_Date, Hour, Qtr Hour.  How do I create a variable that reads hours 0 to 23 and Qtr_Hour 1 to 4 and outputs the appropriate time? (12:15 AM, etc) Sample code is below the chart.     Proc SQL; Create Table Work.Shipping_Qtr_Hour_Revenue AS           Select Loc_No,Trns_Date,Hour,Qtr_Hour,Revenue,          From Qtr_Hour_Revenue_All Group By Loc_No,Trns_Date,Hour,Qtr_Hour ; Quit; ... View more

One table was created to have all possibilities of Location_Number, Date, Hour, Quarter_Hour.   I have three tables with all four of these values and I want to pull the specefic revenue amount in each table that corresponds to the Location_Number, Date, Hour, and Quarter_Hour.   Can someone give me some sample code to get moving on joining up all Revenue from these three tables while keeping the revenue seperate from each table and revenue it pulls. (Example Pull Revenue A table when (Location_Number=Date=Hour=Quarter_Hour) then output name as Revenue A Table, repeat for Revenue B Table, Revenue C Table) ... View more

I have the following macro that allows me to pull all information for the most recent months into my analysis.   %let calyear = 2016; %let month = 10; %let YYYYMM = 201610; I have to change the month, year, & calyear as needed.   Let's say I wanted to schedule this proces to run on the 15th of every month and it would always pull the previous month? I have four process flows that link to these variables and pull the data.   Does anyone have any tips on this?   Thanks Scottie      ... View more