Data Archive SAS Sample Programs

The following SAS programs were written or modified by CISER Staff. Programs were written primarily for extracting data from the CISER Data Archive. The data is stored on the CISER Research Computing System in folder "U:\ArchiveData".  

CEN90_002.SAS
Reads a 1990 Census Data file from CISER Data Archive:
   'U:\ArchiveData\cen1990\002\stf2bxny.f01xxxxx'
Selects State and County records for NY.

CEN90EX.SAS
To create a flat ascii file with a fixed logical record length from selected data in the Census of Population and Housing, 1990. Reads the data file "da6150" saved in dir U:\ArchiveData\cen1990\008B.0001\. Uses RETAIN statement to combine household level information with person level information.

COMPUST.LST
Output from COMPUST.SAS.

COMPUST.SAS
Working with COMPUSTAT sas datasets. Program to obtain an extract from COMPUSTAT dataset.

COSTAT96.SAS
Reads raw data "U:\ArchiveData\cph\202\master.costat.padded". CISER Codebook: CPH - 202. Raw data contains multiple records per observation.

CPH_202.SAS
Reads raw data "U:\ArchiveData\cph\202\master.costat.padded". CISER Codebook: CPH - 202. Raw data contains multiple records per observation.

CRSP.SAS
Working with CRSP sas datasets. Program for pulling data for a single CRSP firm for a specified period of time.

CRSPCON.SAS
Working with CRSP sas datasets. Program to list the contents of all the datasets in the U:\ArchiveData\crsp\dx\  library.

ECON_023.SAS
Reads a DRI Basic Economics data file using PROC DATASOURCE, creates a SAS dataset containing three variables, and prints out the first ten observations from that dataset.

ECON_035.SAS
Reads the County Profile Table for 1967-1997 from the CISER Data Archive. Extracts selected county level data.

ECON_062.SAS
Reads SEDS and SEPEDS data from the CISER Data Archive. CISER Codebooks: ECON - 062, ECON - 063. Raw data contains multiple records per observation. Uses PROC TRANSPOSE to transpose a SAS dataset.

ECON_063.SAS
Reads SEDS and SEPEDS data from the CISER Data Archive. CISER Codebooks: ECON - 062, ECON - 063. Raw data contains multiple records per observation. Uses PROC TRANSPOSE to transpose a SAS dataset.

ECON_102.SAS
Program uses PROC DATASOURCE to read DIRECTION OF TRADE/ INTERNATIONAL MONETARY FUND database. CISER Codebook: ECON - 102.

EXECCOMP.SAS
Reads the Executive Compensation database distributed by Market Insight in Microsoft Access format. Creates eight SAS datasets with variable labels.

GET_TS2.SAS
Analysing CRSP Data. Program to obtain the pre and post 30 days of return from daily time series data, as in CRSP data.

GSP_006.SAS
Reads the IMF Government Finance Statistics dataset CISER Data Archive Codebook GSP-006. Uses PROC datasource to select five variables related to public expenditures for Ireland, creates a dataset, and prints one of those time series.

HE_001.SAS
Reads in selected variables from the 2000 version of Area Reference File and assigns variable labels. Creates a variable for the number of persons aged 65 and over in 1990, based on the 1990 Census of Population Housing STF1 file.

HE_104.SAS
Reads variables from the 2000 Natality Detail File HE-104(2000) located in the CISER Data Archive.

PUMS1.SAS
Extracts Data from THE CENSUS OF POPULATION AND HOUSING, 1990, PUBLIC USE MICROSAMPLE: 1/1000. CISER Codebook: CEN1990 - 008. Reads data with multiple record types. Uses RETAIN statement to link data from two record types and create a single observation.

PUMS2.SAS
Extracts Data from THE CENSUS OF POPULATION AND HOUSING, 1990, PUBLIC USE MICROSAMPLE: 1/1000. CISER Codebook: CEN1990 - 008. Reads data with multiple record types. Uses RETAIN statement to link data from two record types and create a single observation. Uses IF-THEN-GO TO- statement.

SA5.SAS
Reads INCOME AND POPULATION DATA from the CISER Data Archive. CISER Codebook: ECON - 046. Uses PROC TRANSPOSE to transpose the extracted SAS dataset.

SAMPLE.SAS
An example of reading a raw data file from CISER Data Archive and creating a SAS data set with selected variables.

SEDS95.SAS
Reads SEDS and SEPEDS data from the CISER Data Archive. CISER Codebooks: ECON - 062, ECON - 063. Raw data contains multiple records per observation. Uses PROC TRANSPOSE to transpose a SAS dataset.

SEPEDS95.SAS
Reads SEDS and SEPEDS data from the CISER Data Archive. CISER Codebooks: ECON - 062, ECON - 063. Raw data contains multiple records per observation. Uses PROC TRANSPOSE to transpose a SAS dataset.

SIND_001
An example of reading a raw data file from CISER Data Archive and creating a SAS data set with selected variables.

STF3A80.SAS
Reads tract level records from 1980 CENSUS SUMMARY TAPE FILE 3A. CISER Codebook: CEN1980 - 003. Creates a unique tract within county and state.

STF3A.SAS
Reads file containing records for summary level 140, selects several counties in NYS, reads in selected population, income, and housing variables for the 1990 CENSUS SUMMARY TAPE FILE 3A. CISER Codebook: CEN1990 - 003. Creates 9 NY county-specific datasets.

SUMFIPS.SAS
A sample program to sum across observations, as in FIPS codes. Program sums across observations and creates a new record based on the sums. The new record is then integrated into the original data file, replacing the individual records from which is is created.

TRADE.SAS
Program uses PROC DATASOURCE to read DIRECTION OF TRADE/ INTERNATIONAL MONETARY FUND database. CISER Codebook: ECON - 102.

USACOUNT.SAS
Reads raw data "U:\ArchiveData\cph\202\master.costat.padded". CISER Codebook: CPH - 202. Raw data contains multiple records per observation.

WT93B.SAS
Extracts Data from World Tables of Economic and Social Indicators 1950-1992. CISER Codebook: SIND - 059.

WT93IDN.SAS
Extracts Data from World Tables of Economic and Social Indicators 1950-1992. Program uses the known data layout for Countries in performing the data extraction for a country. CISER Codebook: SIND - 059.