Information Technology Services
Databases
Reference is made to the three widely used databases on grinder. Detailed instructions are provided to make the user's task a little easier.ARC/INFO Databases
Four databases are available for ARC/INFO users: ArcWord 1:25M, ArcUSA 1:25M, TIGER, and RIGIS. The detailed information for accessing these databases is presented in Handout #73, "ARC/INFO on Grinder."
Compustat
The thirteen Compustat files on Grinder are:
/compustat/bank/annual/data1999
/compustat/bank/quarterly/data1999
/compustat/bif/geographic/data1999
/compustat/bif/industry/data1999
/compustat/bif/sic/data1999
/compustat/canadian/annual/data1999
/compustat/canadian/quarterly/data1999
/compustat/fcotc/annual/data1999
/compustat/fcotc/quarterly/data1999
/compustat/pde/data1999
/compustat/pst/annual/data1999
/compustat/pst/quarterly/data1999
/compustat/research/data1999
Sample programs for seven out of the above thirteen data files are provided in the following two directories.
/compustat/sample/annual
/compustat/sample/quarterly
These programs use the SAS procedure PROC DATASOURCE to read the Compustat data files. Information needed to read the six additional data files via the PROC DATASOURCE method is provided in the, "Compustat Technical Guide," and the "Bank Compustat." These manuals are on Reserve in the Library. Information on running PROC DATASOURCE is on Grinder in the file: /compustat/sample/readme_sas
CRSP
The sample files are located in /crsp/sample. You may copy and modify them or create your own access routines using an editor. Make sure that .f is the suffix of your Fortran program. Eecute either one of the following statements to setup the environment variables. You must decide whether you wish to use the daily database or the monthly database.
. /crsp/accbin/dailycrsp (for daily data)
- OR -
. /crsp/accbin/monthlycrsp (for monthly data)
To compile a program use the following syntax:
xlf programname -o modulename -I$CRSP_INCLUDE $CRSP_LIB/crsplib.a
To execute a compiled program, type the modulename at the command prompt.
