Chapter Contents

Previous

Next

Example 10.4: DRI/McGraw-Hill Tape Format CITIBASE Files

This example illustrates how to extract daily series from a sample CITIBASE file. Also, it shows how the OUTSELECT= option affects the contents of the auxiliary data sets.

The daily series contained in the sample data file CITIDEMO are listed by the following statements:

   proc datasource filetype=citibase infile=citidemo interval=weekday
                   outall=citiall outby=citikey;
   run;
   
   title1 'Summary Information on Daily Data for CITIDEMO File';
   proc print data=citikey noobs;
   run;
   
   title1 'Daily Series Available in CITIDEMO File';
   proc print data=citiall( drop=label );
   run;

• The OUTALL= data set reports the time ranges of variables.
• There are ten observations in the OUTALL= data set, the same number as reported by NSERIES and NSELECT variables in the OUTBY= data set.
• The VARNUM variable contains all MISSING values, since no OUT= data set is created.

The next step is to demonstrate how the OUTSELECT= option affects the contents of the OUTBY= and OUTALL= data sets when a KEEP statement is present. First, set the OUTSELECT= option to OFF.

   proc datasource filetype=citibase infile=citidemo interval=weekday
                   outall=alloff outby=keyoff outselect=off;
      keep dsiusnysecm dc:;
   run;
   
   title1 'Summary Information on Daily Data for CITIDEMO File';
   proc print data=keyoff;
   run;
   
   title1 'Daily Series Available in CITIDEMO File';
   proc print data=alloff( keep=name kept selected st_date
                                end_date ntime nobs );
   run;

   proc datasource filetype=citibase infile=citidemo interval=weekday
                   outall=allon outby=keyon outselect=on;
      keep dsiusnysecm dc:;
   run;
   
   title1 'Summary Information on Daily Data for CITIDEMO File';
   proc print data=keyon;
   run;
   
   title1 'Daily Series Available in CITIDEMO File';
   proc print data=allon( keep=name kept selected st_date
                               end_date ntime nobs );
   run;

• The OUTALL= data set contains ten (NSERIES) observations when OUTSELECT=OFF, and three (NSELECT) observations when OUTSELECT=ON.
• The observations in OUTALL=ALLON are those for which SELECTED=1 in OUTALL=ALLOFF.
• The time ranges in the OUTBY= data set are computed over all the variables (selected or not) for OUTSELECT=OFF, resulting in ST_DATE='01JAN88'd and END_DATE='14MAR91'd; and over only the selected variables for OUTSELECT=ON, resulting in ST_DATE='04JAN88'd and END_DATE='14MAR91'd. This corresponds to computing time ranges over all the series reported in the OUTALL= data set.
• The variable NTIME is the number of time periods between ST_DATE and END_DATE, while NOBS is the number of observations the OUT= data set is to contain. Thus, NTIME is different depending on whether the OUTSELECT= option is set to ON or OFF, while NOBS stays the same.

Also the use of the KEEP statement in the last two examples illustrates the use of an additional variable, KEPT, in the OUTALL= data sets of Output 10.4.2 and Output 10.4.3. KEPT, which reports the outcome of the KEEP statement, is only added to the OUTALL= data set when there is KEEP statement, as shown in Output 10.4.1.

Adding the RANGE statement to the last example generates the data sets in Output 10.4.4:

   proc datasource filetype=citibase infile=citidemo interval=weekday
                   outby=keyrange out=citiday outselect=on;
      keep dsiusnysecm dc:;
      range to '12jan88'd;
   run;
   
   title1 'Summary Information 
   
   title1 'Daily Data in CITIDEMO File';
   proc print data=citiday;
   run;

Note that the OUT= data set does not contain data for 09JAN1988 and 10JAN1988. This is because the WEEKDAY interval skips over weekends.

Chapter Contents

Previous

Next

Top

Copyright © 1999 by SAS Institute Inc., Cary, NC, USA. All rights reserved.