If you want to know the unique set of values BY variables assume for each cross section in the data file, use the OUTBY= option. For example, the following statements list some of the cross sections available for an IFS file, and are shown in Figure 11.3.
filename ifsfile "imfifs1.dat" RECFM=F LRECL=88;
proc datasource
filetype=imfifsp infile=ifsfile
outselect=on ebcdic
interval=month
outby=xsection;
run;
title1 'Some Cross Sections Available in IFSFILE';
proc print data=xsection;
run;
Figure 11.3
Listing of the OUTBY= Data Set
111 |
F |
|
Z |
JAN1957 |
SEP1986 |
357 |
357 |
6 |
3 |
UNITED STATES |
112 |
F |
|
Z |
JAN1957 |
SEP1986 |
357 |
357 |
6 |
3 |
UNITED KINGDOM |
146 |
F |
|
Z |
JAN1957 |
SEP1986 |
357 |
357 |
6 |
3 |
SWITZERLAND |
158 |
F |
|
Z |
JAN1957 |
SEP1986 |
357 |
357 |
6 |
3 |
JAPAN |
186 |
F |
|
Z |
JAN1957 |
SEP1986 |
357 |
357 |
6 |
3 |
TURKEY |
The OUTBY= data set reports the total number of series, NSERIES, defined in each cross section, NSELECT of which represent the selected variables. If you want to see the descriptive information on each of these NSELECT variables for each cross section, specify the OUTALL= option. For example, the following statements print descriptive information on all monthly series defined for all cross sections (COUNTRY=’111’, COUNTRY=’112’, COUNTRY=’146’, COUNTRY=’158’, and COUNTRY=’186’) which are shown in Figure 11.4.
filename datafile "imfifs1.dat" RECFM=F LRECL=88;
title3 'Time Series Defined in Cross Section';
proc datasource filetype=imfifsp
outselect=on ebcdic
interval=month
outall=ifsall;
run;
title4 'Cross Sections Available in OUTALL=IFSALL Data Set';
proc print
data=ifsall;
run;
Figure 11.4
Listing of the OUTALL= Data Set
111 |
F |
|
Z |
F___AA |
1 |
1 |
1 |
5 |
. |
1 |
MARKET RATE CONVERSION FACTOR |
|
0 |
0 |
JAN1957 |
SEP1986 |
357 |
357 |
UNITED STATES |
|
|
S |
E |
U U |
5 |
|
|
111 |
F |
|
Z |
F___AC |
1 |
1 |
1 |
5 |
. |
2 |
MARKET RATE CONVERSION FACTOR |
|
0 |
0 |
JAN1957 |
SEP1986 |
357 |
357 |
UNITED STATES |
|
|
S |
F |
U U |
5 |
|
|
111 |
F |
|
Z |
F___AE |
1 |
1 |
1 |
5 |
. |
3 |
MARKET RATE CONVERSION FACTOR |
|
0 |
0 |
JAN1957 |
SEP1986 |
357 |
357 |
UNITED STATES |
|
|
S |
A |
U U |
5 |
|
|
112 |
F |
|
Z |
F___AA |
1 |
1 |
1 |
5 |
. |
4 |
MARKET RATE CONVERSION FACTOR |
|
0 |
0 |
JAN1957 |
SEP1986 |
357 |
357 |
UNITED KINGDOM |
|
|
S |
E |
U U |
6 |
|
|
112 |
F |
|
Z |
F___AC |
1 |
1 |
1 |
5 |
. |
5 |
MARKET RATE CONVERSION FACTOR |
|
0 |
0 |
JAN1957 |
SEP1986 |
357 |
357 |
UNITED KINGDOM |
|
|
S |
F |
U U |
5 |
|
|
112 |
F |
|
Z |
F___AE |
1 |
1 |
1 |
5 |
. |
6 |
MARKET RATE CONVERSION FACTOR |
|
0 |
0 |
JAN1957 |
SEP1986 |
357 |
357 |
UNITED KINGDOM |
|
|
S |
A |
U U |
6 |
|
|
146 |
F |
|
Z |
F___AA |
1 |
1 |
1 |
5 |
. |
7 |
MARKET RATE CONVERSION FACTOR |
|
0 |
0 |
JAN1957 |
SEP1986 |
357 |
357 |
SWITZERLAND |
|
|
S |
E |
U |
4 |
|
|
146 |
F |
|
Z |
F___AC |
1 |
1 |
1 |
5 |
. |
8 |
MARKET RATE CONVERSION FACTOR |
|
0 |
0 |
JAN1957 |
SEP1986 |
357 |
357 |
SWITZERLAND |
|
|
S |
F |
U |
6 |
|
|
146 |
F |
|
Z |
F___AE |
1 |
1 |
1 |
5 |
. |
9 |
MARKET RATE CONVERSION FACTOR |
|
0 |
0 |
JAN1957 |
SEP1986 |
357 |
357 |
SWITZERLAND |
|
|
S |
A |
U |
4 |
|
|
158 |
F |
|
Z |
F___AA |
1 |
1 |
1 |
5 |
. |
10 |
MARKET RATE CONVERSION FACTOR |
|
0 |
0 |
JAN1957 |
SEP1986 |
357 |
357 |
JAPAN |
|
|
S |
E |
U |
3 |
|
|
158 |
F |
|
Z |
F___AC |
1 |
1 |
1 |
5 |
. |
11 |
MARKET RATE CONVERSION FACTOR |
|
0 |
0 |
JAN1957 |
SEP1986 |
357 |
357 |
JAPAN |
|
|
S |
F |
U |
6 |
|
|
158 |
F |
|
Z |
F___AE |
1 |
1 |
1 |
5 |
. |
12 |
MARKET RATE CONVERSION FACTOR |
|
0 |
0 |
JAN1957 |
SEP1986 |
357 |
357 |
JAPAN |
|
|
S |
A |
U |
3 |
|
|
186 |
F |
|
Z |
F___AA |
1 |
1 |
1 |
5 |
. |
13 |
MARKET RATE CONVERSION FACTOR |
|
0 |
0 |
JAN1957 |
SEP1986 |
357 |
357 |
TURKEY |
|
|
S |
E |
U |
3 |
|
|
186 |
F |
|
Z |
F___AC |
1 |
1 |
1 |
5 |
. |
14 |
MARKET RATE CONVERSION FACTOR |
|
0 |
0 |
JAN1957 |
SEP1986 |
357 |
357 |
TURKEY |
|
|
S |
F |
U |
5 |
|
|
186 |
F |
|
Z |
F___AE |
1 |
1 |
1 |
5 |
. |
15 |
MARKET RATE CONVERSION FACTOR |
|
0 |
0 |
JAN1957 |
SEP1986 |
357 |
357 |
TURKEY |
|
|
S |
A |
U |
3 |
|
|
The OUTCONT= data set contains one observation for each time series variable with the descriptive information summarized over BY groups. When the data file contains no cross sections, the OUTCONT= and OUTALL= data sets are equivalent, except that the OUTALL= data set also reports time ranges of available data. The OUTBY= data set in this case contains a single observation reporting the number of series and time ranges for the whole data file.