| Getting Started with Time Series Forecasting |
The Forecast Data Set
The Forecasting System can save the forecasts to a SAS data set
in three different formats.
Depending on your needs, you may find one of these output formats
more convenient.
The output data set format is controlled by the Format combo box.
You can select the following output formats.
The simple format is the default.
- Simple
- The data set contains time ID variables and the forecast variables,
and it contains one observation per time period.
Observations for earlier time periods contain actual values
copied from the input data set;
later observations contain the forecasts.
- Interleaved
- The data set contains time ID variables, the variable TYPE,
and the forecast variables.
There are several observations per time period,
with the meaning of each observation identified by the TYPE variable.
- Concatenated
- The data set contains the variable SERIES, time ID variables,
and the variables ACTUAL, PREDICT, ERROR, UPPER, LOWER, and STD.
There is one observation per time period per forecast series.
The variable SERIES contains the name of the forecast series,
and the data set is sorted by SERIES and DATE.
Simple Format Forecast Data Set
To see the simple format forecast data set that the system created,
select the Output button.
This brings up a VIEWTABLE window to display the data set,
as shown in Display 23.19.
Display 23.19: Forecast Data Set -- Simple Format
Display 23.19 shows the default simple format.
This form of the forecast data set contains time ID variables
and the variables that you forecast.
The forecast variables contain actual values or predicted values,
depending on whether the date of the observation
is within the range of data supplied in the input data set.
Select File and Close to close the VIEWTABLE window.
Interleaved Format Forecast Data Set
From the Produce Forecasts window, use the combo box to select the
Interleaved format,
as shown in Display 23.20.
Display 23.20: Forecast Data Set Options
Now select the Run button again.
The system presents a warning notice reminding you that the
data set WORK.FORECAST already exists
and asking if you want to replace it.
Select Replace.
The forecasts are stored in the data set WORK.FORECAST again,
this time in the Interleaved format.
Dismiss the notice that the forecast was stored.
Now select the Output button again.
This brings up a VIEWTABLE window to display the data set,
as shown in Display 23.21.
Display 23.21: Forecast Data Set -- Interleaved Format
In the interleaved format, there are several output observations
for each input observation, identified by the TYPE variable.
The values of the forecast variables for observations with
different TYPE values are as follows.
- ACTUAL
- actual values copied from the input data set.
- ERROR
- the difference between the actual and predicted values.
- LOWER
- the lower confidence limits.
- PREDICT
- the predicted values from the forecasting model.
These are within-sample, one-step-ahead predictions for observations
within the historical period,
or multistep predictions for observations within the forecast period.
- STD
- the estimated standard deviations of the prediction errors.
- UPPER
- the upper confidence limits.
Select File and Close to close the VIEWTABLE window.
Concatenated Format Forecast Data Set
Use the combo box to select the
Concatenated format.
Re-create the forecast data set again,
and then select the Output button.
The VIEWTABLE window showing the concatenated format
of the forecast data set appears,
as shown in Display 23.22.
Display 23.22: Forecast Data Set -- Concatenated Format
This completes the example of how to use the Produce Forecasts window.
Select File and Close to close the VIEWTABLE window.
Select the Close button to return to the
Time Series Forecasting window.
Copyright © 1999 by SAS Institute Inc., Cary, NC, USA. All rights reserved.
