Forecasting using SAS Forecast Server, SAS/ETS, and more

Data formatting for ARIMA forecasting

Posts: 1

Data formatting for ARIMA forecasting

I am trying to prep my data for an ARIMA forecasting procedure. Must i have one line per date? I would like a forecast for a total count of units, however need to maintain the level of detail that allows me to dis-aggregate by unit type, state, and retailer. Do I need to set up the data such that I do a forecast for each combination of my detail?

SAS Employee
Posts: 416

Re: Data formatting for ARIMA forecasting

Hello -

You can find an example here:

and more information here:

In order to introduce hierarchies like type, state, retailer you will need to use BY variables. See:

If you check out the SASHELP.PRICEDATA sample data set, you will get an impression of the structure needed.



Ask a Question
Discussion stats
  • 1 reply
  • 2 in conversation