Census 2000: Accessing and Utilizing Data Resources
June 16-20, 2003
SAS and SPSS Exercises
For the practicum, ICPSR staff prepared SAS and SPSS programs, described below, which the workshop participants used to analyze data from five Census 2000 data collections: the Public Law 94-171 File (redistricting data); Summary File 1, States; Summary File 2, Advance National; the ICPSR MSA/CMSA subset for Summary File 3, and the 1-Percent Public Use Microdata Sample (PUMS). One can download these programs and associated data files from our directory:
http://www.icpsr.umich.edu/CENSUS2000/TRAINING/2003/ftpdir/
- spssex1
This SPSS program generates a subset of cases and variables from the public law data. The subset comprises all cases that represent summary levels 730 and 750 in Ann Arbor, Michigan. The program writes the subset to a SPSS export file named aa.por. Execute this program before you run spssex2.
- spssex2
From the subset generated by spssex1 (aa.por), this SPSS program produces descriptive statistics for blocks in Ann Arbor, and lists the population of selected census tracts in Ann Arbor, by block and race.
- spssex3
A SPSS program that generates a subset of cases and variables from Summary File 1 data. The subset consists of all all cases representing summary levels 158, 155, and 160 in New York City. The program writes the subset to a SPSS export file named nyc.por. Execute this program before you run spssex4.
- spssex4
Using the subset produced by spssex3 (nyc.por), this program computes segregation indices for New York City.
- spssex5
This SPSS program produces a table from Summary File 2, Advance National data. For each state, the table shows the number of males who are Sioux alone or in combination with other races, the number of females Sioux alone or in combination with other races, the sum of both sexes Sioux alone or in combination with other races, and the percentage of both sexes Sioux alone or in combination with other races who are Sioux alone.
- spssex6
This SPSS program produces a table using the ICPSR "second quarter" MSA/CMSA subset file for Summary File 3. For each MSA/CMSA, the table shows the number of same sex unmarried partner households, the total number of households, and the percentage of all households that are same sex unmarried partner households.
- spssex7
Using the 1 Percent PUMS data for Delaware, this SPSS program computes the correlation between household income per person and the number of rooms per person.
- sasex1
A SAS program that produces the same subset as spssex1. The subset is written to a SAS transport (CPORT) file, aa.cpt. Execute this program before you run sasex2.
- sasex2
From the subset generated by sasex1 (aa.cpt), this SAS program produces the same results as spssex2.
- sasex3
This SAS program produces the same subset as spssex3. The subset is written to a SAS transport (CPORT) file, nyc.cpt. Execute this program before you run sasex4.
- sasex4
From the subset generated by sasex3 (nyc.cpt), this SAS program produces the same computations as spssex4.
- sasex5
This SAS program produces the same table as spssex5.
- sasex6
This SAS program produces the same table as spssex6.
- sasex7
This SAS program produces the same computation as spssex7.
Note: Users will have to modify the file pathnames in the programs to point to their own file locations.
Programs spssex5 and sasex5 were also used in the 2002 workshop. Programs spssex1-spssex4 and sasex1-sasex4 were also used in the 2001 and 2002 workshops.