log using pums1990.log, replace set mem 500m /*------------------------------------------------ by Jean Roth Wed Jan 31 12:49:50 EST 2007 Please report errors to jroth@nber.org NOTE: This program is distributed under the GNU GPL. See end of this file and http://www.gnu.org/licenses/ for details. Run with do pums1990 . PUMS raw data has a hierarchical structure. A household records is followed by its person records. This program produces a person level dataset with household data appended. Remember, household and is repeated for each person in the dataset. Census PUMS homepage: http://www.census.gov/main/www/pums.html 2000 PUMS 5pct homepage: http://www.census.gov/Press-Release/www/2003/PUMS5.html 2000 PUMS FTP 5pct page: http://ftp2.census.gov/census_2000/datasets/PUMS/FivePercent/ `1' refers to type of PUMS file: 1% or 5% `2' refers to the two-character state abbreviation `3' refers to the FIPS state code `4' refers to state such as District_of_Columbia ----------------------------------------------- */ program define pct ** 1990 file names have uppercase state abbreviations local ST=upper("`2'") /* The following line should contain the complete path and name of the compressed data file. */ local compressed "/homes/data/PUMS/1990/`1'pct/PUMSBX`ST'.TXT.gz" /* The following link should contain the complete path and name of the unzipped raw data file. */ local dat_name "/tmp/PUMSBX`ST'.TXT" /* The following line should contain the path to your output '.dta' file */ local dta_name "pums`1'_`2'.dta" /* The following line should contain the path to the data dictionary file */ local dct_name "./pums1990.dct" display "`1` = `1' 2 -> `2' 3 -> `3' 4 -> `4'" display "dat_name = `dat_name'" display "dta_name = `dta_name'" display "dct_name = `dct_name'" ** Uncompressing the raw data file to /tmp ! gzcat `compressed' > `dat_name' quietly infile using "`dct_name'", using("`dat_name'") clear ** Removing the temp file when finished ! rm -f "`dat_name'" replace serialno = serialno[_n-1] if rectype == "P" replace sample = sample[_n-1] if rectype == "P" replace division = division[_n-1] if rectype == "P" replace state = state[_n-1] if rectype == "P" replace puma = puma[_n-1] if rectype == "P" replace areatype = areatype[_n-1] if rectype == "P" replace msapmsa = msapmsa[_n-1] if rectype == "P" replace psa = psa[_n-1] if rectype == "P" replace subsampl = subsampl[_n-1] if rectype == "P" replace houswgt = houswgt[_n-1] if rectype == "P" replace persons = persons[_n-1] if rectype == "P" replace gqinst = gqinst[_n-1] if rectype == "P" replace units1 = units1[_n-1] if rectype == "P" replace husflag = husflag[_n-1] if rectype == "P" replace pdsflag = pdsflag[_n-1] if rectype == "P" replace rooms = rooms[_n-1] if rectype == "P" replace tenure = tenure[_n-1] if rectype == "P" replace acre10 = acre10[_n-1] if rectype == "P" replace commuse = commuse[_n-1] if rectype == "P" replace value = value[_n-1] if rectype == "P" replace rent1 = rent1[_n-1] if rectype == "P" replace meals = meals[_n-1] if rectype == "P" replace vacancy1 = vacancy1[_n-1] if rectype == "P" replace vacancy2 = vacancy2[_n-1] if rectype == "P" replace vacancy3 = vacancy3[_n-1] if rectype == "P" replace vacancy4 = vacancy4[_n-1] if rectype == "P" replace yrmoved = yrmoved[_n-1] if rectype == "P" replace bedrooms = bedrooms[_n-1] if rectype == "P" replace plumbing = plumbing[_n-1] if rectype == "P" replace kitchen = kitchen[_n-1] if rectype == "P" replace telephon = telephon[_n-1] if rectype == "P" replace autos = autos[_n-1] if rectype == "P" replace fuelheat = fuelheat[_n-1] if rectype == "P" replace water = water[_n-1] if rectype == "P" replace sewage = sewage[_n-1] if rectype == "P" replace yrbuilt = yrbuilt[_n-1] if rectype == "P" replace condo = condo[_n-1] if rectype == "P" replace oneacre = oneacre[_n-1] if rectype == "P" replace agsales = agsales[_n-1] if rectype == "P" replace eleccost = eleccost[_n-1] if rectype == "P" replace gascost = gascost[_n-1] if rectype == "P" replace watrcost = watrcost[_n-1] if rectype == "P" replace fuelcost = fuelcost[_n-1] if rectype == "P" replace rtaxamt = rtaxamt[_n-1] if rectype == "P" replace insamt = insamt[_n-1] if rectype == "P" replace mortgag = mortgag[_n-1] if rectype == "P" replace mortgag3 = mortgag3[_n-1] if rectype == "P" replace taxincl = taxincl[_n-1] if rectype == "P" replace insincl = insincl[_n-1] if rectype == "P" replace mortgag2 = mortgag2[_n-1] if rectype == "P" replace mortamt2 = mortamt2[_n-1] if rectype == "P" replace condofee = condofee[_n-1] if rectype == "P" replace moblhome = moblhome[_n-1] if rectype == "P" replace rfarm = rfarm[_n-1] if rectype == "P" replace rgrent = rgrent[_n-1] if rectype == "P" replace rgrapi = rgrapi[_n-1] if rectype == "P" replace rownrcst = rownrcst[_n-1] if rectype == "P" replace rnsmocpi = rnsmocpi[_n-1] if rectype == "P" replace rrentunt = rrentunt[_n-1] if rectype == "P" replace rvalunt = rvalunt[_n-1] if rectype == "P" replace rfaminc = rfaminc[_n-1] if rectype == "P" replace rhhinc = rhhinc[_n-1] if rectype == "P" replace rwrkr89 = rwrkr89[_n-1] if rectype == "P" replace rhhlang = rhhlang[_n-1] if rectype == "P" replace rlingiso = rlingiso[_n-1] if rectype == "P" replace rhhfamtp = rhhfamtp[_n-1] if rectype == "P" replace rnatadpt = rnatadpt[_n-1] if rectype == "P" replace rstpchld = rstpchld[_n-1] if rectype == "P" replace rfampers = rfampers[_n-1] if rectype == "P" replace rnrlchld = rnrlchld[_n-1] if rectype == "P" replace rnonrel = rnonrel[_n-1] if rectype == "P" replace r18undr = r18undr[_n-1] if rectype == "P" replace r60over = r60over[_n-1] if rectype == "P" replace r65over = r65over[_n-1] if rectype == "P" replace rsubfam = rsubfam[_n-1] if rectype == "P" replace aunits1 = aunits1[_n-1] if rectype == "P" replace arooms = arooms[_n-1] if rectype == "P" replace atenure = atenure[_n-1] if rectype == "P" replace aacres10 = aacres10[_n-1] if rectype == "P" replace acommuse = acommuse[_n-1] if rectype == "P" replace avalue = avalue[_n-1] if rectype == "P" replace arent1 = arent1[_n-1] if rectype == "P" replace ameals = ameals[_n-1] if rectype == "P" replace avacncy2 = avacncy2[_n-1] if rectype == "P" replace avacncy3 = avacncy3[_n-1] if rectype == "P" replace avacncy4 = avacncy4[_n-1] if rectype == "P" replace ayrmoved = ayrmoved[_n-1] if rectype == "P" replace abedroom = abedroom[_n-1] if rectype == "P" replace aplumbng = aplumbng[_n-1] if rectype == "P" replace akitchen = akitchen[_n-1] if rectype == "P" replace aphone = aphone[_n-1] if rectype == "P" replace avehicle = avehicle[_n-1] if rectype == "P" replace afuel = afuel[_n-1] if rectype == "P" replace awater = awater[_n-1] if rectype == "P" replace asewer = asewer[_n-1] if rectype == "P" replace ayrbuilt = ayrbuilt[_n-1] if rectype == "P" replace acondo = acondo[_n-1] if rectype == "P" replace aoneacre = aoneacre[_n-1] if rectype == "P" replace aagsales = aagsales[_n-1] if rectype == "P" replace aeleccst = aeleccst[_n-1] if rectype == "P" replace agascst = agascst[_n-1] if rectype == "P" replace awatrcst = awatrcst[_n-1] if rectype == "P" replace afuelcst = afuelcst[_n-1] if rectype == "P" replace ataxamt = ataxamt[_n-1] if rectype == "P" replace ainsamt = ainsamt[_n-1] if rectype == "P" replace amortg = amortg[_n-1] if rectype == "P" replace amortg3 = amortg3[_n-1] if rectype == "P" replace ataxincl = ataxincl[_n-1] if rectype == "P" replace ainsincl = ainsincl[_n-1] if rectype == "P" replace amortg2 = amortg2[_n-1] if rectype == "P" replace amrtamt2 = amrtamt2[_n-1] if rectype == "P" replace acndofee = acndofee[_n-1] if rectype == "P" replace amoblhme = amoblhme[_n-1] if rectype == "P" keep if rectype=="P" *Everything below this point are value labels #delimit ; ; label values sample sample; label define sample 1 "5% sample" 2 "1% sample" 3 "Elderly" ; label values division division; label define 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)" ; label values state state; label define state 99 "PUMA boundaries cross state lines - 1% file" ; label values puma puma; label define puma 99999 "PUMA code (Includes tract groups) 1st 3" ; label values areatype areatype; label define 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" ; label values msapmsa msapmsa; label define 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" ; label values psa psa; label define psa 0 "N/A (Elderly PUMS only)" ; label values houswgt houswgt; label define houswgt 1152 "Integer weight of housing unit" ; label values persons persons; label define persons 0 "Vacant unit" 1 "One person record (one person in household" ; label values gqinst gqinst; label define gqinst 0 "N/A (housing unit)" 1 "Institutionalized" 2 "Not institutionalized" ; label values units1 units1l; label define units1l 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" ; label values husflag husflag; label define husflag 0 "No" 1 "Yes" ; label values pdsflag pdsflag; label define pdsflag 0 "No" 1 "Yes" ; label values rooms rooms; label define 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" ; label values tenure tenure; label define 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" ; label values acre10 acre10l; label define acre10l 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" ; label values commuse commuse; label define commuse 0 "N/A (GQ/not a one-family house or mobile home)" 2 "No" ; label values value value; label define 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" ; label values rent1 rent1l; label define rent1l 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)" ; label values meals meals; label define meals 0 "N/A (GQ/not a rental unit/rental-NCR)" 1 "Yes" 2 "No" ; label values vacancy1 vacancys; label define vacancys 0 "N/A (occupied or regular vacant/GQ)" 1 "Vacant UHE-owner" 2 "Vacant UHE-renter" 3 "Vacant UHE-undetermined" ; label values vacancy2 vacancyk; label define vacancyk 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" ; label values vacancy3 vacancyl; label define vacancyl 0 "N/A (occupied/GQ)" 1 "Yes" 2 "No" ; label values vacancy4 vacancym; label define vacancym 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" ; label values yrmoved yrmoved; label define 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" ; label values bedrooms bedrooms; label define 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" ; label values plumbing plumbing; label define plumbing 0 "N/A (GQ)" 1 "Yes, all three facilities" 2 "No" ; label values kitchen kitchen; label define kitchen 0 "N/A (GQ)" 1 "Yes" 2 "No" ; label values telephon telephon; label define telephon 0 "N/A (GQ/vacant)" 1 "Yes" 2 "No" ; label values autos autos; label define 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" ; label values fuelheat fuelheat; label define 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" ; label values water water; label define 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." ; label values sewage sewage; label define sewage 0 "N/A (GQ)" 1 "Public sewer" 2 "Septic tank or cesspool" 3 "Other means" ; label values yrbuilt yrbuilt; label define 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" ; label values condo condo; label define condo 0 "N/A (GQ)" 1 "Yes" 2 "No" ; label values oneacre oneacre; label define oneacre 0 "N/A (GQ, two or more units in structure)" 1 "Yes" 2 "No" ; label values agsales agsales; label define 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" ; label values eleccost eleccost; label define eleccost 0 "N/A (GQ/vacant)" 1 "Included in rent or in condo fee" 0002 "No charge or electricity not used" 3100 "Topcode" ; label values gascost gascost; label define gascost 0 "N/A (GQ/vacant)" 1 "Included in rent or in condo fee" 0002 "No charge or gas not used" 2100 "Topcode" ; label values watrcost watrcost; label define watrcost 0 "N/A (GQ/vacant)" 001 "Included in rent or in condo fee" 002 "No charge" 1000 "Topcode" ; label values fuelcost fuelcost; label define fuelcost 0 "N/A (GQ/vacant)" 1 "Included in rent or in condo fee" 0002 "No charge or these fuels not used" 1900 "Topcode" ; label values rtaxamt rtaxamt; label define 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" ; label values insamt insamt; label define insamt 0 "N/A (not owned or being bought/not a one" 1 "None" 1300 "Topcode" ; label values mortgag mortgag; label define mortgag 1 "Mortgage deed of trust, or similar debt" 2 "Contract to purchase" 3 "None" ; label values mortgag3 mortgagg; label define mortgagg 0 "N/A (not owned or being bought/not a one" 1 "No regular payment required" 02000 "Topcode" ; label values taxincl taxincl; label define 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" ; label values insincl insincl; label define 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" ; label values mortgag2 mortgagl; label define mortgagl 0 "N/A (GQ/vacant/not owned or being bought/" 1 "Yes" 2 "No" ; label values mortamt2 mortamtl; label define mortamtl 0 "N/A (GQ/vacant/condo/not owned or being" 1 "No regular payment required" 01000 "Topcode" ; label values condofee condofee; label define condofee 0 "N/A (not owned or being bought/not" 0600 "Topcode" ; label values moblhome moblhome; label define moblhome 0 "N/A (GQ/vacant/not owned or being bought/" 3399 "$1 - $3,399 (cost in dollars)" 3400 "Topcode" ; label values rfarm rfarm; label define rfarm 0 "N/A (GQ/urban)" 1 "Rural farm" 2 "Rural nonfarm" ; label values rgrent rgrent; label define rgrent 0 "N/A (GQ/vacant, not rented for cash rent)" 1500 "Topcode" ; label values rgrapi rgrapi; label define 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" ; label values rownrcst rownrcst; label define rownrcst 0 "N/A (not owned or being bought/not a one" 20300 "Topcode" ; label values rnsmocpi rnsmocpi; label define rnsmocpi 0 "N/A (not owned or being bought/not a one family" 101 "101% or more" ; label values rrentunt rrentunt; label define rrentunt 0 "Not specified rent unit" 1 "Specified rent unit" ; label values rvalunt rvalunt; label define rvalunt 0 "Not specified value unit" 1 "Specified value unit" ; label values rfaminc rfaminc; label define rfaminc 0 "N/A(GQ/vacant/no income)" 9999999 "Total family income in dollars (See user notes" ; label values rhhinc rhhinc; label define rhhinc 0 "N/A(GQ/vacant/no income)" ; label values rwrkr89 rwrkr89l; label define rwrkr89l 0 "N/A (GQ/vacant/non-family household)" 1 "No workers" 2 "1 worker" 3 "2 workers" 4 "3 or more workers in family" ; label values rhhlang rhhlang; label define 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" ; label values rlingiso rlingiso; label define rlingiso 0 "N/A (GQ/vacant)" 1 "Not linguistically isolated" 2 "Linguistically isolated" ; label values rhhfamtp rhhfamtp; label define 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" ; label values rnatadpt rnatadpt; label define rnatadpt 0 "N/A(GQ/vacant/no own natural born/adopted" ; label values rstpchld rstpchld; label define rstpchld 0 "N/A(GQ/vacant/no own stepchildren)" ; label values rfampers rfampers; label define rfampers 0 "N/A (GQ/vacant/non-family household)" ; label values rnrlchld rnrlchld; label define rnrlchld 0 "N/A (GQ/vacant/no related children)" ; label values rnonrel rnonrel; label define rnonrel 0 "N/A (No nonrelatives in household/GQ/vacant)" 1 "1 or more nonrelatives in household" ; label values r18undr r18undr; label define r18undr 0 "N/A (No person under 18 in household/GQ/vacant)" 1 "1 or more person under 18 in household" ; label values r60over r60over; label define 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)" ; label values r65over r65over; label define 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)" ; label values rsubfam rsubfam; label define rsubfam 0 "N/A (No subfamilies or not" 1 "1 or more subfamilies" ; label values aunits1 aunits1l; label define aunits1l 0 "No" 1 "Yes" ; label values arooms arooms; label define arooms 0 "No" 1 "Yes" ; label values atenure atenure; label define atenure 0 "No" 1 "Yes" ; label values aacres10 aacres1e; label define aacres1e 0 "No" 1 "Yes" ; label values acommuse acommuse; label define acommuse 0 "No" 1 "Yes" ; label values avalue avalue; label define avalue 0 "No" 1 "Yes" ; label values arent1 arent1l; label define arent1l 0 "No" 1 "Yes" ; label values ameals ameals; label define ameals 0 "No" 1 "Yes" ; label values avacncy2 avacncys; label define avacncys 0 "No" 1 "Yes" ; label values avacncy3 avacncyk; label define avacncyk 0 "No" 1 "Yes" ; label values avacncy4 avacncyl; label define avacncyl 0 "No" 1 "Yes" ; label values ayrmoved ayrmoved; label define ayrmoved 0 "No" 1 "Yes" ; label values abedroom abedroom; label define abedroom 0 "No" 1 "Yes" ; label values aplumbng aplumbng; label define aplumbng 0 "No" 1 "Yes" ; label values akitchen akitchen; label define akitchen 0 "No" 1 "Yes" ; label values aphone aphone; label define aphone 0 "No" 1 "Yes" ; label values avehicle avehicle; label define avehicle 0 "No" 1 "Yes" ; label values afuel afuel; label define afuel 0 "No" 1 "Yes" ; label values awater awater; label define awater 0 "No" 1 "Yes" ; label values asewer asewer; label define asewer 0 "No" 1 "Yes" ; label values ayrbuilt ayrbuilt; label define ayrbuilt 0 "No" 1 "Yes from not answered" 2 "Yes 'don't know'" ; label values acondo acondo; label define acondo 0 "No" 1 "Yes" ; label values aoneacre aoneacre; label define aoneacre 0 "No" 1 "Yes" ; label values aagsales aagsales; label define aagsales 0 "No" 1 "Yes" ; label values aeleccst aeleccst; label define aeleccst 0 "No" 1 "Yes" ; label values agascst agascst; label define agascst 0 "No" 1 "Yes" ; label values awatrcst awatrcst; label define awatrcst 0 "No" 1 "Yes" ; label values afuelcst afuelcst; label define afuelcst 0 "No" 1 "Yes" ; label values ataxamt ataxamt; label define ataxamt 0 "No" 1 "Yes" ; label values ainsamt ainsamt; label define ainsamt 0 "No" 1 "Yes" ; label values amortg amortg; label define amortg 0 "No" 1 "Yes no answer" 2 "Yes from junior mortgage" ; label values amortg3 amortg3l; label define amortg3l 0 "No" 1 "Yes" ; label values ataxincl ataxincl; label define ataxincl 0 "No" 1 "Yes" ; label values ainsincl ainsincl; label define ainsincl 0 "No" 1 "Yes" ; label values amortg2 amortg2l; label define amortg2l 0 "No" 1 "Yes" ; label values amrtamt2 amrtamtl; label define amrtamtl 0 "NO" 1 "Yes" ; label values acndofee acndofee; label define acndofee 0 "No" 1 "Yes" ; label values amoblhme amoblhme; label define amoblhme 0 "No" 1 "Yes" ; label values relat1 relat1l; label define relat1l 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" ; label values sex sex; label define sex 0 "Male" 1 "Female" ; label values age age; label define age 0 "Less than 1 year" 90 "90 or more years old" ; label values marital marital; label define marital 0 "Now married, except separated" 1 "Widowed" 2 "Divorced" 3 "Separated" 4 "Never married or under 15 years old" ; label values pwgt1 pwgt1l; label define pwgt1l 1152 "Person's weight" ; label values remplpar remplpar; label define 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" ; label values rpob rpob; label define 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" ; label values rspouse rspouse; label define 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" ; label values rownchld rownchld; label define rownchld 1 "Own child" 0 "Not own child" ; label values ragechld ragechld; label define 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)" ; label values rrelchld rrelchld; label define rrelchld 1 "Related child" 0 "Not related child" ; label values relat2 relat2l; label define relat2l 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" ; label values subfam2 subfam2l; label define subfam2l 0 "N/A (GQ/not in a subfamily)" 1 "In subfamily 1" 2 "In subfamily 2" 3 "In subfamily 3" ; label values subfam1 subfam1l; label define subfam1l 0 "N/A (GQ/not in a subfamily)" 1 "Husband/wife" 2 "Parent in a parent/child subfamily" 3 "Child in subfamily" ; label values poverty poverty; label define poverty 0 "N/A" 501 "501% or more of poverty value" ; label values pob pob; label define pob 554 "At sea" 555 "Abroad, not specified" ; label values citizen citizen; label define 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" ; label values immigr immigr; label define 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" ; label values school school; label define 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" ; label values yearsch yearsch; label define 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" ; label values ancstry1 ancstryh; label define ancstryh 999 "Not reported" ; label values ancstry2 ancstryk; label define ancstryk 0 "No secondary ancestry" 999 "Not reported" ; label values mobility mobility; label define mobility 0 "N/A(less than 5 years old)" 1 "Yes same house (nonmovers)" 2 "No, different house (movers)" ; label values migstate migstate; label define 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)" ; label values migpuma migpuma; label define migpuma 0 "N/A (person less than 5 years old/lived in" 99900 "Abroad" ; label values lang1 lang1l; label define lang1l 0 "N/A (less than 5 years old)" 1 "Yes, speaks another language" 2 "No, speaks only English" ; label values english english; label define english 0 "N/A (less than 5 years old/speaks only English)" 1 "Very well" 2 "Well" 3 "Not well" 4 "Not at all" ; label values military military; label define 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" ; label values rvetserv rvetserv; label define 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" ; label values sept80 sept80l; label define sept80l 0 "(Did not serve this period/less than 16 years" 1 "Served this period" ; label values may75880 may7588v; label define may7588v 0 "(Did not serve this period/less than 16 years" 1 "Served this period" ; label values vietnam vietnam; label define vietnam 0 "(Did not serve this period/less than 16 years" 1 "Served this period" ; label values feb55 feb55l; label define feb55l 0 "(Did not serve this period/less than 16 years" 1 "Served this period" ; label values korean korean; label define korean 0 "(Did not serve this period/less than 16 years" 1 "Served this period" ; label values wwii wwii; label define wwii 0 "(Did not serve this period/less than 16 years" 1 "Served this period" ; label values othrserv othrserv; label define othrserv 0 "(Did not serve this period/less than 16 years" 1 "Served this period" ; label values yrsserv yrsserv; label define 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" ; label values disabl1 disabl1l; label define disabl1l 0 "N/A (less than 16 years, and selected persons in" 1 "Yes, limited in kind or amount of work" 2 "No, not limited" ; label values disabl2 disabl2l; label define disabl2l 0 "N/A(less than 16 years, and selected persons in" 1 "Yes, prevented from working" 2 "No, not prevented from working" ; label values mobillim mobillim; label define mobillim 0 "N/A (less than 15 years/institutionalized" 1 "Yes, has a mobility limitation" 2 "No, does not have a mobility limitation" ; label values perscare perscare; label define 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" ; label values fertil fertil; label define 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" ; label values rlabor rlabor; label define 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" ; label values worklwk worklwk; label define worklwk 0 "N/A (less than 16 years old/not at work/" 1 "Worked" 2 "Did not work" ; label values hours hours; label define hours 0 "N/A (less than 16 years old/not at" 99 "99 or more hours worked last week" ; label values powstate powstate; label define powstate 0 "N/A (not a worker--not in the labor force," 98 "Abroad" 99 "State not identified" ; label values powpuma powpuma; label define powpuma 0 "N/A (not a worker--not in the labor force," 99900 "Abroad" ; label values means means; label define 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" ; label values riders riders; label define 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" ; label values depart depart; label define depart 0 "N/A (not a worker or worker who worked at" ; label values travtime travtime; label define travtime 0 "N/A (not a worker or worker who worked at home)" 99 "99 Minutes or more to get to work" ; label values tmpabsnt tmpabsnt; label define 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" ; label values looking looking; label define looking 0 "N/A (less than 16 years old/at work/did not" 1 "Yes" 2 "No" ; label values avail avail; label define 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" ; label values yearwrk yearwrk; label define 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" ; label values industry industry; label define industry 0 "N/A (less than 16 years old/unemployed who" ; label values occup occup; label define occup 0 "N/A (less than 16 years old/unemployed who" ; label values class class; label define 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" ; label values work89 work89l; label define work89l 0 "N/A (less than 16 years old)" 1 "Worked last year" 2 "Did not work last year" ; label values week89 week89l; label define week89l 0 "N/A (less than 16 years old/did not work in" ; label values hour89 hour89l; label define hour89l 0 "N/A (less than 16 years old/did not work in" 99 "99 Or more usual hours" ; label values rearning rearning; label define rearning 0 "N/A (no earnings)" -19996 "Loss of $19996 or more" 284000 "$284000 = Topcode" ; label values rpincome rpincome; label define rpincome 0 "N/A (no income)" -29997 "Loss of $29997 or more" 401000 "Topcode of total person's income" ; label values income1 income1l; label define income1l 0 "N/A (less than 16 years old/none)" 139999 "$1 - 139,999" 140000 "Topcode" ; label values income2 income2l; label define income2l 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" ; label values income3 income3l; label define income3l 0 "N/A (less than 16 years/none)" -09999 "Loss of $9,999 or more" 1 "Break even or $1" 054000 "Topcode" ; label values income4 income4l; label define income4l 0 "N/A (less than 15 years/none)" -09999 "Loss of $9,999 or more" 1 "Break even or $1" 040000 "Topcode" ; label values income5 income5l; label define income5l 0 "N/A (less than 15 years/none)" 17000 "Topcode" ; label values income6 income6l; label define income6l 0 "N/A (less than 15 years/none)" 10000 "Topcode" ; label values income7 income7l; label define income7l 0 "N/A (less than 15 years/none)" 30000 "Topcode" ; label values income8 income8l; label define income8l 0 "N/A (less than 15 years/none)" 20000 "Topcode" ; label values aaugment aaugment; label define aaugment 0 "No" 1 "Yes" ; label values arelat1 arelat1l; label define arelat1l 0 "No" 1 "Yes" ; label values asex asex; label define asex 0 "No" 1 "Yes" ; label values arace arace; label define arace 0 "No" 1 "Yes" ; label values aage aage; label define aage 0 "No" 1 "Yes" ; label values amarital amarital; label define amarital 0 "No" 1 "Yes" ; label values ahispan ahispan; label define ahispan 0 "No" 1 "Yes" ; label values abirthpl abirthpl; label define abirthpl 0 "No" 1 "Yes" ; label values acitizen acitizen; label define acitizen 0 "No" 1 "Yes" ; label values aimmigr aimmigr; label define aimmigr 0 "No" 1 "Yes" ; label values aschool aschool; label define aschool 0 "No" 1 "Yes" ; label values ayearsch ayearsch; label define ayearsch 0 "No" 1 "Yes" ; label values aancstr1 aancstrh; label define aancstrh 0 "No" 1 "Yes" ; label values aancstr2 aancstrk; label define aancstrk 0 "No" 1 "Yes" ; label values amoblty amoblty; label define amoblty 0 "No" 1 "Yes" ; label values amigstate amigstate; label define amigstate 0 "No" 1 "Yes" ; label values alang1 alang1l; label define alang1l 0 "No" 1 "Yes" ; label values alang2 alang2l; label define alang2l 0 "No" 1 "Yes" ; label values aenglish aenglish; label define aenglish 0 "No" 1 "Yes" ; label values avets1 avets1l; label define avets1l 0 "No" 1 "Yes" ; label values aservper aservper; label define aservper 0 "No" 1 "Yes" ; label values ayrsserv ayrsserv; label define ayrsserv 0 "No" 1 "Yes" ; label values adisabl1 adisablv; label define adisablv 0 "No" 1 "Yes" ; label values adisabl2 adisablk; label define adisablk 0 "No" 1 "Yes" ; label values amobllim amobllim; label define amobllim 0 "No" 1 "Yes" ; label values apercare apercare; label define apercare 0 "No" 1 "Yes" ; label values afertil afertil; label define afertil 0 "No" 1 "Yes" ; label values alabor alabor; label define alabor 0 "No" 1 "Yes" ; label values ahours ahours; label define ahours 0 "No" 1 "Yes" ; label values apowst apowst; label define apowst 0 "No" 1 "Yes" ; label values ameans ameans; label define ameans 0 "No" 1 "Yes" ; label values ariders ariders; label define ariders 0 "No" 1 "Yes" ; label values adepart adepart; label define adepart 0 "No" 1 "Yes" ; label values atravtme atravtme; label define atravtme 0 "No" 1 "Yes" ; label values alstwrk alstwrk; label define alstwrk 0 "No" 1 "Yes" ; label values aindustr aindustr; label define aindustr 0 "No" 1 "Yes" ; label values aoccup aoccup; label define aoccup 0 "No" 1 "Yes" ; label values aclass aclass; label define aclass 0 "No" 1 "Yes" ; label values awork89 awork89l; label define awork89l 0 "No" 1 "Yes" ; label values awks89 awks89l; label define awks89l 0 "No" 1 "Yes" ; label values ahour89 ahour89l; label define ahour89l 0 "No" 1 "Yes" ; label values aincome1 aincomes; label define aincomes 0 "No" 1 "No (derived)" 2 "Yes" ; label values aincome2 aincomek; label define aincomek 0 "No" 1 "No (derived)" 2 "Yes" ; label values aincome3 aincomel; label define aincomel 0 "No" 1 "No (derived)" 2 "Yes" ; label values aincome4 aincomem; label define aincomem 0 "No" 1 "No (derived)" 2 "Yes" ; label values aincome5 aincomen; label define aincomen 0 "No" 1 "No (derived)" 2 "Yes" ; label values aincome6 aincomeo; label define aincomeo 0 "No" 1 "No (derived)" 2 "Yes" ; label values aincome7 aincomep; label define aincomep 0 "No" 1 "No (derived)" 2 "Yes" ; label values aincome8 aincomeq; label define aincomeq 0 "No" 1 "No (derived)" 2 "Yes" ; #delimit cr save `dta_name' , replace end *pct 1 al 01 Alabama *pct 1 ak 02 Alaska *pct 1 az 04 Arizona *pct 1 ar 05 Arkansas *pct 1 ca 06 California *pct 1 co 08 Colorado *pct 1 ct 09 Connecticut *pct 1 de 10 Delaware *pct 1 dc 11 District_of_Columbia *pct 1 fl 12 Florida *pct 1 ga 13 Georgia *pct 1 hi 15 Hawaii *pct 1 id 16 Idaho *pct 1 il 17 Illinois *pct 1 in 18 Indiana *pct 1 ia 19 Iowa *pct 1 ks 20 Kansas *pct 1 ky 21 Kentucky *pct 1 la 22 Louisiana *pct 1 me 23 Maine *pct 1 md 24 Maryland *pct 1 ma 25 Massachusetts *pct 1 mi 26 Michigan *pct 1 mn 27 Minnesota *pct 1 ms 28 Mississippi *pct 1 mo 29 Missouri *pct 1 mt 30 Montana *pct 1 ne 31 Nebraska *pct 1 nv 32 Nevada *pct 1 nh 33 New_Hampshire *pct 1 nj 34 New_Jersey *pct 1 nm 35 New_Mexico *pct 1 ny 36 New_York *pct 1 nc 37 North_Carolina *pct 1 nd 38 North_Dakota *pct 1 oh 39 Ohio *pct 1 ok 40 Oklahoma *pct 1 or 41 Oregon *pct 1 pa 42 Pennsylvania *pct 1 ri 44 Rhode_Island *pct 1 sc 45 South_Carolina pct 1 sd 46 South_Dakota *pct 1 tn 47 Tennessee *pct 1 tx 48 Texas *pct 1 ut 49 Utah *pct 1 vt 50 Vermont *pct 1 va 51 Virginia *pct 1 wa 53 Washington *pct 1 wv 54 West_Virginia *pct 1 wi 55 Wisconsin *pct 1 wy 56 Wyoming