/* 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 /// int year 1-4 /// float hhwt 5-11 /// byte statefip 12-13 /// float perwt 14-21 /// byte age 22-23 /// byte sex 24 /// int race 25-27 /// byte marst 28 /// byte agemarr 29-30 /// using rawdata.dat replace hhwt=hhwt/100 replace perwt=perwt/100 label var year "Survey year" label var hhwt "Household weight" label var statefip "State (FIPS code)" label var perwt "Person weight" label var age "Age" label var sex "Sex" label var race "Race" label var marst "Marital status" label var agemarr "Age at first marriage" label values year yearlbl label values hhwt hhwtlbl label define statefiplbl 01 "Alabama" 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 65 "Montana-Idaho-Wyoming", add label define statefiplbl 68 "Alaska-Hawaii", add label define statefiplbl 69 "Nebraska-North Dakota-South Dakota", add label define statefiplbl 70 "Maine-Massachusetts-New Hampshire-Rhode Island-Vermont", add label define statefiplbl 71 "Michigan-Wisconsin", add label define statefiplbl 72 "Minnesota-Iowa", add label define statefiplbl 73 "Nebraska-North Dakota-South Dakota-Kansas", add label define statefiplbl 74 "Delaware-Virginia", add label define statefiplbl 75 "North Carolina-South Carolina", add label define statefiplbl 76 "Alabama-Mississippi", add label define statefiplbl 77 "Arkansas-Oklahoma", add label define statefiplbl 78 "Arizona-New Mexico-Colorado", add label define statefiplbl 79 "Idaho-Wyoming-Utah-Montana-Nevada", add label define statefiplbl 80 "Alaska-Washington-Hawaii", add label define statefiplbl 81 "New Hampshire-Maine-Vermont-Rhode Island", add label define statefiplbl 83 "South Carolina-Georgia", add label define statefiplbl 84 "Kentucky-Tennessee", add label define statefiplbl 85 "Arkansas-Louisiana-Oklahoma", add label define statefiplbl 86 "Montana-Idaho-Wyoming-Colorado-New Mexico-Utah-Nevada", add label define statefiplbl 87 "Iowa-N Dakota-S Dakota-Nebraska-Kansas-Minnesota-Missouri", add label define statefiplbl 88 "Washington-Oregon-Alaska-Hawaii", add label define statefiplbl 89 "Montana-Wyoming-Colorado-New Mexico-Utah-Nevada-Arizona", add label define statefiplbl 90 "Delaware-Maryland-Virginia-West Virginia", add label define statefiplbl 99 "State not identified", add label values statefip statefiplbl label values perwt perwtlbl label define agelbl 00 "Under 1 year" label define agelbl 01 "1", add label define agelbl 02 "2", add label define agelbl 03 "3", add label define agelbl 04 "4", add label define agelbl 05 "5", add label define agelbl 06 "6", add label define agelbl 07 "7", add label define agelbl 08 "8", add label define agelbl 09 "9", add label define agelbl 10 "10", add label define agelbl 11 "11", add label define agelbl 12 "12", add label define agelbl 13 "13", add label define agelbl 14 "14", add label define agelbl 15 "15", add label define agelbl 16 "16", add label define agelbl 17 "17", add label define agelbl 18 "18", add label define agelbl 19 "19", add label define agelbl 20 "20", add label define agelbl 21 "21", add label define agelbl 22 "22", add label define agelbl 23 "23", add label define agelbl 24 "24", add label define agelbl 25 "25", add label define agelbl 26 "26", add label define agelbl 27 "27", add label define agelbl 28 "28", add label define agelbl 29 "29", add label define agelbl 30 "30", add label define agelbl 31 "31", add label define agelbl 32 "32", add label define agelbl 33 "33", add label define agelbl 34 "34", add label define agelbl 35 "35", add label define agelbl 36 "36", add label define agelbl 37 "37", add label define agelbl 38 "38", add label define agelbl 39 "39", add label define agelbl 40 "40", add label define agelbl 41 "41", add label define agelbl 42 "42", add label define agelbl 43 "43", add label define agelbl 44 "44", add label define agelbl 45 "45", add label define agelbl 46 "46", add label define agelbl 47 "47", add label define agelbl 48 "48", add label define agelbl 49 "49", add label define agelbl 50 "50", add label define agelbl 51 "51", add label define agelbl 52 "52", add label define agelbl 53 "53", add label define agelbl 54 "54", add label define agelbl 55 "55", add label define agelbl 56 "56", add label define agelbl 57 "57", add label define agelbl 58 "58", add label define agelbl 59 "59", add label define agelbl 60 "60", add label define agelbl 61 "61", add label define agelbl 62 "62", add label define agelbl 63 "63", add label define agelbl 64 "64", add label define agelbl 65 "65", add label define agelbl 66 "66", add label define agelbl 67 "67", add label define agelbl 68 "68", add label define agelbl 69 "69", add label define agelbl 70 "70", add label define agelbl 71 "71", add label define agelbl 72 "72", add label define agelbl 73 "73", add label define agelbl 74 "74", add label define agelbl 75 "75", add label define agelbl 76 "76", add label define agelbl 77 "77", add label define agelbl 78 "78", add label define agelbl 79 "79", add label define agelbl 80 "80", add label define agelbl 81 "81", add label define agelbl 82 "82", add label define agelbl 83 "83", add label define agelbl 84 "84", add label define agelbl 85 "85", add label define agelbl 86 "86", add label define agelbl 87 "87", add label define agelbl 88 "88", add label define agelbl 89 "89", add label define agelbl 90 "90 (90+, 1988-2002)", add label define agelbl 91 "91", add label define agelbl 92 "92", add label define agelbl 93 "93", add label define agelbl 94 "94", add label define agelbl 95 "95", add label define agelbl 96 "96", add label define agelbl 97 "97", add label define agelbl 98 "98", add label define agelbl 99 "99+", add label values age agelbl label define sexlbl 1 "Male" label define sexlbl 2 "Female", add label values sex sexlbl label define racelbl 100 "White", add label define racelbl 200 "Black/Negro", add label define racelbl 300 "American Indian/Aleut/Eskimo", add label define racelbl 650 "Asian or Pacific Islander", add label define racelbl 651 "Asian only", add label define racelbl 652 "Hawaiian/Pacific Islander only", add label define racelbl 700 "Other (single) race, n.e.c.", add label define racelbl 801 "White-Black", add label define racelbl 802 "White-American Indian", add label define racelbl 803 "White-Asian", add label define racelbl 804 "White-Hawaiian/Pacific Islander", add label define racelbl 805 "Black-American Indian", add label define racelbl 806 "Black-Asian", add label define racelbl 807 "Black-Hawaiian/Pacific Islander", add label define racelbl 808 "American Indian-Asian", add label define racelbl 809 "Asian-Hawaiian/Pacific Islander", add label define racelbl 810 "White-Black-American Indian", add label define racelbl 811 "White-Black-Asian", add label define racelbl 812 "White-American Indian-Asian", add label define racelbl 813 "White-Asian-Hawaiian/Pacific Islander", add label define racelbl 814 "White-Black-American Indian-Asian", add label define racelbl 820 "Two or three races, unspecified", add label define racelbl 830 "Four or five races, unspecified", add label values race racelbl label define marstlbl 1 "Married, spouse present" label define marstlbl 2 "Married, spouse absent", add label define marstlbl 3 "Separated", add label define marstlbl 4 "Divorced", add label define marstlbl 5 "Widowed", add label define marstlbl 6 "Never married/single", add label define marstlbl 9 "Unknown", add label values marst marstlbl label define agemarrlbl 00 "NIU" label define agemarrlbl 14 "14 years old", add label define agemarrlbl 15 "15 years old", add label define agemarrlbl 16 "16 years old", add label define agemarrlbl 17 "17 years old", add label define agemarrlbl 18 "18 years old", add label define agemarrlbl 19 "19 years old", add label define agemarrlbl 20 "20 years old", add label define agemarrlbl 21 "21 years old", add label define agemarrlbl 22 "22 years old", add label define agemarrlbl 23 "23 years old", add label define agemarrlbl 24 "24 years old", add label define agemarrlbl 25 "25 years old", add label define agemarrlbl 26 "26 years old", add label define agemarrlbl 27 "27 years old", add label define agemarrlbl 28 "28 years old", add label define agemarrlbl 29 "29 years old", add label define agemarrlbl 30 "30 years old", add label define agemarrlbl 31 "31 years old", add label define agemarrlbl 32 "32 years old", add label define agemarrlbl 33 "33 years old", add label define agemarrlbl 34 "34 years old", add label define agemarrlbl 35 "35 years old", add label define agemarrlbl 36 "36 years old", add label define agemarrlbl 37 "37 years old", add label define agemarrlbl 38 "38 years old", add label define agemarrlbl 39 "39 years old", add label define agemarrlbl 40 "40 years old", add label define agemarrlbl 41 "41 years old", add label define agemarrlbl 42 "42 years old", add label define agemarrlbl 43 "43 years old", add label define agemarrlbl 44 "44 years old", add label define agemarrlbl 45 "45 years old", add label define agemarrlbl 46 "46 years old", add label define agemarrlbl 47 "47 years old", add label define agemarrlbl 48 "48 years old", add label define agemarrlbl 49 "49 years old", add label define agemarrlbl 50 "50 years old", add label define agemarrlbl 51 "51 years old", add label define agemarrlbl 52 "52 years old", add label define agemarrlbl 53 "53 years old", add label define agemarrlbl 54 "54 years old", add label define agemarrlbl 55 "55 years old", add label define agemarrlbl 56 "56 years old", add label define agemarrlbl 57 "57 years old", add label define agemarrlbl 58 "58 years old", add label define agemarrlbl 59 "59 years old", add label define agemarrlbl 60 "60 years old", add label define agemarrlbl 61 "61 years old", add label define agemarrlbl 62 "62 years old", add label define agemarrlbl 63 "63 years old", add label define agemarrlbl 64 "64 years old", add label define agemarrlbl 65 "65 years old", add label define agemarrlbl 66 "66 years old", add label define agemarrlbl 67 "67 years old", add label define agemarrlbl 68 "68 years old", add label define agemarrlbl 69 "69 years old", add label define agemarrlbl 70 "70 years old", add label define agemarrlbl 71 "71 years old", add label define agemarrlbl 72 "72 years old", add label define agemarrlbl 73 "73 years old", add label define agemarrlbl 74 "74 years old", add label define agemarrlbl 75 "75 years old", add label define agemarrlbl 76 "76 years old", add label define agemarrlbl 77 "77 years old", add label define agemarrlbl 78 "78 years old", add label define agemarrlbl 79 "79 years old", add label define agemarrlbl 80 "80 years old", add label define agemarrlbl 81 "81 years old", add label define agemarrlbl 82 "82 years old", add label define agemarrlbl 83 "83 years old", add label define agemarrlbl 84 "84 years old", add label define agemarrlbl 85 "85 years old", add label define agemarrlbl 86 "86 years old", add label define agemarrlbl 87 "87 years old", add label define agemarrlbl 88 "88 years old", add label values agemarr agemarrlbl