/* Important: you need to put the .dat and .do files in one folder/ directory and then set the working folder to that folder. */ set more off clear infix /// byte year 1-2 /// int hhwt 3-6 /// byte statefip 7-8 /// long puma 9-13 /// byte gq 14 /// int perwt 15-18 /// int race 19 /// int hispan 20 /// using tedmouw_email_unc_edu_110.dat label var year "Census year" label var hhwt "Household weight" label var statefip "State (FIPS code)" label var puma "Public Use Microdata Area" label var gq "Group quarters status" label var perwt "Person weight" label var race "Race [general version]" label var hispan "Hispanic origin [general version]" label define yearlbl 00 "2000" label define yearlbl 01 "2001", add label define yearlbl 02 "2002", add label define yearlbl 03 "2003", add label define yearlbl 04 "2004", add label define yearlbl 05 "2005", add label define yearlbl 85 "1850", add label define yearlbl 86 "1860", add label define yearlbl 87 "1870", add label define yearlbl 88 "1880", add label define yearlbl 90 "1900", add label define yearlbl 91 "1910", add label define yearlbl 92 "1920", add label define yearlbl 93 "1930", add label define yearlbl 94 "1940", add label define yearlbl 95 "1950", add label define yearlbl 96 "1960", add label define yearlbl 97 "1970", add label define yearlbl 98 "1980", add label define yearlbl 99 "1990", add label values year yearlbl label values hhwt hhwtlbl label define statefiplbl 01 "Alabama", add label define statefiplbl 02 "Alaska", add label define statefiplbl 04 "Arizona", add label define statefiplbl 05 "Arkansas", add label define statefiplbl 06 "California", add label define statefiplbl 08 "Colorado", add label define statefiplbl 09 "Connecticut", add label define statefiplbl 10 "Delaware", add label define statefiplbl 11 "District of Columbia", add label define statefiplbl 12 "Florida", add label define statefiplbl 13 "Georgia", add label define statefiplbl 15 "Hawaii", add label define statefiplbl 16 "Idaho", add label define statefiplbl 17 "Illinois", add label define statefiplbl 18 "Indiana", add label define statefiplbl 19 "Iowa", add label define statefiplbl 20 "Kansas", add label define statefiplbl 21 "Kentucky", add label define statefiplbl 22 "Louisiana", add label define statefiplbl 23 "Maine", add label define statefiplbl 24 "Maryland", add label define statefiplbl 25 "Massachusetts", add label define statefiplbl 26 "Michigan", add label define statefiplbl 27 "Minnesota", add label define statefiplbl 28 "Mississippi", add label define statefiplbl 29 "Missouri", add label define statefiplbl 30 "Montana", add label define statefiplbl 31 "Nebraska", add label define statefiplbl 32 "Nevada", add label define statefiplbl 33 "New Hampshire", add label define statefiplbl 34 "New Jersey", add label define statefiplbl 35 "New Mexico", add label define statefiplbl 36 "New York", add label define statefiplbl 37 "North Carolina", add label define statefiplbl 38 "North Dakota", add label define statefiplbl 39 "Ohio", add label define statefiplbl 40 "Oklahoma", add label define statefiplbl 41 "Oregon", add label define statefiplbl 42 "Pennsylvania", add label define statefiplbl 44 "Rhode island", add label define statefiplbl 45 "South Carolina", add label define statefiplbl 46 "South Dakota", add label define statefiplbl 47 "Tennessee", add label define statefiplbl 48 "Texas", add label define statefiplbl 49 "Utah", add label define statefiplbl 50 "Vermont", add label define statefiplbl 51 "Virginia", add label define statefiplbl 53 "Washington", add label define statefiplbl 54 "West Virginia", add label define statefiplbl 55 "Wisconsin", add label define statefiplbl 56 "Wyoming", add label define statefiplbl 61 "Maine-New Hampshire-Vermont", add label define statefiplbl 62 "Massachusetts-Rhode Island", add label define statefiplbl 63 "Minnesota-Iowa-Missouri-Kansas-Nebraska-S.Dakota-N.Dakota", add label define statefiplbl 64 "Maryland-Delaware", add label define statefiplbl 65 "Montana-Idaho-Wyoming", add label define statefiplbl 66 "Utah-Nevada", add label define statefiplbl 67 "Arizona-New Mexico", add label define statefiplbl 68 "Alaska-Hawaii", add label define statefiplbl 72 "Puerto Rico", add label define statefiplbl 97 "Military/Mil. Reservation", add label define statefiplbl 99 "State not identified", add label values statefip statefiplbl label values puma pumalbl label define gqlbl 0 "Vacant unit", add label define gqlbl 1 "Households under 1970 definition", add label define gqlbl 2 "Additional households under 1990 definition", add label define gqlbl 3 "Group quarters--Institutions", add label define gqlbl 4 "Other group quarters", add label define gqlbl 5 "Additional households under 2000 definition", add label define gqlbl 6 "Fragment", add label values gq gqlbl label values perwt perwtlbl label define racelbl 1 "White" label define racelbl 2 "Black/Negro", add label define racelbl 3 "American Indian or Alaska Native", add label define racelbl 4 "Chinese", add label define racelbl 5 "Japanese", add label define racelbl 6 "Other Asian or Pacific Islander", add label define racelbl 7 "Other race, nec", add label define racelbl 8 "Two major races", add label define racelbl 9 "Three or more major races", add label values race racelbl label define hispanlbl 0 "Not Hispanic" label define hispanlbl 1 "Mexican", add label define hispanlbl 2 "Puerto Rican", add label define hispanlbl 3 "Cuban", add label define hispanlbl 4 "Other", add label define hispanlbl 9 "Not Reported", add label values hispan hispanlbl