* Mege SCRIPT
*This is the imperfect SPSS import file for 2005 U.S. Census Bureau American Community
* Survey PUMS data.
*  - - - - - - http://factfinder.census.gov/home/en/acs_pums_2005.html
*
* This might (or might not) work on ACS PUMS data older or newer than 2005.
*
* Another source of already improved PUMS data is:
*       http://www.ipums.org/
*
*
*This script was written by David Huskins, at the Center for Policy Studies at the
* University of Akron - A State Data Center
* It may be used without restriction, although it is copywritten and may
*not be passed off as the work of someone else.
*It was written in April, 2007.
* All this files does is append the 2005 ACS Housing Data to each matching person file.
* There may be multiple persons in each household, so it will match/add data/variables for household X to all people in household X
*
* SERIALNO is the unique number for each HOUSING UNIT.  It exists in only 1 record in the HOUSING FILE, but in multiple records (people)
* in the PERSON file
*
* First create both your PERSON and HOUSING 2005 ACS PUMS files.
* Open each, and SORT both by SERIALNO.
* Make sure the variable setting (length, numeric/text) are exactly the same.
*
*You may have already converted SERIALNO to a numeric field.
*That is fine, as long as the fields are sorted and exactly the same format in each file.
*
* SAVE each file in its sorted condition.
*
* Change the script below so the PATH P:'dir\dir\dir\filename.sav
* is the same as your file.  That could be on a server or hard drive.
* Change where I wrote H.sav to the actual name of your housing file.
*
*For me, having the housing data appended to the person data proved the most useful.
*Save the results under a new name when you are done (you will still have your Person file open.
*
* When your Person file is open, and BOTH files are sorted, run this script.


MATCH FILES /FILE=*
 /TABLE='P:\Research\Census\PUMS\ACS05PUMS\H.sav'
 /RENAME (ADJUST PUMA RT ST = d0 d1 d2 d3)
 /BY SERIALNO
 /DROP= d0 d1 d2 d3.
EXECUTE.