Census 2000: Accessing and Utilizing Data Resources
June 24-28, 2002
SAS and SPSS Exercises
For the practicum, ICPSR staff prepared SAS and SPSS programs, described below, which workshop participants used to analyze data from three Census 2000 data releases: the Public Law 94-171 File (redistricting data); Summary File 1, States; and Summary File 2, Advance National. One can download these programs and associated data files from our directory:
http://www.icpsr.umich.edu/CENSUS2000/TRAINING/2002/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.
- spssex2
This SPSS program reads in the subset generated by spssex1, produces descriptive statistics for blocks in Ann Arbor, and lists the population of selected census tracts in Ann Arbor, by block and race.
- spssex3
This SPSS program 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.
- spssex4
This SPSS program reads in nyc.por and computes segregation indices for New York City.
- spssex5
This SPSS program produces a table from Summary File 2 data. For each state, the table shows the number of males, females, and persons of both sexes who are Sioux alone or in combination with other races, plus the percentage of both sexes Sioux alone or in combination with other races who are Sioux alone.
- sasex1
A SAS program that produces the same subset as spssex1. The subset is written to a SAS transport (CPORT) file, aa.cpt.
- sasex2
This SAS program produces the same computations as spssex2.
- sasex3
A SAS program that produces the same subset as spssex3. The subset is written to a SAS transport (CPORT) file, nyc.cpt.
- sasex4
This SAS program produces the same computations as spssex4.
- sasex5
This SAS program produces the same table as spssex5.
Note: Users will have to modify the file pathnames in the programs to point to their own file locations. (In the workshop, all files were read from directory f:/axelrod/.) Programs spssex1-spssex4 and sasex1-sasex4 were also used in the 2001 workshop.