The DATASOURCE Procedure

Example 12.6 PC Format CITIBASE Database

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

Population estimate series for all ages of females including those in the armed forces overseas are given by PANF, while PANM gives the population estimate for all ages of males including those in armed forces overseas. More population estimate time series are described in Output 12.6.1 and are output in Output 12.6.2.

The following statements extract the required population estimates series:

filename keyfile "%sysget(DATASRC_DATA)basekey.dat" RECFM=V LRECL=22;
filename indfile "%sysget(DATASRC_DATA)baseind.dat" RECFM=F LRECL=84;
filename dbfile "%sysget(DATASRC_DATA)basedb.dat" RECFM=F LRECL=4;

proc datasource filetype=citidisk  infile=( keyfile indfile dbfile )
                out=popest outall=popinfo;

run;

proc print data=popinfo;
run;
proc print data=popest;
run;

Output 12.6.1: Listing of the OUTALL=POPINFO Data Set for FILETYPE=CITIDISK

Daily Series Available in FXRATES_.DDS File, KEEP RX:

Obs NAME SELECTED TYPE LENGTH VARNUM BLKNUM LABEL FORMAT FORMATL FORMATD ST_DATE END_DATE NTIME NOBS DISKNUM ATTRIBUT NDEC AGGREGAT
1 PAN 1 1 5 2 1 POPULATION EST.: ALL AGES, INC.ARMED F. OVERSEAS(THOUS.,ANNUAL)   0 0 1980 1989 10 10 1 1 0 0
2 PAN17 1 1 5 3 2 POPULATION EST.: 16 YRS AND OVER,INC ARMED F.OVERSEAS(THOUS,ANNUAL)   0 0 1980 1989 10 10 1 1 0 0
3 PAN18 1 1 5 4 3 POPULATION EST.: 18-64 YRS,INC.ARMED F.OVERSEAS(THOUS,ANNUAL)   0 0 1980 1989 10 10 1 1 0 0
4 PANF 1 1 5 5 4 POPULATION EST.: FEMALES,ALL AGES,INC.ARMED F.O'SEAS(THOUS.,ANN)   0 0 1980 1989 10 10 1 1 0 0
5 PANM 1 1 5 6 5 POPULATION EST.: MALES, ALL AGES, INC.ARMED F.O'SEAS(THOUS.,ANN)   0 0 1980 1989 10 10 1 1 0 0


Output 12.6.2: Printout of the OUT=POPEST Data Set for FILETYPE=CITIDISK

Daily Series Available in FXRATES_.DDS File, KEEP RX:

Obs DATE PAN PAN17 PAN18 PANF PANM
1 1980 227757 172456 138358 116869 110888
2 1981 230138 175017 140618 118074 112064
3 1982 232520 177346 142740 119275 113245
4 1983 234799 179480 144591 120414 114385
5 1984 237001 181514 146257 121507 115494
6 1985 239279 183583 147759 122631 116648
7 1986 241625 185766 149149 123795 117830
8 1987 243942 187988 150542 124945 118997
9 1988 246307 189867 152113 126118 120189
10 1989 248762 191570 153695 127317 121445


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.