
Depending on the output options specified, multiple observations are written to the OUT= data set for each time period. The different parts of the results are contained in the VAR statement variables in observations identified by the character variable _TYPE_ and by the ID variable.
For example, the following statements use the OUTLIMIT option to write forecasts and 95% confidence limits for the variable SALES to the output data set PRED. This data set is printed with the PRINT procedure.
proc forecast data=past interval=month lead=10
out=pred outlimit;
var sales;
id date;
run;
proc print data=pred;
run;
The output data set PRED is shown in FigureĀ 17.3.
Figure 17.3: Output Data Set
| Obs | date | _TYPE_ | _LEAD_ | sales |
|---|---|---|---|---|
| 1 | AUG91 | FORECAST | 1 | 12.6205 |
| 2 | AUG91 | L95 | 1 | 12.1848 |
| 3 | AUG91 | U95 | 1 | 13.0562 |
| 4 | SEP91 | FORECAST | 2 | 12.7665 |
| 5 | SEP91 | L95 | 2 | 12.2808 |
| 6 | SEP91 | U95 | 2 | 13.2522 |
| 7 | OCT91 | FORECAST | 3 | 12.9020 |
| 8 | OCT91 | L95 | 3 | 12.4001 |
| 9 | OCT91 | U95 | 3 | 13.4039 |
| 10 | NOV91 | FORECAST | 4 | 13.0322 |
| 11 | NOV91 | L95 | 4 | 12.5223 |
| 12 | NOV91 | U95 | 4 | 13.5421 |
| 13 | DEC91 | FORECAST | 5 | 13.1595 |
| 14 | DEC91 | L95 | 5 | 12.6435 |
| 15 | DEC91 | U95 | 5 | 13.6755 |
| 16 | JAN92 | FORECAST | 6 | 13.2854 |
| 17 | JAN92 | L95 | 6 | 12.7637 |
| 18 | JAN92 | U95 | 6 | 13.8070 |
| 19 | FEB92 | FORECAST | 7 | 13.4105 |
| 20 | FEB92 | L95 | 7 | 12.8830 |
| 21 | FEB92 | U95 | 7 | 13.9379 |
| 22 | MAR92 | FORECAST | 8 | 13.5351 |
| 23 | MAR92 | L95 | 8 | 13.0017 |
| 24 | MAR92 | U95 | 8 | 14.0686 |
| 25 | APR92 | FORECAST | 9 | 13.6596 |
| 26 | APR92 | L95 | 9 | 13.1200 |
| 27 | APR92 | U95 | 9 | 14.1993 |
| 28 | MAY92 | FORECAST | 10 | 13.7840 |
| 29 | MAY92 | L95 | 10 | 13.2380 |
| 30 | MAY92 | U95 | 10 | 14.3301 |