infile dictionary { *This program reads the 1990 1% and 5% Public Use Microdata Sample (PUMS) Data Files *by Jean Roth Wed Jan 31 12:49:50 EST 2007 *Please report errors to jroth@nber.org *run with do pums1990 *The raw PUMS data files have a hierarchical structure. *A household record is followed by zero or more person records. *This program produces a person level dataset with household data appended *Remember, household and is repeated for each person in the dataset. *Change output file name/location as desired in the first line of the .dct file *If you are using a PC, you may need to change the direction of the slashes, as in C:\ * or "\\Nber\home\data\PUMS\1990\1pct\pums_56.dat" * The following changes in variable names have been made, if necessary: * '$' to 'd'; '-' to '_'; '%' to 'p'; * Note: Variable names in Stata are case-sensitive _column(1 ) str1 rectype %1s "Record Type" _column(2 ) long serialno %7f _column(9 ) byte sample %1f "Sample Identifier" _column(10 ) byte division %1f "Division code" _column(11 ) byte state %2f "State Code" _column(13 ) long puma %5f "Public use microdata area (state depen" _column(18 ) byte areatype %2f "Area type revised for PUMS equivalency" _column(20 ) int msapmsa %4f "MSA/PMSA" _column(24 ) int psa %3f "Planning service area (elderly sample " _column(27 ) byte subsampl %2f "Subsample number (Use to pull extracts" _column(29 ) int houswgt %4f "Housing Weight" _column(33 ) byte persons %2f "Number of person records following thi" _column(35 ) byte gqinst %1f "Group quarters institution" _column(39 ) byte units1 %2f "Units in structure" _column(41 ) byte husflag %1f "All 100% housing unit data substituted" _column(42 ) byte pdsflag %1f "All 100% person data substituted" _column(43 ) byte rooms %1f "Rooms" _column(44 ) byte tenure %1f "Tenure" _column(45 ) byte acre10 %1f "On ten acres or more" _column(46 ) byte commuse %1f "Business or medical office on property" _column(47 ) byte value %2f "Property value" _column(49 ) byte rent1 %2f "Monthly rent" _column(51 ) byte meals %1f "Meals included in rent" _column(52 ) byte vacancy1 %1f "Vacant usual home elsewhere (UHE)" _column(53 ) byte vacancy2 %1f "Vacancy status" _column(54 ) byte vacancy3 %1f "Boarded up status" _column(55 ) byte vacancy4 %1f "Months vacant" _column(56 ) byte yrmoved %1f "When moved into this house or apartmen" _column(57 ) byte bedrooms %1f "Bedrooms" _column(58 ) byte plumbing %1f "Complete plumbing facilities" _column(59 ) byte kitchen %1f "Complete kitchen facilities" _column(60 ) byte telephon %1f "Telephone in Unit" _column(61 ) byte autos %1f "Vehicles (1 ton or less) available" _column(62 ) byte fuelheat %1f "House heating fuel" _column(63 ) byte water %1f "Source of water" _column(64 ) byte sewage %1f "Sewage disposal" _column(65 ) byte yrbuilt %1f "When structure first built" _column(66 ) byte condo %1f "House or apartment part of condominium" _column(67 ) byte oneacre %1f "House on less than 1 acre" _column(68 ) byte agsales %1f "1989 Sales of Agriculture Products" _column(69 ) int eleccost %4f "Electricity (yearly cost)*" _column(73 ) int gascost %4f "Gas (yearly cost)*" _column(77 ) int watrcost %4f "Water (yearly cost)" _column(81 ) int fuelcost %4f "House heating fuel (yearly cost)" _column(85 ) byte rtaxamt %2f "Property taxes (yearly amount)" _column(90 ) int insamt %4f "Fire/hazard/flood insurance (yearly am" _column(94 ) byte mortgag %1f "Mortgage status" _column(95 ) long mortgag3 %5f "Mortgage payment (monthly amount)" _column(100 ) byte taxincl %1f "Payment include real estate taxes" _column(101 ) byte insincl %1f "Payment include fire/hazard/flood insu" _column(102 ) byte mortgag2 %1f "Second mortgage or home equity loan st" _column(103 ) long mortamt2 %5f "Second mortgage payment (monthly amoun" _column(108 ) int condofee %4f "Condo fee (monthly amount)" _column(112 ) int moblhome %4f "Mobile home costs (yearly amount)" _column(116 ) byte rfarm %1f "Farm/nonfarm status" _column(117 ) int rgrent %4f "Gross rent" _column(121 ) byte rgrapi %2f "Gross rent as a percentage of househol" _column(124 ) long rownrcst %5f "Selected monthly owner costs" _column(129 ) int rnsmocpi %3f "Selected monthly owner costs as a perc" _column(132 ) byte rrentunt %1f "Specified rent unit" _column(133 ) byte rvalunt %1f "Specified value unit" _column(134 ) long rfaminc %7f "Family income" _column(141 ) long rhhinc %7f "Household income" _column(148 ) byte rwrkr89 %1f "Workers in family in 1989" _column(149 ) byte rhhlang %1f "Household language" _column(150 ) byte rlingiso %1f "Linguistic isolation" _column(151 ) byte rhhfamtp %2f "Household/family type" _column(153 ) byte rnatadpt %2f "Number of own natural born/adopted chi" _column(155 ) byte rstpchld %2f "Number of own stepchildren in househol" _column(157 ) byte rfampers %2f "Number of persons in family (unweighte" _column(159 ) byte rnrlchld %2f "Number of related children in househol" _column(161 ) byte rnonrel %1f "Presence of nonrelatives in household" _column(162 ) byte r18undr %1f "Presence of person under 18 years in h" _column(163 ) byte r60over %1f "Presence of persons 60 years and over " _column(164 ) byte r65over %1f "Presence of person 65 years and over i" _column(165 ) byte rsubfam %1f "Presence of subfamilies in Household" _column(166 ) byte aunits1 %1f "Units in structure allocation" _column(167 ) byte arooms %1f "Rooms allocation" _column(168 ) byte atenure %1f "Tenure allocation" _column(169 ) byte aacres10 %1f "On ten acres or more allocation" _column(170 ) byte acommuse %1f "Business or medical office on property" _column(171 ) byte avalue %1f "Value allocation" _column(172 ) byte arent1 %1f "Monthly rent allocation" _column(173 ) byte ameals %1f "Meals included in rent allocation" _column(174 ) byte avacncy2 %1f "Vacancy status allocation" _column(175 ) byte avacncy3 %1f "Boarded up status allocation" _column(176 ) byte avacncy4 %1f "Months vacant allocation" _column(177 ) byte ayrmoved %1f "When moved into this house or apartmen" _column(178 ) byte abedroom %1f "Number of bedrooms allocation" _column(179 ) byte aplumbng %1f "Complete plumbing facilities allocatio" _column(180 ) byte akitchen %1f "Complete kitchen facilities allocation" _column(181 ) byte aphone %1f "Telephones in house allocation" _column(182 ) byte avehicle %1f "Vehicles available by household alloca" _column(183 ) byte afuel %1f "House heating fuel allocation" _column(184 ) byte awater %1f "Source of water allocation" _column(185 ) byte asewer %1f "Sewage disposal allocation" _column(186 ) byte ayrbuilt %1f "When structure first built allocation" _column(187 ) byte acondo %1f "House or apartment part of condominium" _column(188 ) byte aoneacre %1f "House on less than 1 acre allocation" _column(189 ) byte aagsales %1f "1989 Sales of Agricultural Products al" _column(190 ) byte aeleccst %1f "Electricity (yearly cost) allocation" _column(191 ) byte agascst %1f "Gas (yearly cost) allocation" _column(192 ) byte awatrcst %1f "Water (yearly cost) allocation" _column(193 ) byte afuelcst %1f "House heating fuel (yearly cost) alloc" _column(194 ) byte ataxamt %1f "Taxes on property allocation" _column(195 ) byte ainsamt %1f "Fire, hazard, flood insurance allocati" _column(196 ) byte amortg %1f "Mortgage status allocation" _column(197 ) byte amortg3 %1f "Regular mortgage payment allocation" _column(198 ) byte ataxincl %1f "Payment include real estate taxes allo" _column(199 ) byte ainsincl %1f "Payment include fire, hazard, flood in" _column(200 ) byte amortg2 %1f "Second mortgage status allocation" _column(201 ) byte amrtamt2 %1f "Second mortgage payment allocation" _column(202 ) byte acndofee %1f "Condominium fee allocation" _column(203 ) byte amoblhme %1f "Mobile home costs allocation" _column(9 ) byte relat1 %2f "Relationship" _column(11 ) byte sex %1f "Sex" _column(12 ) int race %3f "Recoded detailed race code (Appendix C" _column(15 ) byte age %2f "Age" _column(17 ) byte marital %1f "Marital status" _column(18 ) int pwgt1 %4f "Person's weight" _column(26 ) int remplpar %3f "Employment status of parents" _column(29 ) byte rpob %2f "Place of birth (Recode)" _column(31 ) byte rspouse %1f "Married, spouse present/spouse absent" _column(32 ) byte rownchld %1f "*Own child (see Appendix B, page 14)" _column(33 ) byte ragechld %1f "Presence and age of own children" _column(34 ) byte rrelchld %1f _column(35 ) byte relat2 %1f "Detailed relationship (other relative)" _column(36 ) byte subfam2 %1f "Subfamily number" _column(37 ) byte subfam1 %1f "Subfamily relationship" _column(38 ) int hispanic %3f "Detailed Hispanic origin code (See app" _column(41 ) int poverty %3f "Person poverty status recode (See appe" _column(44 ) int pob %3f "Place of birth (Appendix I)" _column(47 ) byte citizen %1f "Citizenship" _column(48 ) byte immigr %2f "Year of entry" _column(50 ) byte school %1f "School enrollment" _column(51 ) byte yearsch %2f "Educational attainment" _column(53 ) int ancstry1 %3f "Ancestry - first entry (See appendix I" _column(56 ) int ancstry2 %3f "Ancestry - second entry (See appendix " _column(59 ) byte mobility %1f "Mobility status (lived here on April 1" _column(60 ) byte migstate %2f "Migration - State or foreign country c" _column(62 ) long migpuma %5f "Migration PUMA (state dependent)" _column(67 ) byte lang1 %1f "Language other than English at home" _column(68 ) int lang2 %3f "Language spoken at home (See appendix " _column(71 ) byte english %1f "Ability to speak English" _column(72 ) byte military %1f "Military service" _column(73 ) byte rvetserv %2f "Veteran period of service" _column(75 ) byte sept80 %1f "Served September 1980 or later" _column(76 ) byte may75880 %1f "Served May 1975 to August 1980" _column(77 ) byte vietnam %1f "Served Vietnam era (August 1964 - Apri" _column(78 ) byte feb55 %1f "Served February 1955 - July 1964" _column(79 ) byte korean %1f "Served Korean conflict (June 1950 - Ja" _column(80 ) byte wwii %1f "Served World War II (September 1940 - " _column(82 ) byte othrserv %1f "Served any other time" _column(83 ) byte yrsserv %2f "Years of active duty military service" _column(85 ) byte disabl1 %1f "Work limitation status" _column(86 ) byte disabl2 %1f "Work prevented status" _column(87 ) byte mobillim %1f "Mobility limitation" _column(88 ) byte perscare %1f "Personal care limitation" _column(89 ) byte fertil %2f "Number of children ever born" _column(91 ) byte rlabor %1f "Employment status recode" _column(92 ) byte worklwk %1f "Worked last week" _column(93 ) byte hours %2f "Hours worked last week" _column(95 ) byte powstate %2f "Place of work - state - (Appendix I)" _column(97 ) long powpuma %5f "Place of work PUMA (State dependent)" _column(102 ) byte means %2f "Means of transportation to work" _column(104 ) byte riders %1f "Vehicle occupancy" _column(105 ) int depart %4f "Time of departure for work - hour and " _column(109 ) byte travtime %2f "Travel time to work" _column(111 ) byte tmpabsnt %1f "Temporary absence from work" _column(112 ) byte looking %1f "Looking for work" _column(113 ) byte avail %1f "Available for work" _column(114 ) byte yearwrk %1f "Year last worked" _column(115 ) int industry %3f "Industry" _column(118 ) int occup %3f "Occupation" _column(121 ) byte class %1f "Class of worker" _column(122 ) byte work89 %1f "Worked last year (1989)" _column(123 ) byte week89 %2f "Weeks worked last year (1989)" _column(125 ) byte hour89 %2f "Usual hours worked per week last year " _column(127 ) long rearning %6f "Total person's earnings" _column(133 ) long rpincome %6f "Total person's income (signed)" _column(139 ) long income1 %6f "Wages or salary income in 1989" _column(145 ) long income2 %6f "Nonfarm self-employment income in 1989" _column(151 ) long income3 %6f "Farm self-employment income in 1989 (s" _column(157 ) long income4 %6f "Interest, dividends, and net rental in" _column(163 ) long income5 %5f "Social security income in 1989" _column(168 ) long income6 %5f "Public assistance income in 1989" _column(173 ) long income7 %5f "Retirement income in 1989" _column(178 ) long income8 %5f "All other income in 1989" _column(183 ) byte aaugment %1f "Augmented person (see text pp. C-5)" _column(184 ) byte arelat1 %1f "Relationship allocation flag" _column(185 ) byte asex %1f "Sex allocation flag" _column(186 ) byte arace %1f "Detailed race allocation flag" _column(187 ) byte aage %1f "Age allocation flag" _column(188 ) byte amarital %1f "Marital status allocation flag" _column(189 ) byte ahispan %1f "Detailed Hispanic origin allocation fl" _column(190 ) byte abirthpl %1f "Place of birth" _column(191 ) byte acitizen %1f "Citizenship allocation flag" _column(192 ) byte aimmigr %1f "Year of entry allocation flag" _column(193 ) byte aschool %1f "School enrollment allocation flag" _column(194 ) byte ayearsch %1f "Highest education allocation flag" _column(195 ) byte aancstr1 %1f "First ancestry allocation flag" _column(196 ) byte aancstr2 %1f "Second ancestry allocation flag" _column(197 ) byte amoblty %1f "Mobility status allocation flag" _column(198 ) byte amigstate %1f "Migration state allocation flag" _column(199 ) byte alang1 %1f "Language other than English allocation" _column(200 ) byte alang2 %1f "Language spoken at home allocation fla" _column(201 ) byte aenglish %1f "Ability to speak English allocation fl" _column(202 ) byte avets1 %1f "Military service allocation flag" _column(203 ) byte aservper %1f "Military periods of service allocation" _column(204 ) byte ayrsserv %1f "Years of military service allocation f" _column(205 ) byte adisabl1 %1f "Work limitation status allocation flag" _column(206 ) byte adisabl2 %1f "Work prevention status allocation flag" _column(207 ) byte amobllim %1f "Mobility limitation status allocation " _column(208 ) byte apercare %1f "Personal care limitation status alloca" _column(209 ) byte afertil %1f "Children ever born allocation flag" _column(210 ) byte alabor %1f "Employment status recode allocation fl" _column(211 ) byte ahours %1f "Hours worked last week allocation flag" _column(212 ) byte apowst %1f "Place of work state allocation flag" _column(213 ) byte ameans %1f "Means of transportation to work alloca" _column(214 ) byte ariders %1f "Vehicle occupancy allocation flag" _column(215 ) byte adepart %1f "Time of departure to work allocation f" _column(216 ) byte atravtme %1f "Travel time to work allocation flag" _column(217 ) byte alstwrk %1f "Year last worked allocation flag" _column(218 ) byte aindustr %1f "Industry allocation flag" _column(219 ) byte aoccup %1f "Occupation allocation flag" _column(220 ) byte aclass %1f "Class of worker allocation flag" _column(221 ) byte awork89 %1f "Worked last year allocation flag" _column(222 ) byte awks89 %1f "Weeks worked in 1989 allocation flag" _column(223 ) byte ahour89 %1f "Usual hours worked per week in 1989 al" _column(224 ) byte aincome1 %1f "Wages and salary income allocation fla" _column(225 ) byte aincome2 %1f "Nonfarm self-employment income allocat" _column(226 ) byte aincome3 %1f "Farm self-employment income allocation" _column(227 ) byte aincome4 %1f "Interest, dividend, and net rental inc" _column(228 ) byte aincome5 %1f "Social security income allocation flag" _column(229 ) byte aincome6 %1f "Public assistance allocation flag" _column(230 ) byte aincome7 %1f "Retirement income allocation flag" _column(231 ) byte aincome8 %1f "All other income allocation flag" }