Example 10.6: PC Diskette Format CITIBASE Database

The DATASOURCE Procedure

Example 10.6: PC Diskette Format CITIBASE Database

This example uses a diskette format CITIBASE database (FILETYPE=CITIDISK) to extract annual population estimates for females and males with respect to various age groups since 1980.

Population estimate series for females with five-year age intervals are given by PANF1 through PANF16, where PANF1 is for females under 5 years of age, PANF2 is for females between 5 and 9 years of age, and so on. Similarly, PANM1 through PANM16 gives population estimates for males with five-year age intervals.

The following statements extract the required population estimates series:

   filename keyfile 'host-specific-key-file-name' <host-options>;
   filename indfile 'host-specific-ind-file-name' <host-options>;
   filename dbfile  'host-specific-db-file-name'  <host-options>;
   proc datasource filetype=citidisk  infile=( keyfile indfile dbfile )
                   out=popest outall=popinfo;
      keep panf1-panf16 panm1-panm16;
      range from 1980;
   run;

This example demonstrates the following:

The INFILE= options lists the filerefs of the key, index, and database files, in that order.
The INTERVAL= option is omitted since the default interval for CITIDISK type files is YEAR.

Chapter Contents
Previous
Next
Top