GLOBAL INSIGHT: PC Format CITIBASE Database
/*--------------------------------------------------------------
SAS Sample Library
Name: datex06.sas
Description: Example program from SAS/ETS User's Guide,
The DATASOURCE Procedure
Title: GLOBAL INSIGHT: PC Format CITIBASE Database
Product: SAS/ETS Software
System: ALL
Keys: DATASOURCE data extraction from various sources
Procs: DATASOURCE
Data: sasmisc: basekey.dat (DATASOURCE database files)
baseind.dat
basedb.dat
Notes: Read this before you run this sample.
The database resides in the ets/sasmisc folder. You
must copy the database to a writeable folder before
using it. Then define your Windows system environment
variable, DATASRC_DATA, to the path of your
writeable folder containing
the basekey.dat, baseind.dat, and basedb.dat files.
To assign a fileref to the external file to be processed,
use the following filename statements:
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;
--------------------------------------------------------------*/
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;