This example is similar to Example 37.1, except quarterly data are used. Tables B1, the original series, and D11, the final seasonally adjusted series, are printed by the TABLES statement. The OUTPUT statement writes the listed tables to an output data set.
data quarter; input date yyq6. +1 fy35rr 5.2; format date yyq6.; datalines; 1971Q1 6.59 ... more lines ...
title 'Monthly Retail Sales Data (in $1000)'; proc x11 data=quarter; var fy35rr; quarterly date=date; tables b1 d11; output out=out b1=b1 d10=d10 d11=d11 d12=d12 d13=d13; run;
Output 37.2.1: X11 Procedure Quarterly Example
Monthly Retail Sales Data (in $1000) |
X-11 Seasonal Adjustment Program |
U. S. Bureau of the Census |
Economic Research and Analysis Division |
November 1, 1968 |
The X-11 program is divided into seven major parts. |
Part Description |
A. Prior adjustments, if any |
B. Preliminary estimates of irregular component weights |
and regression trading day factors |
C. Final estimates of above |
D. Final estimates of seasonal, trend-cycle and |
irregular components |
E. Analytical tables |
F. Summary measures |
G. Charts |
Series - fy35rr |
Period covered - 1st Quarter 1971 to 4th Quarter 1976 |
B1 Original Series | |||||
---|---|---|---|---|---|
Year | 1st | 2nd | 3rd | 4th | Total |
1971 | 6.590 | 6.010 | 6.510 | 6.180 | 25.290 |
1972 | 5.520 | 5.590 | 5.840 | 6.330 | 23.280 |
1973 | 6.520 | 7.350 | 9.240 | 10.080 | 33.190 |
1974 | 9.910 | 11.150 | 12.400 | 11.640 | 45.100 |
1975 | 9.940 | 8.160 | 8.220 | 8.290 | 34.610 |
1976 | 7.540 | 7.440 | 7.800 | 7.280 | 30.060 |
Avg | 7.670 | 7.617 | 8.335 | 8.300 |
Output 37.2.2: X11 Procedure Quarterly Example, Table D11
D11 Final Seasonally Adjusted Series | |||||
---|---|---|---|---|---|
Year | 1st | 2nd | 3rd | 4th | Total |
1971 | 6.877 | 6.272 | 6.222 | 5.956 | 25.326 |
1972 | 5.762 | 5.836 | 5.583 | 6.089 | 23.271 |
1973 | 6.820 | 7.669 | 8.840 | 9.681 | 33.009 |
1974 | 10.370 | 11.655 | 11.855 | 11.160 | 45.040 |
1975 | 10.418 | 8.534 | 7.853 | 7.947 | 34.752 |
1976 | 7.901 | 7.793 | 7.444 | 6.979 | 30.116 |
Avg | 8.025 | 7.960 | 7.966 | 7.969 |