Help using Base SAS procedures

Mathematical form of an ARIMA model

Not applicable
Posts: 0

Mathematical form of an ARIMA model

I created an ARIMA model in SAS, but I need to implement the formula
for the forecasts in Excel. Below is the SAS code for the model. The model is
AR(5,10,15,20) MA(1,5) with differencing of 5 periods.

proc arima data=test;
identify var=calls (5) nlag=49;
estimate p=(5 10 15 20) q=(1 5);

I tried using Y(t)-Y(t-5)=Mu+MA/AR, but the forecasts on the spreadsheet are still different from the SAS output. This notation is based on a document from SAS Support here:

Can you please help me with translating the ARIMA forecast to Excel? Thank you.
SAS Employee
Posts: 417

Re: Mathematical form of an ARIMA model

Posted in reply to deleted_user
Ask a Question
Discussion stats
  • 1 reply
  • 2 in conversation