*This program is for the 1990 1% and 5% Public Use Microdata Sample (PUMS) Data Files *SPSS changed the way it reads data files and hierarchical data files. *This is an approximation of how to do it based on cobbling *http://www.ats.ucla.edu/stat/spss/faq/hierspss.htm *http://www.ats.ucla.edu/stat/SPSS/modules/input.htm *This file has not been tested; We do not have SPSS *We are interested in solutions to this problem and suggestions are welcome. *by Jean Roth Wed Jan 31 12:49:50 EST 2007 *Please report errors to jroth@nber.org *This program produces a dataset of all Person records with their *respective Household variables appended. *Change output file name/location as desired. *Change the input file location as needed. *If you have trouble running this program, *then try opening a new syntax file & type this command: *INCLUDE "c:\pums1990.sps". *and choose to RUN ALL * The following changes in variable names have been made, if necessary: * '$' to 'd'; '-' to '_'; '%' to 'p' * Note: Variable names in SPSS are not case-sensitive. file handle /name='c:\pums_56.dat' . file type nested record=1. record type H. data list file= / rectype 1-1 (a) serialno 2-8 sample 9 division 10 state 11-12 puma 13-17 areatype 18-19 msapmsa 20-23 psa 24-26 subsampl 27-28 houswgt 29-32 persons 33-34 gqinst 35 units1 39-40 husflag 41 pdsflag 42 rooms 43 tenure 44 acre10 45 commuse 46 value 47-48 rent1 49-50 meals 51 vacancy1 52 vacancy2 53 vacancy3 54 vacancy4 55 yrmoved 56 bedrooms 57 plumbing 58 kitchen 59 telephon 60 autos 61 fuelheat 62 water 63 sewage 64 yrbuilt 65 condo 66 oneacre 67 agsales 68 eleccost 69-72 gascost 73-76 watrcost 77-80 fuelcost 81-84 rtaxamt 85-86 insamt 90-93 mortgag 94 mortgag3 95-99 taxincl 100 insincl 101 mortgag2 102 mortamt2 103-107 condofee 108-111 moblhome 112-115 rfarm 116 rgrent 117-120 rgrapi 121-122 rownrcst 124-128 rnsmocpi 129-131 rrentunt 132 rvalunt 133 rfaminc 134-140 rhhinc 141-147 rwrkr89 148 rhhlang 149 rlingiso 150 rhhfamtp 151-152 rnatadpt 153-154 rstpchld 155-156 rfampers 157-158 rnrlchld 159-160 rnonrel 161 r18undr 162 r60over 163 r65over 164 rsubfam 165 aunits1 166 arooms 167 atenure 168 aacres10 169 acommuse 170 avalue 171 arent1 172 ameals 173 avacncy2 174 avacncy3 175 avacncy4 176 ayrmoved 177 abedroom 178 aplumbng 179 akitchen 180 aphone 181 avehicle 182 afuel 183 awater 184 asewer 185 ayrbuilt 186 acondo 187 aoneacre 188 aagsales 189 aeleccst 190 agascst 191 awatrcst 192 afuelcst 193 ataxamt 194 ainsamt 195 amortg 196 amortg3 197 ataxincl 198 ainsincl 199 amortg2 200 amrtamt2 201 acndofee 202 amoblhme 203 . data list / relat1 9-10 sex 11 race 12-14 age 15-16 marital 17 pwgt1 18-21 remplpar 26-28 rpob 29-30 rspouse 31 rownchld 32 ragechld 33 rrelchld 34 relat2 35 subfam2 36 subfam1 37 hispanic 38-40 poverty 41-43 pob 44-46 citizen 47 immigr 48-49 school 50 yearsch 51-52 ancstry1 53-55 ancstry2 56-58 mobility 59 migstate 60-61 migpuma 62-66 lang1 67 lang2 68-70 english 71 military 72 rvetserv 73-74 sept80 75 may75880 76 vietnam 77 feb55 78 korean 79 wwii 80 othrserv 82 yrsserv 83-84 disabl1 85 disabl2 86 mobillim 87 perscare 88 fertil 89-90 rlabor 91 worklwk 92 hours 93-94 powstate 95-96 powpuma 97-101 means 102-103 riders 104 depart 105-108 travtime 109-110 tmpabsnt 111 looking 112 avail 113 yearwrk 114 industry 115-117 occup 118-120 class 121 work89 122 week89 123-124 hour89 125-126 rearning 127-132 rpincome 133-138 income1 139-144 income2 145-150 income3 151-156 income4 157-162 income5 163-167 income6 168-172 income7 173-177 income8 178-182 aaugment 183 arelat1 184 asex 185 arace 186 aage 187 amarital 188 ahispan 189 abirthpl 190 acitizen 191 aimmigr 192 aschool 193 ayearsch 194 aancstr1 195 aancstr2 196 amoblty 197 amigstate 198 alang1 199 alang2 200 aenglish 201 avets1 202 aservper 203 ayrsserv 204 adisabl1 205 adisabl2 206 amobllim 207 apercare 208 afertil 209 alabor 210 ahours 211 apowst 212 ameans 213 ariders 214 adepart 215 atravtme 216 alstwrk 217 aindustr 218 aoccup 219 aclass 220 awork89 221 awks89 222 ahour89 223 aincome1 224 aincome2 225 aincome3 226 aincome4 227 aincome5 228 aincome6 229 aincome7 230 aincome8 231 . end file type. * See the codebook for more detailed variable descriptions. variable labels rectype "Record Type" sample "Sample Identifier" division "Division code" state "State Code" puma "Public use microdata area (state depen" areatype "Area type revised for PUMS equivalency" msapmsa "MSA/PMSA" psa "Planning service area (elderly sample " subsampl "Subsample number (Use to pull extracts" houswgt "Housing Weight" persons "Number of person records following thi" gqinst "Group quarters institution" units1 "Units in structure" husflag "All 100% housing unit data substituted" pdsflag "All 100% person data substituted" rooms "Rooms" tenure "Tenure" acre10 "On ten acres or more" commuse "Business or medical office on property" value "Property value" rent1 "Monthly rent" meals "Meals included in rent" vacancy1 "Vacant usual home elsewhere (UHE)" vacancy2 "Vacancy status" vacancy3 "Boarded up status" vacancy4 "Months vacant" yrmoved "When moved into this house or apartmen" bedrooms "Bedrooms" plumbing "Complete plumbing facilities" kitchen "Complete kitchen facilities" telephon "Telephone in Unit" autos "Vehicles (1 ton or less) available" fuelheat "House heating fuel" water "Source of water" sewage "Sewage disposal" yrbuilt "When structure first built" condo "House or apartment part of condominium" oneacre "House on less than 1 acre" agsales "1989 Sales of Agriculture Products" eleccost "Electricity (yearly cost)*" gascost "Gas (yearly cost)*" watrcost "Water (yearly cost)" fuelcost "House heating fuel (yearly cost)" rtaxamt "Property taxes (yearly amount)" insamt "Fire/hazard/flood insurance (yearly am" mortgag "Mortgage status" mortgag3 "Mortgage payment (monthly amount)" taxincl "Payment include real estate taxes" insincl "Payment include fire/hazard/flood insu" mortgag2 "Second mortgage or home equity loan st" mortamt2 "Second mortgage payment (monthly amoun" condofee "Condo fee (monthly amount)" moblhome "Mobile home costs (yearly amount)" rfarm "Farm/nonfarm status" rgrent "Gross rent" rgrapi "Gross rent as a percentage of househol" rownrcst "Selected monthly owner costs" rnsmocpi "Selected monthly owner costs as a perc" rrentunt "Specified rent unit" rvalunt "Specified value unit" rfaminc "Family income" rhhinc "Household income" rwrkr89 "Workers in family in 1989" rhhlang "Household language" rlingiso "Linguistic isolation" rhhfamtp "Household/family type" rnatadpt "Number of own natural born/adopted chi" rstpchld "Number of own stepchildren in househol" rfampers "Number of persons in family (unweighte" rnrlchld "Number of related children in househol" rnonrel "Presence of nonrelatives in household" r18undr "Presence of person under 18 years in h" r60over "Presence of persons 60 years and over " r65over "Presence of person 65 years and over i" rsubfam "Presence of subfamilies in Household" aunits1 "Units in structure allocation" arooms "Rooms allocation" atenure "Tenure allocation" aacres10 "On ten acres or more allocation" acommuse "Business or medical office on property" avalue "Value allocation" arent1 "Monthly rent allocation" ameals "Meals included in rent allocation" avacncy2 "Vacancy status allocation" avacncy3 "Boarded up status allocation" avacncy4 "Months vacant allocation" ayrmoved "When moved into this house or apartmen" abedroom "Number of bedrooms allocation" aplumbng "Complete plumbing facilities allocatio" akitchen "Complete kitchen facilities allocation" aphone "Telephones in house allocation" avehicle "Vehicles available by household alloca" afuel "House heating fuel allocation" awater "Source of water allocation" asewer "Sewage disposal allocation" ayrbuilt "When structure first built allocation" acondo "House or apartment part of condominium" aoneacre "House on less than 1 acre allocation" aagsales "1989 Sales of Agricultural Products al" aeleccst "Electricity (yearly cost) allocation" agascst "Gas (yearly cost) allocation" awatrcst "Water (yearly cost) allocation" afuelcst "House heating fuel (yearly cost) alloc" ataxamt "Taxes on property allocation" ainsamt "Fire, hazard, flood insurance allocati" amortg "Mortgage status allocation" amortg3 "Regular mortgage payment allocation" ataxincl "Payment include real estate taxes allo" ainsincl "Payment include fire, hazard, flood in" amortg2 "Second mortgage status allocation" amrtamt2 "Second mortgage payment allocation" acndofee "Condominium fee allocation" amoblhme "Mobile home costs allocation" relat1 "Relationship" sex "Sex" race "Recoded detailed race code (Appendix C" age "Age" marital "Marital status" pwgt1 "Person's weight" remplpar "Employment status of parents" rpob "Place of birth (Recode)" rspouse "Married, spouse present/spouse absent" rownchld "*Own child (see Appendix B, page 14)" ragechld "Presence and age of own children" relat2 "Detailed relationship (other relative)" subfam2 "Subfamily number" subfam1 "Subfamily relationship" hispanic "Detailed Hispanic origin code (See app" poverty "Person poverty status recode (See appe" pob "Place of birth (Appendix I)" citizen "Citizenship" immigr "Year of entry" school "School enrollment" yearsch "Educational attainment" ancstry1 "Ancestry - first entry (See appendix I" ancstry2 "Ancestry - second entry (See appendix " mobility "Mobility status (lived here on April 1" migstate "Migration - State or foreign country c" migpuma "Migration PUMA (state dependent)" lang1 "Language other than English at home" lang2 "Language spoken at home (See appendix " english "Ability to speak English" military "Military service" rvetserv "Veteran period of service" sept80 "Served September 1980 or later" may75880 "Served May 1975 to August 1980" vietnam "Served Vietnam era (August 1964 - Apri" feb55 "Served February 1955 - July 1964" korean "Served Korean conflict (June 1950 - Ja" wwii "Served World War II (September 1940 - " othrserv "Served any other time" yrsserv "Years of active duty military service" disabl1 "Work limitation status" disabl2 "Work prevented status" mobillim "Mobility limitation" perscare "Personal care limitation" fertil "Number of children ever born" rlabor "Employment status recode" worklwk "Worked last week" hours "Hours worked last week" powstate "Place of work - state - (Appendix I)" powpuma "Place of work PUMA (State dependent)" means "Means of transportation to work" riders "Vehicle occupancy" depart "Time of departure for work - hour and " travtime "Travel time to work" tmpabsnt "Temporary absence from work" looking "Looking for work" avail "Available for work" yearwrk "Year last worked" industry "Industry" occup "Occupation" class "Class of worker" work89 "Worked last year (1989)" week89 "Weeks worked last year (1989)" hour89 "Usual hours worked per week last year " rearning "Total person's earnings" rpincome "Total person's income (signed)" income1 "Wages or salary income in 1989" income2 "Nonfarm self-employment income in 1989" income3 "Farm self-employment income in 1989 (s" income4 "Interest, dividends, and net rental in" income5 "Social security income in 1989" income6 "Public assistance income in 1989" income7 "Retirement income in 1989" income8 "All other income in 1989" aaugment "Augmented person (see text pp. C-5)" arelat1 "Relationship allocation flag" asex "Sex allocation flag" arace "Detailed race allocation flag" aage "Age allocation flag" amarital "Marital status allocation flag" ahispan "Detailed Hispanic origin allocation fl" abirthpl "Place of birth" acitizen "Citizenship allocation flag" aimmigr "Year of entry allocation flag" aschool "School enrollment allocation flag" ayearsch "Highest education allocation flag" aancstr1 "First ancestry allocation flag" aancstr2 "Second ancestry allocation flag" amoblty "Mobility status allocation flag" amigstate "Migration state allocation flag" alang1 "Language other than English allocation" alang2 "Language spoken at home allocation fla" aenglish "Ability to speak English allocation fl" avets1 "Military service allocation flag" aservper "Military periods of service allocation" ayrsserv "Years of military service allocation f" adisabl1 "Work limitation status allocation flag" adisabl2 "Work prevention status allocation flag" amobllim "Mobility limitation status allocation " apercare "Personal care limitation status alloca" afertil "Children ever born allocation flag" alabor "Employment status recode allocation fl" ahours "Hours worked last week allocation flag" apowst "Place of work state allocation flag" ameans "Means of transportation to work alloca" ariders "Vehicle occupancy allocation flag" adepart "Time of departure to work allocation f" atravtme "Travel time to work allocation flag" alstwrk "Year last worked allocation flag" aindustr "Industry allocation flag" aoccup "Occupation allocation flag" aclass "Class of worker allocation flag" awork89 "Worked last year allocation flag" awks89 "Weeks worked in 1989 allocation flag" ahour89 "Usual hours worked per week in 1989 al" aincome1 "Wages and salary income allocation fla" aincome2 "Nonfarm self-employment income allocat" aincome3 "Farm self-employment income allocation" aincome4 "Interest, dividend, and net rental inc" aincome5 "Social security income allocation flag" aincome6 "Public assistance allocation flag" aincome7 "Retirement income allocation flag" aincome8 "All other income allocation flag" . value labels sample 1 "5% sample" 2 "1% sample" 3 "Elderly" /division 0 "Region/division not identifiable" 1 "New England (Northeast region)" 2 "Middle Atlantic (Northeast region)" 3 "East North Central (Midwest region)" 4 "West North Central (Midwest region)" 5 "South Atlantic (South region)" 6 "East South Central (South region)" 7 "West South Central (South Region)" 8 "Mountain (West region)" 9 "Pacific (West region)" /state 99 "PUMA boundaries cross state lines - 1% file" /puma 99999 "PUMA code (Includes tract groups) 1st 3" /areatype 10 "Central city" 11 "Central city part" 20 "MSA/PMSA - Outside central city" 21 "MSA/PMSA - Outside central city (part)" 22 "Central City (part) & outside central city" 30 "Entire MSA" 31 "2 or more MSAs/PMSAs" 40 "Mixed MSA/PMSA/NON-MSA/PMSA area" 50 "Outside MSA/PMSA" 60 "Place" 61 "Place - part" 70 "MCDs/Towns (New England only)" 80 "Counties/independent Cities (2 or more)" 81 "County/independent city - part" 82 "County/independent city" /msapmsa 9360 "FIPS/MSA/PMSA code, selected MSA/PMSA" 9997 "Mixed MSA/PMSA NONMSA/PMSA area" 9998 "2 or more MSAs" 9999 "Not in MA" /psa 0 "N/A (Elderly PUMS only)" /houswgt 1152 "Integer weight of housing unit" /persons 0 "Vacant unit" 1 "One person record (one person in household" /gqinst 0 "N/A (housing unit)" 1 "Institutionalized" 2 "Not institutionalized" /units1 0 "N/A (GQ)" 1 "Mobile home or trailer" 2 "One-family house detached" 3 "One-family house attached" 4 "2 Apartments" 5 "3-4 Apartments" 6 "5-9 Apartments" 7 "10-19 Apartments" 8 "20-49 Apartments" 9 "50 or more apartments" 10 "Other" /husflag 0 "No" 1 "Yes" /pdsflag 0 "No" 1 "Yes" /rooms 0 "N/A (GQ)" 1 "1 Room" 2 "2 Rooms" 3 "3 Rooms" 4 "4 Rooms" 5 "5 Rooms" 6 "6 Rooms" 7 "7 Rooms" 8 "8 Rooms" 9 "9 or more rooms" /tenure 0 "N/A (GQ/vacant)" 1 "Owned with mortgage or loan" 2 "Owned free and clear" 3 "Rented for cash rent" 4 "No cash rent" /acre10 0 "N/A (GQ/not a one-family house or mobile home)" 1 "House on ten or more acres" 2 "House on less than ten acres" /commuse 0 "N/A (GQ/not a one-family house or mobile home)" 2 "No" /value 0 "N/A (GQ/rental unit/vacant, not for sale only)" 1 "Less than $ 10000" 2 "$ 10000 - $ 14999" 3 "$ 15000 - $ 19999" 4 "$ 20000 - $ 24999" 5 "$ 25000 - $ 29999" 6 "$ 30000 - $ 34999" 7 "$ 35000 - $ 39999" 8 "$ 40000 - $ 44999" 9 "$ 45000 - $ 49999" 10 "$ 50000 - $ 54999" 11 "$ 55000 - $ 59999" 12 "$ 60000 - $ 64999" 13 "$ 65000 - $ 69999" 14 "$ 70000 - $ 74999" 15 "$ 75000 - $ 79999" 16 "$ 80000 - $ 89999" 17 "$ 90000 - $ 99999" 18 "$100000 - $124999" 19 "$125000 - $149999" 20 "$150000 - $174999" 21 "$175000 - $199999" 22 "$200000 - $249999" 23 "$250000 - $299999" 24 "$300000 - $399999" 25 "$400000 or more" /rent1 0 "N/A (GQ/not a rental unit)" 1 "Less than $ 80" 2 "$ 80 - $ 99" 3 "$ 100 - $124" 4 "$ 125 - $149" 5 "$ 150 - $174" 6 "$ 175 - $199" 7 "$ 200 - $224" 8 "$ 225 - $249" 9 "$ 250 - $274" 10 "$ 275 - $299" 11 "$ 300 - $324" 12 "$ 325 - $349" 13 "$ 350 - $374" 14 "$ 375 - $399" 15 "$ 400 - $424" 16 "$ 425 - $449" 17 "$ 450 - $474" 18 "$ 475 - $499" 19 "$ 500 - $524" 20 "$ 525 - $549" 21 "$ 550 - $599" 22 "$ 600 - $649" 23 "$ 650 - $699" 24 "$ 700 - $749" 25 "$ 750 - $999" 26 "$1000 or more" 27 "No cash rent (NCR)" /meals 0 "N/A (GQ/not a rental unit/rental-NCR)" 1 "Yes" 2 "No" /vacancy1 0 "N/A (occupied or regular vacant/GQ)" 1 "Vacant UHE-owner" 2 "Vacant UHE-renter" 3 "Vacant UHE-undetermined" /vacancy2 0 "N/A (occupied/GQ)" 1 "For rent" 2 "For sale only" 3 "Rented or sold, not occupied" 4 "For seasonal/recreational/occasional use" 5 "For migratory workers" 6 "Other vacant" /vacancy3 0 "N/A (occupied/GQ)" 1 "Yes" 2 "No" /vacancy4 0 "N/A (occupied/GQ)" 1 "Less than 1 month" 2 "1 up to 2 months" 3 "2 up to 6 months" 4 "6 up to 12 months" 5 "12 up to 24 months" 6 "24 or more months" /yrmoved 0 "N/A (GQ/vacant)" 1 "1989 or 1990" 2 "1985 to 1988" 3 "1980 to 1984" 4 "1970 to 1979" 5 "1960 to 1969" 6 "1959 or earlier" /bedrooms 0 "N/A (GQ)" 1 "No bedrooms" 2 "1 Bedroom" 3 "2 Bedrooms" 4 "3 Bedrooms" 5 "4 Bedrooms" 6 "5 or more bedrooms" /plumbing 0 "N/A (GQ)" 1 "Yes, all three facilities" 2 "No" /kitchen 0 "N/A (GQ)" 1 "Yes" 2 "No" /telephon 0 "N/A (GQ/vacant)" 1 "Yes" 2 "No" /autos 0 "N/A (GQ/vacant)" 1 "No vehicles" 2 "1 vehicle" 3 "2 vehicles" 4 "3 vehicles" 5 "4 Vehicles" 6 "5 Vehicles" 7 "6 Vehicles" 8 "7 or more vehicles" /fuelheat 0 "N/A (GQ/vacant)" 1 "Gas: Underground pipes" 2 "Gas: Bottled, tank, or LP" 3 "Electricity" 4 "Fuel oil, kerosene, etc." 5 "Coal or coke" 6 "Wood" 7 "Solar energy" 8 "Other fuel" 9 "No fuel used" /water 0 "N/A (GQ)" 1 "Public system or private company" 2 "Individual drilled well" 3 "Individual dug well" 4 "Other source such as a spring, creek, etc." /sewage 0 "N/A (GQ)" 1 "Public sewer" 2 "Septic tank or cesspool" 3 "Other means" /yrbuilt 0 "N/A (GQ)" 1 "1989 or 1990" 2 "1985 to 1988" 3 "1980 to 1984" 4 "1970 to 1979" 5 "1960 to 1969" 6 "1950 to 1959" 7 "1940 to 1949" 8 "1939 or earlier" /condo 0 "N/A (GQ)" 1 "Yes" 2 "No" /oneacre 0 "N/A (GQ, two or more units in structure)" 1 "Yes" 2 "No" /agsales 0 "N/A (less than 1 acre/GQ/vacant/" 1 "None" 2 "$1 to $999" 3 "$1,000 to $2,499" 4 "$2,500 to $4,999" 5 "$5,000 to $9,999" 6 "$10,000 or more" /eleccost 0 "N/A (GQ/vacant)" 1 "Included in rent or in condo fee" 0002 "No charge or electricity not used" 3100 "Topcode" /gascost 0 "N/A (GQ/vacant)" 1 "Included in rent or in condo fee" 0002 "No charge or gas not used" 2100 "Topcode" /watrcost 0 "N/A (GQ/vacant)" 001 "Included in rent or in condo fee" 002 "No charge" 1000 "Topcode" /fuelcost 0 "N/A (GQ/vacant)" 1 "Included in rent or in condo fee" 0002 "No charge or these fuels not used" 1900 "Topcode" /rtaxamt 0 "N/A (GQ/vacant/not owned or being bought/not a" 1 "None" 2 "$ 2 - $ 49" 3 "$ 50 - $ 99" 4 "$ 100 - $ 149" 5 "$ 150 - $ 199" 6 "$ 200 - $ 249" 7 "$ 250 - $ 299" 8 "$ 300 - $ 349" 9 "$ 350 - $ 399" 10 "$ 400 - $ 449" 11 "$ 450 - $ 499" 12 "$ 500 - $ 549" 13 "$ 550 - $ 599" 14 "$ 600 - $ 649" 15 "$ 650 - $ 699" 16 "$ 700 - $ 749" 17 "$ 750 - $ 799" 18 "$ 800 - $ 849" 19 "$ 850 - $ 899" 20 "$ 900 - $ 949" 21 "$ 950 - $ 999" 22 "$1000 - $1099" 23 "$1100 - $1199" 24 "$1200 - $1299" 25 "$1300 - $1399" 26 "$1400 - $1499" 27 "$1500 - $1599" 28 "$1600 - $1699" 29 "$1700 - $1799" 30 "$1800 - $1899" 31 "$1900 - $1999" 32 "$2000 - $2099" 33 "$2100 - $2199" 34 "$2200 - $2299" 35 "$2300 - $2399" 36 "$2400 - $2499" 37 "$2500 - $2599" 38 "$2600 - $2699" 39 "$2700 - $2799" 40 "$2800 - $2899" 41 "$2900 - $2999" 42 "$3000 - $3099" 43 "$3100 - $3199" 44 "$3200 - $3299" 45 "$3300 - $3399" 46 "$3400 - $3499" 47 "$3500 - $3599" 48 "$3600 - $3699" 49 "$3700 - $3799" 50 "$3800 - $3899" 51 "$3900 - $3999" 52 "$4000 - $4099" 53 "$4100 - $4199" 54 "$4200 - $4299" 55 "$4300 - $4399" 56 "$4400 - $4499" 57 "$4500 = Topcode" 58 "$4501 - $54992Ä¿RANGE" 59 "$5500 - $7499 ³ FOR" 60 "$7500 or more2ÄÙ MEDIAN" /insamt 0 "N/A (not owned or being bought/not a one" 1 "None" 1300 "Topcode" /mortgag 1 "Mortgage deed of trust, or similar debt" 2 "Contract to purchase" 3 "None" /mortgag3 0 "N/A (not owned or being bought/not a one" 1 "No regular payment required" 02000 "Topcode" /taxincl 0 "N/A (GQ/vacant/not owned or being bought/" 1 "Yes, taxes included in payment" 2 "No, taxes paid separately or taxes not required" /insincl 0 "N/A (GQ/vacant/not owned or being bought/" 1 "Yes, insurance included in payment" 2 "No, insurance paid separately or no insurance" /mortgag2 0 "N/A (GQ/vacant/not owned or being bought/" 1 "Yes" 2 "No" /mortamt2 0 "N/A (GQ/vacant/condo/not owned or being" 1 "No regular payment required" 01000 "Topcode" /condofee 0 "N/A (not owned or being bought/not" 0600 "Topcode" /moblhome 0 "N/A (GQ/vacant/not owned or being bought/" 3399 "$1 - $3,399 (cost in dollars)" 3400 "Topcode" /rfarm 0 "N/A (GQ/urban)" 1 "Rural farm" 2 "Rural nonfarm" /rgrent 0 "N/A (GQ/vacant, not rented for cash rent)" 1500 "Topcode" /rgrapi 0 "N/A (GQ/vacant/not rented for cash rent/owner" 1 " 1% to 9%" 2 "10% to 14%" 3 "15% to 19%" 4 "20% to 24%" 5 "25% to 29%" 6 "30% to 34%" 7 "35% to 39%" 8 "40% to 49%" 9 "50% to 59%" 10 "60% to 69%" 11 "70% to 79%" 12 "80% to 89%" 13 "90% to 99%" 14 "100% or more" /rownrcst 0 "N/A (not owned or being bought/not a one" 20300 "Topcode" /rnsmocpi 0 "N/A (not owned or being bought/not a one family" 101 "101% or more" /rrentunt 0 "Not specified rent unit" 1 "Specified rent unit" /rvalunt 0 "Not specified value unit" 1 "Specified value unit" /rfaminc 0 "N/A(GQ/vacant/no income)" 9999999 "Total family income in dollars (See user notes" /rhhinc 0 "N/A(GQ/vacant/no income)" /rwrkr89 0 "N/A (GQ/vacant/non-family household)" 1 "No workers" 2 "1 worker" 3 "2 workers" 4 "3 or more workers in family" /rhhlang 0 "N/A (GQ/vacant)" 1 "English only" 2 "Spanish" 3 "Other Indo-European language" 4 "Asian or Pacific Island language" 5 "Other language" /rlingiso 0 "N/A (GQ/vacant)" 1 "Not linguistically isolated" 2 "Linguistically isolated" /rhhfamtp 0 "N/A (GQ/vacant)" 1 "Married-couple family household" 2 "Male householder" 3 "Female householder" 11 "Living alone" 12 "Not living alone" 21 "Living alone" 22 "Not living alone" /rnatadpt 0 "N/A(GQ/vacant/no own natural born/adopted" /rstpchld 0 "N/A(GQ/vacant/no own stepchildren)" /rfampers 0 "N/A (GQ/vacant/non-family household)" /rnrlchld 0 "N/A (GQ/vacant/no related children)" /rnonrel 0 "N/A (No nonrelatives in household/GQ/vacant)" 1 "1 or more nonrelatives in household" /r18undr 0 "N/A (No person under 18 in household/GQ/vacant)" 1 "1 or more person under 18 in household" /r60over 0 "N/A (No person 60 and over/GQ/vacant)" 1 "1 person 60 and over (unweighted)" 2 "2 or more person 60 and over (unweighted)" /r65over 0 "N/A (No person 65 and over/GQ/vacant)" 1 "1 person 65 and over (unweighted)" 2 "2 or more person 65 and over (unweighted)" /rsubfam 0 "N/A (No subfamilies or not" 1 "1 or more subfamilies" /aunits1 0 "No" 1 "Yes" /arooms 0 "No" 1 "Yes" /atenure 0 "No" 1 "Yes" /aacres10 0 "No" 1 "Yes" /acommuse 0 "No" 1 "Yes" /avalue 0 "No" 1 "Yes" /arent1 0 "No" 1 "Yes" /ameals 0 "No" 1 "Yes" /avacncy2 0 "No" 1 "Yes" /avacncy3 0 "No" 1 "Yes" /avacncy4 0 "No" 1 "Yes" /ayrmoved 0 "No" 1 "Yes" /abedroom 0 "No" 1 "Yes" /aplumbng 0 "No" 1 "Yes" /akitchen 0 "No" 1 "Yes" /aphone 0 "No" 1 "Yes" /avehicle 0 "No" 1 "Yes" /afuel 0 "No" 1 "Yes" /awater 0 "No" 1 "Yes" /asewer 0 "No" 1 "Yes" /ayrbuilt 0 "No" 1 "Yes from not answered" 2 "Yes 'don't know'" /acondo 0 "No" 1 "Yes" /aoneacre 0 "No" 1 "Yes" /aagsales 0 "No" 1 "Yes" /aeleccst 0 "No" 1 "Yes" /agascst 0 "No" 1 "Yes" /awatrcst 0 "No" 1 "Yes" /afuelcst 0 "No" 1 "Yes" /ataxamt 0 "No" 1 "Yes" /ainsamt 0 "No" 1 "Yes" /amortg 0 "No" 1 "Yes no answer" 2 "Yes from junior mortgage" /amortg3 0 "No" 1 "Yes" /ataxincl 0 "No" 1 "Yes" /ainsincl 0 "No" 1 "Yes" /amortg2 0 "No" 1 "Yes" /amrtamt2 0 "NO" 1 "Yes" /acndofee 0 "No" 1 "Yes" /amoblhme 0 "No" 1 "Yes" /relat1 0 "Householder" 1 "Husband/wife" 2 "Son/daughter" 3 "Stepson/stepdaughter" 4 "Brother/sister" 5 "Father/mother" 6 "Grandchild" 7 "Other relative" 8 "Roomer/boarder/foster child" 9 "Housemate/roommate" 10 "Unmarried partner" 11 "Other nonrelative" 12 "Institutionalized person" 13 "Other persons in group quarters" /sex 0 "Male" 1 "Female" /age 0 "Less than 1 year" 90 "90 or more years old" /marital 0 "Now married, except separated" 1 "Widowed" 2 "Divorced" 3 "Separated" 4 "Never married or under 15 years old" /pwgt1 1152 "Person's weight" /remplpar 0 "N/A (not own child of householder, and not" 111 "Both parents at work 35 or more hours" 112 "Father only at work 35 or more hours" 113 "Mother only at work 35 or more hours" 114 "Neither parent at work 35 or more hours" 121 "Father at work 35 or more hours" 122 "Father not at work 35 or more hours" 133 "Mother at work 35 or more hours" 134 "Mother not at work 35 or more hours" 211 "Father at work 35 or more hours" 212 "Father not at work 35 or more hours" 213 "Father not in labor force" 221 "Mother at work 35 or more hours" 222 "Mother not at work 35 or more hours" 223 "Mother not in labor force" /rpob 10 "Born in State of residence" 21 "Northeast" 22 "Midwest" 23 "South" 24 "West" 31 "Puerto Rico" 32 "American Samoa" 33 "Guam" 34 "Northern Marianas" 35 "US Virgin Islands" 36 "Elsewhere" 40 "Born abroad of American parents" 51 "Naturalized citizen" 52 "Not a citizen" /rspouse 0 "N/A (less than 15 years old)" 1 "Now married, spouse present" 2 "Now married, spouse absent" 3 "Widowed" 4 "Divorced" 5 "Separated" 6 "Never married" /rownchld 1 "Own child" 0 "Not own child" /ragechld 0 "N/A (male)" 1 "With own children under 6 years only" 2 "With own children 6 to 17 years only" 3 "With own children under 6 years and 6 to 17" 4 "No own children (.incl. females under 16 years)" /rrelchld 1 "Related child" 0 "Not related child" /relat2 0 "N/A (GQ/not other relative)" 1 "Son-in-law/daughter-in-law" 2 "Father-in-law/mother-in-law" 3 "Brother-in-law/sister-in-law" 4 "Nephew/niece" 5 "Grandparent" 6 "Uncle/aunt" 7 "Cousin" 8 "Other related by blood or marriage" 9 "Other relative" /subfam2 0 "N/A (GQ/not in a subfamily)" 1 "In subfamily 1" 2 "In subfamily 2" 3 "In subfamily 3" /subfam1 0 "N/A (GQ/not in a subfamily)" 1 "Husband/wife" 2 "Parent in a parent/child subfamily" 3 "Child in subfamily" /poverty 0 "N/A" 501 "501% or more of poverty value" /pob 554 "At sea" 555 "Abroad, not specified" /citizen 0 "Born in the U.S." 1 "Born in Puerto Rico, Guam, and outlying areas" 2 "Born abroad of American parents" 3 "U.S. citizen by naturalization" 4 "Not a citizen of the U.S" /immigr 0 "Born in the U.S." 1 "1987 to 1990" 2 "1985 to 1986" 3 "1982 to 1984" 4 "1980 or 1981" 5 "1975 to 1979" 6 "1970 to 1974" 7 "1965 to 1969" 8 "1960 to 1964" 9 "1950 to 1959" 10 "Before 1950" /school 0 "N/A (less than 3 years old)" 1 "Not attending school" 2 "Yes, public school, public college" 3 "Yes, private school, private college" /yearsch 0 "N/A (less than 3 years old)" 1 "No school completed" 2 "Nursery school" 3 "Kindergarten" 4 "1st, 2nd, 3rd, or 4th grade" 5 "5th, 6th, 7th, or 8th grade" 6 "9th grade" 7 "10th grade" 8 "11th grade" 9 "12th grade, no diploma" 10 "High school graduate, diploma or GED" 11 "Some college, but no degree" 12 "Associate degree in college, occupational program" 13 "Associate degree in college, academic program" 14 "Bachelor's degree" 15 "Master's degree" 16 "Professional degree" 17 "Doctorate degree" /ancstry1 999 "Not reported" /ancstry2 0 "No secondary ancestry" 999 "Not reported" /mobility 0 "N/A(less than 5 years old)" 1 "Yes same house (nonmovers)" 2 "No, different house (movers)" /migstate 0 "N/A (person less than 5 years old/lived" 72 "Puerto Rico" 98 "Other abroad in 1985" 99 "State not identified (B sample)" /migpuma 0 "N/A (person less than 5 years old/lived in" 99900 "Abroad" /lang1 0 "N/A (less than 5 years old)" 1 "Yes, speaks another language" 2 "No, speaks only English" /english 0 "N/A (less than 5 years old/speaks only English)" 1 "Very well" 2 "Well" 3 "Not well" 4 "Not at all" /military 0 "N/A (less than 16 years old)" 1 "Yes, now on active duty" 2 "Yes, on active duty in past, but not now" 3 "Yes, service in reserves or national guard only" 4 "No service" /rvetserv 0 "N/A (less than 16 years old, no active duty)" 1 "September 1980 or later only" 2 "May 1975 to August 1980 only" 3 "May 1975 to August 1980 and September 1980" 4 "Vietnam era, no Korean conflict, no WWII" 5 "Vietnam era and Korean conflict, no WWII" 6 "Vietnam era and Korean conflict and WWII" 7 "February 1955 to July 1964 only" 8 "Korean conflict, no Vietnam era, no WWII" 9 "Korean conflict and WWII, no Vietnam era" 10 "WWII, no Korean conflict, no Vietnam era" 11 "Other service" /sept80 0 "(Did not serve this period/less than 16 years" 1 "Served this period" /may75880 0 "(Did not serve this period/less than 16 years" 1 "Served this period" /vietnam 0 "(Did not serve this period/less than 16 years" 1 "Served this period" /feb55 0 "(Did not serve this period/less than 16 years" 1 "Served this period" /korean 0 "(Did not serve this period/less than 16 years" 1 "Served this period" /wwii 0 "(Did not serve this period/less than 16 years" 1 "Served this period" /othrserv 0 "(Did not serve this period/less than 16 years" 1 "Served this period" /yrsserv 0 "N/A (less than 16 years/no active duty military" 1 "1 Year or less of service" 50 "50 or more years of service" /disabl1 0 "N/A (less than 16 years, and selected persons in" 1 "Yes, limited in kind or amount of work" 2 "No, not limited" /disabl2 0 "N/A(less than 16 years, and selected persons in" 1 "Yes, prevented from working" 2 "No, not prevented from working" /mobillim 0 "N/A (less than 15 years/institutionalized" 1 "Yes, has a mobility limitation" 2 "No, does not have a mobility limitation" /perscare 0 "N/A (less than 15 years/institutionalized" 1 "Yes, has a personal care limitation" 2 "No, does not have a personal care limitation" /fertil 0 "N/A (less than 15 years/male)" 1 "No children" 2 "1 Child" 3 "2 Children" 4 "3 Children" 5 "4 Children" 6 "5 Children" 7 "6 Children" 8 "7 Children" 9 "8 Children" 10 "9 Children" 11 "10 Children" 12 "11 Children" 13 "12 or more children" /rlabor 0 "N/A (less than 16 years old)" 1 "Civilian employed, at work" 2 "Civilian employed, with a job but not at work" 3 "Unemployed" 4 "Armed forces, at work" 5 "Armed forces, with a job but not at work" 6 "Not in labor force" /worklwk 0 "N/A (less than 16 years old/not at work/" 1 "Worked" 2 "Did not work" /hours 0 "N/A (less than 16 years old/not at" 99 "99 or more hours worked last week" /powstate 0 "N/A (not a worker--not in the labor force," 98 "Abroad" 99 "State not identified" /powpuma 0 "N/A (not a worker--not in the labor force," 99900 "Abroad" /means 0 "N/A (not a worker--not in the labor force," 1 "Car, truck, or van" 2 "Bus or trolley bus" 3 "Streetcar or trolley car" 4 "Subway or elevated" 5 "Railroad" 6 "Ferryboat" 7 "Taxicab" 8 "Motorcycle" 9 "Bicycle" 10 "Walked" 11 "Worked at home" 12 "Other method" /riders 0 "N/A (not a worker or worker whose means of" 1 "Drove alone" 2 "2 People" 3 "3 People" 4 "4 People" 5 "5 People" 6 "6 People" 7 "7 to 9 people" 8 "10 or more people" /depart 0 "N/A (not a worker or worker who worked at" /travtime 0 "N/A (not a worker or worker who worked at home)" 99 "99 Minutes or more to get to work" /tmpabsnt 0 "N/A (less than 16 years old/at work/did not" 1 "Yes, on layoff" 2 "Yes, on vacation, temporary illness, labor" 3 "No" /looking 0 "N/A (less than 16 years old/at work/did not" 1 "Yes" 2 "No" /avail 0 "N/A (less than 16 years/at work/not looking/" 1 "No, already has a job" 2 "No, temporarily ill" 3 "No, other reasons (in school,etc.)" 4 "Yes, could have taken a job" /yearwrk 0 "N/A (less than 16 years old)" 1 "1990" 2 "1989" 3 "1988" 4 "1985 to 1987" 5 "1980 to 1984" 6 "1979 or earlier" 7 "Never worked" /industry 0 "N/A (less than 16 years old/unemployed who" /occup 0 "N/A (less than 16 years old/unemployed who" /class 0 "N/A (less than 16 years old/unemployed who" 1 "employee of a private for profit company or" 2 "Employee of a private not-for-profit," 3 "Local government employee (city, county, etc.)" 4 "State government employee" 5 "Federal government employee" 6 "Self-employed in own not incorporated" 7 "Self-employed in own incorporated" 8 "Working without pay in family business or farm" 9 "Unemployed, last worked in 1984 or earlier" /work89 0 "N/A (less than 16 years old)" 1 "Worked last year" 2 "Did not work last year" /week89 0 "N/A (less than 16 years old/did not work in" /hour89 0 "N/A (less than 16 years old/did not work in" 99 "99 Or more usual hours" /rearning 0 "N/A (no earnings)" -19996 "Loss of $19996 or more" 284000 "$284000 = Topcode" /rpincome 0 "N/A (no income)" -29997 "Loss of $29997 or more" 401000 "Topcode of total person's income" /income1 0 "N/A (less than 16 years old/none)" 139999 "$1 - 139,999" 140000 "Topcode" /income2 0 "N/A (less than 16 years/none)" -09999 "Loss of $9,999 or more" -09998 "Loss $1 to $9,998" 000001 "Break even or $1" 090000 "Topcode" /income3 0 "N/A (less than 16 years/none)" -09999 "Loss of $9,999 or more" 1 "Break even or $1" 054000 "Topcode" /income4 0 "N/A (less than 15 years/none)" -09999 "Loss of $9,999 or more" 1 "Break even or $1" 040000 "Topcode" /income5 0 "N/A (less than 15 years/none)" 17000 "Topcode" /income6 0 "N/A (less than 15 years/none)" 10000 "Topcode" /income7 0 "N/A (less than 15 years/none)" 30000 "Topcode" /income8 0 "N/A (less than 15 years/none)" 20000 "Topcode" /aaugment 0 "No" 1 "Yes" /arelat1 0 "No" 1 "Yes" /asex 0 "No" 1 "Yes" /arace 0 "No" 1 "Yes" /aage 0 "No" 1 "Yes" /amarital 0 "No" 1 "Yes" /ahispan 0 "No" 1 "Yes" /abirthpl 0 "No" 1 "Yes" /acitizen 0 "No" 1 "Yes" /aimmigr 0 "No" 1 "Yes" /aschool 0 "No" 1 "Yes" /ayearsch 0 "No" 1 "Yes" /aancstr1 0 "No" 1 "Yes" /aancstr2 0 "No" 1 "Yes" /amoblty 0 "No" 1 "Yes" /amigstate 0 "No" 1 "Yes" /alang1 0 "No" 1 "Yes" /alang2 0 "No" 1 "Yes" /aenglish 0 "No" 1 "Yes" /avets1 0 "No" 1 "Yes" /aservper 0 "No" 1 "Yes" /ayrsserv 0 "No" 1 "Yes" /adisabl1 0 "No" 1 "Yes" /adisabl2 0 "No" 1 "Yes" /amobllim 0 "No" 1 "Yes" /apercare 0 "No" 1 "Yes" /afertil 0 "No" 1 "Yes" /alabor 0 "No" 1 "Yes" /ahours 0 "No" 1 "Yes" /apowst 0 "No" 1 "Yes" /ameans 0 "No" 1 "Yes" /ariders 0 "No" 1 "Yes" /adepart 0 "No" 1 "Yes" /atravtme 0 "No" 1 "Yes" /alstwrk 0 "No" 1 "Yes" /aindustr 0 "No" 1 "Yes" /aoccup 0 "No" 1 "Yes" /aclass 0 "No" 1 "Yes" /awork89 0 "No" 1 "Yes" /awks89 0 "No" 1 "Yes" /ahour89 0 "No" 1 "Yes" /aincome1 0 "No" 1 "No (derived)" 2 "Yes" /aincome2 0 "No" 1 "No (derived)" 2 "Yes" /aincome3 0 "No" 1 "No (derived)" 2 "Yes" /aincome4 0 "No" 1 "No (derived)" 2 "Yes" /aincome5 0 "No" 1 "No (derived)" 2 "Yes" /aincome6 0 "No" 1 "No (derived)" 2 "Yes" /aincome7 0 "No" 1 "No (derived)" 2 "Yes" /aincome8 0 "No" 1 "No (derived)" 2 "Yes" . list. execute. save outfile = 'c:\pums1990.sav'.