/************************************************************************************************/ /* Stata User File for H117 Data */ /* */ /* This file contains information and a sample Stata program to create a permanent */ /* Stata dataset for users who want to use Stata in processing the MEPS data provided */ /* in this PUF release. Stata (StataCorp) has the capability to produce */ /* appropriate standard errors for estimates from a survey with a complex sample */ /* design such as the Medical Expenditure Panel Survey (MEPS). */ /* The input file for creating a permanent Stata dataset is the ASCII data file */ /* (H117.DAT) supplied in this PUF release, which in turn can be extracted from the */ /* .EXE file. After entering the Stata interactive environment access the Stata DO-File */ /* editor by clicking on the appropriate icon in the command line at the top of the */ /* screen. Copy and paste the following Stata commands into the editor and save as a */ /* DO file. A DO file is a Stata program which may then be executed using the DO command. */ /* For example, if the DO file is named H117.DO and is located in the directory */ /* C:\MEPS\PROG, then the file may be executed by typing the following command into */ /* the Stata command line: */ /* do C:\MEPS\PROG\H117.DO */ /* The program below will output the Stata dataset H117.DTA */ /************************************************************************************************/ #delimit ; cd C:\MEPS\DATA; log using H117.log, replace; clear; * INPUT ALL VARIABLES; infix long DUID 1-5 int PID 6-8 str DUPERSID 9-16 byte PANEL 17-18 str FAMID13 19-20 str RULETR13 21-22 byte RUSIZE13 23-24 byte RUCLAS13 25-25 byte FAMSIZ13 26-27 byte REGION13 28-28 byte MSA13 29-29 int RNDREF13 30-32 byte RDRESP13 33-33 byte PROXY13 34-34 byte BEGRFD13 35-36 byte BEGRFM13 37-38 int BEGRFY13 39-42 byte ENDRFD13 43-44 byte ENDRFM13 45-46 int ENDRFY13 47-50 byte KEYNESS 51-51 byte INSCOP13 52-52 byte PSTAT13 53-54 str RURSLT13 55-56 byte RUENDD13 57-58 byte RUENDM13 59-59 int RUENDY13 60-63 byte AGE13X 64-65 byte DOBMM 66-67 int DOBYY 68-71 byte SEX 72-72 byte RACEBX 73-73 byte RACEAX 74-74 byte RACEWX 75-75 byte RACEX 76-76 byte RACETHNX 77-77 byte HISPANX 78-78 byte HISPCAT 79-80 byte MARRY13X 81-82 int SPOUID13 83-85 byte SPOUIN13 86-87 byte EDUCYR 88-89 byte HIDEG 90-91 byte FTSTD13X 92-93 byte ACTDTY13 94-95 byte HONRDC13 96-97 byte RFREL13X 98-99 byte RTHLTH13 100-101 byte MNHLTH13 102-103 byte IADLHP13 104-105 byte ADLHLP13 106-107 byte AIDHLP13 108-109 byte WLKLIM13 110-111 byte LFTDIF13 112-113 byte STPDIF13 114-115 byte WLKDIF13 116-117 byte MILDIF13 118-119 byte STNDIF13 120-121 byte BENDIF13 122-123 byte RCHDIF13 124-125 byte FNGRDF13 126-127 byte ACTLIM13 128-129 byte WRKLIM13 130-131 byte HSELIM13 132-133 byte SCHLIM13 134-135 byte UNABLE13 136-137 byte SOCLIM13 138-139 byte COGLIM13 140-141 byte EMPST13 142-143 double HRWAG13X 144-149 str HRWGRD13 150-151 byte HRWAY13 152-153 int HOUR13 154-156 byte HELD13X 157-158 byte OFFER13X 159-160 int NUMEMP13 161-163 byte SELFCM13 164-165 byte TRINW13X 166-166 byte MCARE13 167-167 byte MCARE13X 168-168 byte MCAID13 169-169 byte MCAID13X 170-170 byte OTPUBA13 171-171 byte OTPUBB13 172-172 byte STPRG13 173-173 byte PUB13X 174-174 byte PRIEU13 175-175 byte PRIDK13 176-176 byte PRING13 177-177 byte PRIOG13 178-178 byte PRIS13 179-179 byte PRIOUT13 180-180 byte PRIV13 181-181 byte HPRIEU13 182-182 byte HPRIDK13 183-183 byte HPRING13 184-184 byte HPRIOG13 185-185 byte HPRIS13 186-186 byte HPRIV13 187-187 byte INSRD13X 188-188 double WGTSP13 189-200 double WGTRU13 201-212 int VARSTR 213-216 byte VARPSU 217-217 using H117.dat; *DEFINE VARIABLE LABELS; label variable DUID "DWELLING UNIT ID"; label variable PID "PERSON NUMBER"; label variable DUPERSID "PERSON ID (DUID + PID)"; label variable PANEL "PANEL NUMBER"; label variable FAMID13 "FAMILY IDENTIFIER (STUDENT MERGED IN)"; label variable RULETR13 "RU LETTER"; label variable RUSIZE13 "RU SIZE"; label variable RUCLAS13 "RU FIELDED AS: STANDARD, NEW, STUDENT"; label variable FAMSIZ13 "RU SIZE INCLUDING STUDENTS"; label variable REGION13 "CENSUS REGION"; label variable MSA13 "MSA"; label variable RNDREF13 "REFERENCE PERSON"; label variable RDRESP13 "1ST RESPONDENT INDICATOR"; label variable PROXY13 "WAS RESPONDENT A PROXY"; label variable BEGRFD13 "REFERENCE PERIOD BEGIN DATE: DAY"; label variable BEGRFM13 "REFERENCE PERIOD BEGIN DATE: MONTH"; label variable BEGRFY13 "REFERENCE PERIOD BEGIN DATE: YEAR"; label variable ENDRFD13 "REFERENCE PERIOD END DATE: DAY"; label variable ENDRFM13 "REFERENCE PERIOD END DATE: MONTH"; label variable ENDRFY13 "REFERENCE PERIOD END DATE: YEAR"; label variable KEYNESS "PERSON KEY STATUS"; label variable INSCOP13 "INSCOPE"; label variable PSTAT13 "PERSON DISPOSITION STATUS"; label variable RURSLT13 "RU RESULT"; label variable RUENDD13 "DATE OF INTV (DATE STARTED: DAY)"; label variable RUENDM13 "DATE OF INTV (DATE STARTED: MONTH)"; label variable RUENDY13 "DATE OF INTV (DATE STARTED: YEAR)"; label variable AGE13X "AGE - (EDITED/IMPUTED)"; label variable DOBMM "DATE OF BIRTH: MONTH"; label variable DOBYY "DATE OF BIRTH: YEAR"; label variable SEX "SEX"; label variable RACEBX "BLACK AMONG RACES RPTD (EDITED/IMPUTED)"; label variable RACEAX "ASIAN AMONG RACES RPTD (EDITED/IMPUTED)"; label variable RACEWX "WHITE AMONG RACES RPTD (EDITED/IMPUTED)"; label variable RACEX "RACE - (EDITED/IMPUTED)"; label variable RACETHNX "RACE/ETHNICITY - (EDITED/IMPUTED)"; label variable HISPANX "HISPANIC ETHNICITY - (EDITED/IMPUTED)"; label variable HISPCAT "SPECIFIC HISPANIC ETHNICITY GROUP"; label variable MARRY13X "MARITAL STATUS - (EDITED/IMPUTED)"; label variable SPOUID13 "SPOUSE ID"; label variable SPOUIN13 "MARITAL STATUS WITH SPOUSE PRESENT"; label variable EDUCYR "YEARS OF EDUC WHEN FIRST ENTERED MEPS"; label variable HIDEG "HIGHEST DEGREE WHEN FIRST ENTERED MEPS"; label variable FTSTD13X "STUDENT STATUS AGES 17-23 (EDIT/IMPUTED)"; label variable ACTDTY13 "MILITARY FULL-TIME ACTIVE DUTY"; label variable HONRDC13 "HONORABLY DISCHARGED FROM ACTIVE DUTY"; label variable RFREL13X "RELATION TO REF PERS (EDITED/IMPUTED)"; label variable RTHLTH13 "PERCEIVED HEALTH STATUS"; label variable MNHLTH13 "PERCEIVED MENTAL HEALTH STATUS"; label variable IADLHP13 "IADL SCREENER"; label variable ADLHLP13 "ADL SCREENER"; label variable AIDHLP13 "USES ASSISTIVE DEVICES"; label variable WLKLIM13 "LIMITATION IN PHYSICAL FUNCTIONING"; label variable LFTDIF13 "DIFFICULTY LIFTING 10 POUNDS"; label variable STPDIF13 "DIFFICULTY WALKING UP 10 STEPS"; label variable WLKDIF13 "DIFFICULTY WALKING 3 BLOCKS"; label variable MILDIF13 "DIFFICULTY WALKING A MILE"; label variable STNDIF13 "DIFFICULTY STANDING 20 MINUTES"; label variable BENDIF13 "DIFFICULTY BENDING/STOOPING"; label variable RCHDIF13 "DIFFICULTY REACHING OVER HEAD"; label variable FNGRDF13 "DIFFICULTY USING FINGERS TO GRASP"; label variable ACTLIM13 "LIMITATION WORK/HOUSEWORK/SCHOOL"; label variable WRKLIM13 "WORK LIMITATION"; label variable HSELIM13 "HOUSEWORK LIMITATION"; label variable SCHLIM13 "SCHOOL LIMITATION"; label variable UNABLE13 "COMPLETELY UNABLE TO DO ACTIVITY"; label variable SOCLIM13 "SOCIAL LIMITATION"; label variable COGLIM13 "COGNITIVE LIMITATION"; label variable EMPST13 "EMPLOYMENT STATUS"; label variable HRWAG13X "HOURLY WAGE AT CURRENT MAIN JOB (EDITED)"; label variable HRWGRD13 "HOURLY WAGE ROUND FLAG"; label variable HRWAY13 "CALCULATION METHODS FOR HOURLY WAGE"; label variable HOUR13 "HOURS WORKED PER WEEK AT CMJ"; label variable HELD13X "HEALTH INSURANCE HELD FROM CMJ (ED)"; label variable OFFER13X "HEALTH INSURANCE OFFERED AT CMJ (ED)"; label variable NUMEMP13 "NUMBER OF EMPLOYEES AT LOCATION OF CMJ"; label variable SELFCM13 "SELF-EMPLOYED AT CURRENT MAIN JOB"; label variable TRINW13X "PID COV BY TRICARE/CHAMPVA AT INT-EDITED"; label variable MCARE13 "PID COV BY MEDICARE"; label variable MCARE13X "PID COV BY MEDICARE - EDITED"; label variable MCAID13 "PID COV BY MEDICAID OR SCHIP"; label variable MCAID13X "PID COV BY MEDICAID OR SCHIP - EDITED"; label variable OTPUBA13 "PID COV BY/PAYS OTH GOV MCAID/SCHIP HMO"; label variable OTPUBB13 "PID COV BY OTH PUB NOT MCAID/SCHIP HMO"; label variable STPRG13 "PID COV BY STATE SPECIFIC PROGRAM"; label variable PUB13X "PID COV BY PUBLIC INS - EDITED"; label variable PRIEU13 "PID COV BY PRIV EMPL/UNION PLAN"; label variable PRIDK13 "PID COV BY PRIV DK PLAN"; label variable PRING13 "PID COV BY NONGROUP PLAN"; label variable PRIOG13 "PID COV BY OTH GROUP PLAN"; label variable PRIS13 "PID COV BY SELF-EMP-1 INS"; label variable PRIOUT13 "PID COV BY HOLDER OUTSIDE RU"; label variable PRIV13 "PID COV BY PRIVATE INS"; label variable HPRIEU13 "PID IS HOLDER OF PRIV EMPL/UNION PLAN"; label variable HPRIDK13 "PID IS HOLDER OF PRIV DK PLAN"; label variable HPRING13 "PID IS HOLDER OF NONGROUP PLAN"; label variable HPRIOG13 "PID IS HOLDER OF OTH GROUP PLAN"; label variable HPRIS13 "PID IS HOLDER OF SELF-EMP-1 INS"; label variable HPRIV13 "PID IS HOLDER OF PRIV INS PLAN"; label variable INSRD13X "PID IS INSURED - EDITED"; label variable WGTSP13 "PERSON WEIGHT"; label variable WGTRU13 "FAMILY WEIGHT"; label variable VARSTR "VARIANCE ESTIMATION STRATUM"; label variable VARPSU "VARIANCE ESTIMATION PSU"; *DEFINE VALUE LABELS FOR REPORTS; label define H1170001X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES - ACTIVE DUTY" 2 "2 NO - NOT FULL-TIME ACTIVE DUTY" 3 "3 UNDER 16 - INAPPLICABLE" 4 "4 OVER 59 - INAPPLICABLE" ; label define H1170002X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H1170003X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H1170004X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" ; label define H1170005X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H1170006X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" ; label define H1170007X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 JANUARY" 10 "10 OCTOBER" 11 "11 NOVEMBER" 12 "12 DECEMBER" 2 "2 FEBRUARY" 3 "3 MARCH" 4 "4 APRIL" 5 "5 MAY" 6 "6 JUNE" 7 "7 JULY" 8 "8 AUGUST" 9 "9 SEPTEMBER" ; label define H1170008X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" ; label define H1170009X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 NO DIFFICULTY" 2 "2 SOME DIFFICULTY" 3 "3 A LOT OF DIFFICULTY" 4 "4 UNABLE TO DO" ; label define H1170010X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H1170011X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 JANUARY" 10 "10 OCTOBER" 11 "11 NOVEMBER" 12 "12 DECEMBER" 2 "2 FEBRUARY" 3 "3 MARCH" 4 "4 APRIL" 5 "5 MAY" 6 "6 JUNE" 7 "7 JULY" 8 "8 AUGUST" 9 "9 SEPTEMBER" ; label define H1170012X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" ; label define H1170013X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 0 "0 NEVER ATTENDED SCH" 12 "12 GRADE 12" 13 "13 1 YEAR COLLEGE" 14 "14 2 YEARS COLLEGE" 15 "15 3 YEARS COLLEGE" 16 "16 4 YEARS COLLEGE" 17 "17 5+ YEARS COLLEGE" ; label define H1170014X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 1 "1 CURRENTLY EMPLOYED" 2 "2 HAS JOB TO RETURN TO" 3 "3 EMPLOYED DURING REFERENCE PERIOD" 4 "4 NOT EMPLOYED WITH NO JOB TO RETURN TO" ; label define H1170015X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" ; label define H1170016X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 JANUARY" 10 "10 OCTOBER" 11 "11 NOVEMBER" 12 "12 DECEMBER" 2 "2 FEBRUARY" 3 "3 MARCH" 4 "4 APRIL" 5 "5 MAY" 6 "6 JUNE" 7 "7 JULY" 8 "8 AUGUST" 9 "9 SEPTEMBER" ; label define H1170017X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 2008 "2008 YEAR" 2009 "2009 YEAR" ; label define H1170018X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 PERSON" 10 "10 PERSONS" 11 "11 PERSONS" 12 "12 PERSONS" 13 "13 PERSONS" 14 "14 PERSONS" 15 "15 PERSONS" 16 "16 PERSONS" 17 "17 PERSONS" 18 "18 PERSONS" 2 "2 PERSONS" 3 "3 PERSONS" 4 "4 PERSONS" 5 "5 PERSONS" 6 "6 PERSONS" 7 "7 PERSONS" 8 "8 PERSONS" 9 "9 PERSONS" ; label define H1170019X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 NO DIFFICULTY" 2 "2 SOME DIFFICULTY" 3 "3 A LOT OF DIFFICULTY" 4 "4 UNABLE TO DO" ; label define H1170020X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 FULL-TIME" 2 "2 PART-TIME" 3 "3 NOT A STUDENT" ; label define H1170021X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H1170022X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 NO DEGREE" 2 "2 GED" 3 "3 HIGH SCHOOL DIPLOMA" 4 "4 BACHELOR'S DEGREE" 5 "5 MASTER'S DEGREE" 6 "6 DOCTORATE DEGREE" 7 "7 OTHER DEGREE" 8 "8 UNDER 16 - INAPPLICABLE" ; label define H1170023X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 HISPANIC" 2 "2 NOT HISPANIC" ; label define H1170024X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 PUERTO RICAN" 2 "2 CUBAN/CUBAN AMERICAN" 3 "3 DOMINICAN" 4 "4 MEXICAN/MEXICAN AMERICAN" 5 "5 CENTRAL OR SOUTH AMERICAN" 6 "6 NON-HISPANIC" 91 "91 OTHER LATIN AMERICAN" 92 "92 OTHER HISPANIC/LATINO" ; label define H1170025X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES - HONORABLY DISCHARGED" 2 "2 NO - NOT HONORABLY DISCHARGED" 3 "3 16 OR YOUNGER - INAPPLICABLE" 4 "4 NOW ACTIVE DUTY" ; label define H1170026X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" ; label define H1170027X -1 "-1 INAPPLICABLE" 1 "1 YES" 2 "2 NO" ; label define H1170028X -1 "-1 INAPPLICABLE" 1 "1 YES" 2 "2 NO" ; label define H1170029X -1 "-1 INAPPLICABLE" 1 "1 YES" 2 "2 NO" ; label define H1170030X -1 "-1 INAPPLICABLE" 1 "1 YES" 2 "2 NO" ; label define H1170031X -1 "-1 INAPPLICABLE" 1 "1 YES" 2 "2 NO" ; label define H1170032X -1 "-1 INAPPLICABLE" 1 "1 YES" 2 "2 NO" ; label define H1170033X -1 "-1 INAPPLICABLE" -10 "-10 HOURLY WAGE >= $67.31" -9 "-9 NOT ASCERTAINED" ; label define H1170034X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 1 "1 HOURLY WAGE" 2 "2 MEDIAN" 3 "3 SALARY" 4 "4 BY DAY" 5 "5 PIECEWORK" 6 "6 COMMISSION" 7 "7 BONUS" ; label define H1170035X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H1170036X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H1170037X -1 "-1 INAPPLICABLE" 1 "1 IN-SCOPE" 2 "2 OUT-OF-SCOPE" ; label define H1170038X -1 "-1 INAPPLICABLE" 1 "1 YES" 2 "2 NO" ; label define H1170039X -1 "-1 INAPPLICABLE" 1 "1 KEY" 2 "2 NOT KEY" ; label define H1170040X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 NO DIFFICULTY" 2 "2 SOME DIFFICULTY" 3 "3 A LOT OF DIFFICULTY" 4 "4 UNABLE TO DO" ; label define H1170041X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 MARRIED" 10 "10 SEPARATED IN ROUND" 2 "2 WIDOWED" 3 "3 DIVORCED" 4 "4 SEPARATED" 5 "5 NEVER MARRIED" 6 "6 UNDER 16 INAPPLICABLE" 7 "7 MARRIED IN ROUND" 8 "8 WIDOWED IN ROUND" 9 "9 DIVORCED IN ROUND" ; label define H1170042X -1 "-1 INAPPLICABLE" 1 "1 YES" 2 "2 NO" ; label define H1170043X -1 "-1 INAPPLICABLE" 1 "1 YES" 2 "2 NO" ; label define H1170044X -1 "-1 INAPPLICABLE" 1 "1 YES" 2 "2 NO" ; label define H1170045X -1 "-1 INAPPLICABLE" 1 "1 YES" 2 "2 NO" ; label define H1170046X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 NO DIFFICULTY" 2 "2 SOME DIFFICULTY" 3 "3 A LOT OF DIFFICULTY" 4 "4 UNABLE TO DO" ; label define H1170047X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 EXCELLENT" 2 "2 VERY GOOD" 3 "3 GOOD" 4 "4 FAIR" 5 "5 POOR" ; label define H1170048X -1 "-1 INAPPLICABLE" 1 "1 MSA" 2 "2 NON-MSA" ; label define H1170049X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" ; label define H1170050X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H1170051X -1 "-1 INAPPLICABLE" 1 "1 YES" 2 "2 NO" ; label define H1170052X -1 "-1 INAPPLICABLE" 1 "1 YES" 2 "2 NO" ; label define H1170053X 13 "13 PANEL 13 RD 3" 14 "14 PANEL 14 RD 1" ; label define H1170054X -1 "-1 INAPPLICABLE" 1 "1 YES" 2 "2 NO" ; label define H1170055X -1 "-1 INAPPLICABLE" 1 "1 YES" 2 "2 NO" ; label define H1170056X -1 "-1 INAPPLICABLE" 1 "1 YES" 2 "2 NO" ; label define H1170057X -1 "-1 INAPPLICABLE" 1 "1 YES" 2 "2 NO" ; label define H1170058X -1 "-1 INAPPLICABLE" 1 "1 YES" 2 "2 NO" ; label define H1170059X -1 "-1 INAPPLICABLE" 1 "1 YES" 2 "2 NO" ; label define H1170060X -1 "-1 INAPPLICABLE" 1 "1 YES" 2 "2 NO" ; label define H1170061X -1 "-1 NON-RESPONSE" 1 "1 RESPONDENT IS RU MEMBER" 2 "2 RESPONDENT IS A PROXY" ; label define H1170062X -1 "-1 NOT FIELDED/NON-RESPONSE RU" 0 "0 INCORRECTLY LISTED IN RU AT NHIS-R1 ONLY" 11 "11 PERSON IN HOUSEHLD, NOT FT ACTIVE MIL" 12 "12 IN HOUSEHLD, FT MIL DUTY-OUT-SCOPE" 13 "13 FT STUD LIVING AWAY FROM HOME" 14 "14 IN ORIG HH, FT ACTIVE DUTY-INSCOPE" 21 "21 INSTITUTIONALIZED WHOLE- R3 ONLY" 22 "22 LEAVE INSTITUTION - R3 ONLY" 23 "23 LEAVES INSTITUTION & DIES - R3 ONLY" 24 "24 DIES IN INST DURING RD - R3 ONLY" 31 "31 DECEASED" 32 "32 INSTITUTIONALIZED IN HEALTH CARE FAC" 33 "33 INSTITUTIONALIZED NON-HEALTH CARE FAC" 34 "34 MOVED OUTSIDE U.S., NOT AS STUDENT" 35 "35 MOVED, FT ACTIVE DUTY" 36 "36 INSTITUTIONALIZED (TYPE UNKNOWN)" 41 "41 MOVED WITHIN U.S." 42 "42 PERSON WHO JOINED RU" 43 "43 REASON UNK OR MOVED TO UNK LOCATION" 44 "44 JOINS ANOTHER RU, & IS INSCOPE" 51 "51 NEWBORN IN REF PERIOD" 61 "61 DECEASED PRIOR TO REF PERIOD-R3/1" 62 "62 INSTITUT PRIOR TO REF PER-R3/1" 63 "63 LEFT U.S. PRIOR TO REF PER-R3/1" 64 "64 FT MIL, MIL FAC MOVE PRIOR REF PER-R3/1" 71 "71 LIVING AWAY GRADES 1-12 NONKEY" 72 "72 INELIG NON-KEY/RESIDENCY SCHL YR ONLY" 73 "73 NONKEY, NOT FT MIL, MOVED W/OUT KEY" 74 "74 MOVED AS FT MIL, NOT TO A, W/OUT KEY" 81 "81 MOVED, FT STUD, NO RESP, DATA IMPUTED" ; label define H1170063X -1 "-1 INAPPLICABLE" 1 "1 YES" 2 "2 NO" ; label define H1170064X -1 "-1 INAPPLICABLE" 1 "1 ASIAN-NO OTHER RACE REPORTED" 2 "2 ASIAN-OTHER RACE(S) REPORTED" 3 "3 ALL OTHER RACE ASSIGNMENTS" ; label define H1170065X -1 "-1 INAPPLICABLE" 1 "1 BLACK-NO OTHER RACE REPORTED" 2 "2 BLACK-OTHER RACE(S) REPORTED" 3 "3 ALL OTHER RACE ASSIGNMENTS" ; label define H1170066X -1 "-1 INAPPLICABLE" 1 "1 PERSON IS HISPANIC" 2 "2 PERSON IS BLACK-NO OTH RACE/NOT HISPANIC" 3 "3 PERSON IS ASIAN-NO OTH RACE/NOT HISPANIC" 4 "4 OTHER RACE/NOT HISPANIC" ; label define H1170067X -1 "-1 INAPPLICABLE" 1 "1 WHITE-NO OTHER RACE REPORTED" 2 "2 WHITE-OTHER RACE(S) REPORTED" 3 "3 ALL OTHER RACE ASSIGNMENTS" ; label define H1170068X -1 "-1 INAPPLICABLE" 1 "1 WHITE - NO OTHER RACE REPORTED" 2 "2 BLACK - NO OTHER RACE REPORTED" 3 "3 AMER INDIAN/ALASKA NATIVE - NO OTH RACE" 4 "4 ASIAN - NO OTHER RACE REPORTED" 5 "5 NATIVE HAWAIIAN/PACIFIC ISLANDER-NO OTHR" 6 "6 MULTIPLE RACES REPORTED" ; label define H1170069X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 NO DIFFICULTY" 2 "2 SOME DIFFICULTY" 3 "3 A LOT OF DIFFICULTY" 4 "4 UNABLE TO DO" ; label define H1170070X -1 "-1 INAPPLICABLE" 0 "0 NON-RESPONSE" 1 "1 YES, FIRST RESPONDENT" 2 "2 NO, NOT FIRST RESPONDENT" 3 "3 NOT DETERMINED" ; label define H1170071X -1 "-1 INAPPLICABLE" 1 "1 NORTHEAST" 2 "2 MIDWEST" 3 "3 SOUTH" 4 "4 WEST" ; label define H1170072X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 0 "0 SELF" 1 "1 MOTHER" 10 "10 FATHER-IN-LAW" 11 "11 SISTER-IN-LAW" 12 "12 BROTHER-IN-LAW" 13 "13 DAUGHTER-IN-LAW" 14 "14 SON-IN-LAW" 15 "15 STEPMOTHER" 16 "16 STEPFATHER" 17 "17 STEPDAUGHTER" 18 "18 STEPSON" 19 "19 GRANDMOTHER" 2 "2 FATHER" 20 "20 GRANDFATHER" 21 "21 AUNT" 22 "22 UNCLE" 23 "23 NIECE" 24 "24 NEPHEW" 25 "25 COUSIN" 26 "26 GRANDSON" 27 "27 GRANDDAUGHTER" 28 "28 FEMALE PARTNER" 29 "29 MALE PARTNER" 3 "3 SISTER/STEP/HALF" 30 "30 MOTHER'S PARTNER" 31 "31 FATHER'S PARTNER" 32 "32 DAUGHTER OF PARTNER" 33 "33 SON OF PARTNER" 35 "35 GREAT GRANDMOTHER" 36 "36 GREAT GRANDFATHER" 37 "37 GREAT GRANDDAUGHTER" 38 "38 GREAT GRANDSON" 39 "39 GREAT AUNT" 4 "4 BROTHER/STEP/HALF" 40 "40 GREAT UNCLE" 41 "41 GREAT NIECE" 42 "42 GREAT NEPHEW" 43 "43 FOSTER MOTHER" 44 "44 FOSTER FATHER" 45 "45 FOSTER DAUGHTER" 46 "46 FOSTER SON" 47 "47 FOSTER SISTER" 48 "48 FOSTER BROTHER" 5 "5 DAUGHTER/ADOPTED DAUGHTER" 6 "6 SON/ADOPTED SON" 7 "7 WIFE/SPOUSE" 8 "8 HUSBAND/SPOUSE" 9 "9 MOTHER-IN-LAW" 91 "91 OTHER RELATED, SPECIFY" 99 "99 NOT RELATED" ; label define H1170073X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 EXCELLENT" 2 "2 VERY GOOD" 3 "3 GOOD" 4 "4 FAIR" 5 "5 POOR" ; label define H1170074X -1 "-1 INAPPLICABLE" 1 "1 STANDARD RU" 2 "2 NEW RU" 3 "3 STUDENT RU" ; label define H1170075X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" ; label define H1170076X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 JANUARY" 10 "10 OCTOBER" 11 "11 NOVEMBER" 12 "12 DECEMBER" 2 "2 FEBRUARY" 3 "3 MARCH" 4 "4 APRIL" 5 "5 MAY" 6 "6 JUNE" 7 "7 JULY" 8 "8 AUGUST" 9 "9 SEPTEMBER" ; label define H1170077X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 2009 "2009 YEAR" ; label define H1170078X -1 "-1 INAPPLICABLE" 1 "1 PERSON IN RU" 10 "10 PERSONS IN RU" 11 "11 PERSONS IN RU" 12 "12 PERSONS IN RU" 13 "13 PERSONS IN RU" 14 "14 PERSONS IN RU" 15 "15 PERSONS IN RU" 16 "16 PERSONS IN RU" 17 "17 PERSONS IN RU" 18 "18 PERSONS IN RU" 2 "2 PERSONS IN RU" 3 "3 PERSONS IN RU" 4 "4 PERSONS IN RU" 5 "5 PERSONS IN RU" 6 "6 PERSONS IN RU" 7 "7 PERSONS IN RU" 8 "8 PERSONS IN RU" 9 "9 PERSONS IN RU" ; label define H1170079X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H1170080X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 1 "1 SELF-EMPLOYED" 2 "2 WORKS FOR SOMEONE ELSE" ; label define H1170081X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 MALE" 2 "2 FEMALE" ; label define H1170082X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H1170083X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 995 "995 NO SPOUSE IN HOUSE" 996 "996 MARITAL STATUS UNKNOWN" 997 "997 LESS THAN 16 YRS OLD" ; label define H1170084X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 SPOUSE IN THE HOUSE" 2 "2 NOT MARRIED/NO SPOUSE" 3 "3 UNDER 16 INAPPLICABLE" ; label define H1170085X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 NO DIFFICULTY" 2 "2 SOME DIFFICULTY" 3 "3 A LOT OF DIFFICULTY" 4 "4 UNABLE TO DO" ; label define H1170086X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 NO DIFFICULTY" 2 "2 SOME DIFFICULTY" 3 "3 A LOT OF DIFFICULTY" 4 "4 COMPLETELY UNABLE TO DO IT" 5 "5 COMPLETELY UNABLE TO WALK" ; label define H1170087X -1 "-1 INAPPLICABLE" 1 "1 YES" 2 "2 NO" ; label define H1170088X -1 "-1 INAPPLICABLE" 1 "1 YES" 2 "2 NO" ; label define H1170089X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H1170090X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 NO DIFFICULTY" 2 "2 SOME DIFFICULTY" 3 "3 A LOT OF DIFFICULTY" 4 "4 UNABLE TO DO" ; label define H1170091X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H1170092X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; * ASSOCIATE VARIABLES WITH VALUE LABEL DEFINITIONS; label value ACTDTY13 H1170001X; label value ACTLIM13 H1170002X; label value ADLHLP13 H1170003X; label value AGE13X H1170004X; label value AIDHLP13 H1170005X; label value BEGRFD13 H1170006X; label value BEGRFM13 H1170007X; label value BEGRFY13 H1170008X; label value BENDIF13 H1170009X; label value COGLIM13 H1170010X; label value DOBMM H1170011X; label value DOBYY H1170012X; label value EDUCYR H1170013X; label value EMPST13 H1170014X; label value ENDRFD13 H1170015X; label value ENDRFM13 H1170016X; label value ENDRFY13 H1170017X; label value FAMSIZ13 H1170018X; label value FNGRDF13 H1170019X; label value FTSTD13X H1170020X; label value HELD13X H1170021X; label value HIDEG H1170022X; label value HISPANX H1170023X; label value HISPCAT H1170024X; label value HONRDC13 H1170025X; label value HOUR13 H1170026X; label value HPRIDK13 H1170027X; label value HPRIEU13 H1170028X; label value HPRING13 H1170029X; label value HPRIOG13 H1170030X; label value HPRIS13 H1170031X; label value HPRIV13 H1170032X; label value HRWAG13X H1170033X; label value HRWAY13 H1170034X; label value HSELIM13 H1170035X; label value IADLHP13 H1170036X; label value INSCOP13 H1170037X; label value INSRD13X H1170038X; label value KEYNESS H1170039X; label value LFTDIF13 H1170040X; label value MARRY13X H1170041X; label value MCAID13 H1170042X; label value MCAID13X H1170043X; label value MCARE13 H1170044X; label value MCARE13X H1170045X; label value MILDIF13 H1170046X; label value MNHLTH13 H1170047X; label value MSA13 H1170048X; label value NUMEMP13 H1170049X; label value OFFER13X H1170050X; label value OTPUBA13 H1170051X; label value OTPUBB13 H1170052X; label value PANEL H1170053X; label value PRIDK13 H1170054X; label value PRIEU13 H1170055X; label value PRING13 H1170056X; label value PRIOG13 H1170057X; label value PRIOUT13 H1170058X; label value PRIS13 H1170059X; label value PRIV13 H1170060X; label value PROXY13 H1170061X; label value PSTAT13 H1170062X; label value PUB13X H1170063X; label value RACEAX H1170064X; label value RACEBX H1170065X; label value RACETHNX H1170066X; label value RACEWX H1170067X; label value RACEX H1170068X; label value RCHDIF13 H1170069X; label value RDRESP13 H1170070X; label value REGION13 H1170071X; label value RFREL13X H1170072X; label value RTHLTH13 H1170073X; label value RUCLAS13 H1170074X; label value RUENDD13 H1170075X; label value RUENDM13 H1170076X; label value RUENDY13 H1170077X; label value RUSIZE13 H1170078X; label value SCHLIM13 H1170079X; label value SELFCM13 H1170080X; label value SEX H1170081X; label value SOCLIM13 H1170082X; label value SPOUID13 H1170083X; label value SPOUIN13 H1170084X; label value STNDIF13 H1170085X; label value STPDIF13 H1170086X; label value STPRG13 H1170087X; label value TRINW13X H1170088X; label value UNABLE13 H1170089X; label value WLKDIF13 H1170090X; label value WLKLIM13 H1170091X; label value WRKLIM13 H1170092X; *DISPLAY A DESCRIPTION OF STATA FILE; describe; *LIST FIRST 20 OBSERVATIONS IN THE FILE; list in 1/20; save H117, replace; #delimit cr * data file is stored in H117.dta * log file is stored in H117.log log close /************************************************************************************************ NOTES: 1. This program has been tested on Stata Version 10 (for Windows). 2. This program will create a permanent Stata dataset. All additional analyses can be run using this dataset. In addition to the dataset, this program creates a log file named H117.LOG and a data file named H117.DTA. If these files (H117.DTA and H117.LOG) already exist in the working directory, they will be replaced when this program is executed. 3. If the program ends prematurely, the log file will remain open. Before running this program again, the user should enter the following Stata command: log close 4. The cd command assigns C:\MEPS\DATA as the working directory and location of the input ASCII and output .DTA and .LOG files and can be modified by the user as necessary. 5. Stata commands end with a carriage return by default. The command #delimit ; temporarily changes the command ending delimiter from a carriage return to a semicolon. 6. The infix command assumes that the input variables are numeric unless the variable name is prefaced by str. For example, DUPERSID is the a string (or character) variable. ************************************************************************************************/