/************************************************************************************************/ /* Stata User File for H109 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 */ /* (H109.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 H109.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\H109.DO */ /* The program below will output the Stata dataset H109.DTA */ /************************************************************************************************/ #delimit ; cd C:\MEPS\DATA; log using H109.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 H109.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 H1090001X -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 H1090002X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H1090003X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H1090004X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" ; label define H1090005X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H1090006X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" ; label define H1090007X -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 H1090008X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" ; label define H1090009X -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 H1090010X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H1090011X -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 H1090012X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" ; label define H1090013X -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 H1090014X -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 H1090015X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" ; label define H1090016X -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 H1090017X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 2007 "2007 YEAR" 2008 "2008 YEAR" ; label define H1090018X -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 H1090019X -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 H1090020X -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 H1090021X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H1090022X -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 H1090023X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 HISPANIC" 2 "2 NOT HISPANIC" ; label define H1090024X -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 H1090025X -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 H1090026X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" ; label define H1090027X -1 "-1 INAPPLICABLE" 1 "1 YES" 2 "2 NO" ; label define H1090028X -1 "-1 INAPPLICABLE" 1 "1 YES" 2 "2 NO" ; label define H1090029X -1 "-1 INAPPLICABLE" 1 "1 YES" 2 "2 NO" ; label define H1090030X -1 "-1 INAPPLICABLE" 1 "1 YES" 2 "2 NO" ; label define H1090031X -1 "-1 INAPPLICABLE" 1 "1 YES" 2 "2 NO" ; label define H1090032X -1 "-1 INAPPLICABLE" 1 "1 YES" 2 "2 NO" ; label define H1090033X -1 "-1 INAPPLICABLE" -10 "-10 HOURLY WAGE >= $65.97" -9 "-9 NOT ASCERTAINED" ; label define H1090034X -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 H1090035X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H1090036X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H1090037X -1 "-1 INAPPLICABLE" 1 "1 IN-SCOPE" 2 "2 OUT-OF-SCOPE" ; label define H1090038X -1 "-1 INAPPLICABLE" 1 "1 YES" 2 "2 NO" ; label define H1090039X -1 "-1 INAPPLICABLE" 1 "1 KEY" 2 "2 NOT KEY" ; label define H1090040X -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 H1090041X -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 H1090042X -1 "-1 INAPPLICABLE" 1 "1 YES" 2 "2 NO" ; label define H1090043X -1 "-1 INAPPLICABLE" 1 "1 YES" 2 "2 NO" ; label define H1090044X -1 "-1 INAPPLICABLE" 1 "1 YES" 2 "2 NO" ; label define H1090045X -1 "-1 INAPPLICABLE" 1 "1 YES" 2 "2 NO" ; label define H1090046X -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 H1090047X -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 H1090048X -1 "-1 INAPPLICABLE" 1 "1 MSA" 2 "2 NON-MSA" ; label define H1090049X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" ; label define H1090050X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H1090051X -1 "-1 INAPPLICABLE" 1 "1 YES" 2 "2 NO" ; label define H1090052X -1 "-1 INAPPLICABLE" 1 "1 YES" 2 "2 NO" ; label define H1090053X 12 "12 PANEL 12 RD 3" 13 "13 PANEL 13 RD 1" ; label define H1090054X -1 "-1 INAPPLICABLE" 1 "1 YES" 2 "2 NO" ; label define H1090055X -1 "-1 INAPPLICABLE" 1 "1 YES" 2 "2 NO" ; label define H1090056X -1 "-1 INAPPLICABLE" 1 "1 YES" 2 "2 NO" ; label define H1090057X -1 "-1 INAPPLICABLE" 1 "1 YES" 2 "2 NO" ; label define H1090058X -1 "-1 INAPPLICABLE" 1 "1 YES" 2 "2 NO" ; label define H1090059X -1 "-1 INAPPLICABLE" 1 "1 YES" 2 "2 NO" ; label define H1090060X -1 "-1 INAPPLICABLE" 1 "1 YES" 2 "2 NO" ; label define H1090061X -1 "-1 NON-RESPONSE" 1 "1 RESPONDENT IS RU MEMBER" 2 "2 RESPONDENT IS A PROXY" ; label define H1090062X -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 H1090063X -1 "-1 INAPPLICABLE" 1 "1 YES" 2 "2 NO" ; label define H1090064X -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 H1090065X -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 H1090066X -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 H1090067X -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 H1090068X -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 H1090069X -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 H1090070X -1 "-1 INAPPLICABLE" 0 "0 NON-RESPONSE" 1 "1 YES, FIRST RESPONDENT" 2 "2 NO, NOT FIRST RESPONDENT" 3 "3 NOT DETERMINED" ; label define H1090071X -1 "-1 INAPPLICABLE" 1 "1 NORTHEAST" 2 "2 MIDWEST" 3 "3 SOUTH" 4 "4 WEST" ; label define H1090072X -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 H1090073X -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 H1090074X -1 "-1 INAPPLICABLE" 1 "1 STANDARD RU" 2 "2 NEW RU" 3 "3 STUDENT RU" ; label define H1090075X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" ; label define H1090076X -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 H1090077X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 2008 "2008 YEAR" ; label define H1090078X -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 H1090079X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H1090080X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 1 "1 SELF-EMPLOYED" 2 "2 WORKS FOR SOMEONE ELSE" ; label define H1090081X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 MALE" 2 "2 FEMALE" ; label define H1090082X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H1090083X -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 H1090084X -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 H1090085X -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 H1090086X -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 H1090087X -1 "-1 INAPPLICABLE" 1 "1 YES" 2 "2 NO" ; label define H1090088X -1 "-1 INAPPLICABLE" 1 "1 YES" 2 "2 NO" ; label define H1090089X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H1090090X -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 H1090091X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H1090092X -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 H1090001X; label value ACTLIM13 H1090002X; label value ADLHLP13 H1090003X; label value AGE13X H1090004X; label value AIDHLP13 H1090005X; label value BEGRFD13 H1090006X; label value BEGRFM13 H1090007X; label value BEGRFY13 H1090008X; label value BENDIF13 H1090009X; label value COGLIM13 H1090010X; label value DOBMM H1090011X; label value DOBYY H1090012X; label value EDUCYR H1090013X; label value EMPST13 H1090014X; label value ENDRFD13 H1090015X; label value ENDRFM13 H1090016X; label value ENDRFY13 H1090017X; label value FAMSIZ13 H1090018X; label value FNGRDF13 H1090019X; label value FTSTD13X H1090020X; label value HELD13X H1090021X; label value HIDEG H1090022X; label value HISPANX H1090023X; label value HISPCAT H1090024X; label value HONRDC13 H1090025X; label value HOUR13 H1090026X; label value HPRIDK13 H1090027X; label value HPRIEU13 H1090028X; label value HPRING13 H1090029X; label value HPRIOG13 H1090030X; label value HPRIS13 H1090031X; label value HPRIV13 H1090032X; label value HRWAG13X H1090033X; label value HRWAY13 H1090034X; label value HSELIM13 H1090035X; label value IADLHP13 H1090036X; label value INSCOP13 H1090037X; label value INSRD13X H1090038X; label value KEYNESS H1090039X; label value LFTDIF13 H1090040X; label value MARRY13X H1090041X; label value MCAID13 H1090042X; label value MCAID13X H1090043X; label value MCARE13 H1090044X; label value MCARE13X H1090045X; label value MILDIF13 H1090046X; label value MNHLTH13 H1090047X; label value MSA13 H1090048X; label value NUMEMP13 H1090049X; label value OFFER13X H1090050X; label value OTPUBA13 H1090051X; label value OTPUBB13 H1090052X; label value PANEL H1090053X; label value PRIDK13 H1090054X; label value PRIEU13 H1090055X; label value PRING13 H1090056X; label value PRIOG13 H1090057X; label value PRIOUT13 H1090058X; label value PRIS13 H1090059X; label value PRIV13 H1090060X; label value PROXY13 H1090061X; label value PSTAT13 H1090062X; label value PUB13X H1090063X; label value RACEAX H1090064X; label value RACEBX H1090065X; label value RACETHNX H1090066X; label value RACEWX H1090067X; label value RACEX H1090068X; label value RCHDIF13 H1090069X; label value RDRESP13 H1090070X; label value REGION13 H1090071X; label value RFREL13X H1090072X; label value RTHLTH13 H1090073X; label value RUCLAS13 H1090074X; label value RUENDD13 H1090075X; label value RUENDM13 H1090076X; label value RUENDY13 H1090077X; label value RUSIZE13 H1090078X; label value SCHLIM13 H1090079X; label value SELFCM13 H1090080X; label value SEX H1090081X; label value SOCLIM13 H1090082X; label value SPOUID13 H1090083X; label value SPOUIN13 H1090084X; label value STNDIF13 H1090085X; label value STPDIF13 H1090086X; label value STPRG13 H1090087X; label value TRINW13X H1090088X; label value UNABLE13 H1090089X; label value WLKDIF13 H1090090X; label value WLKLIM13 H1090091X; label value WRKLIM13 H1090092X; *DISPLAY A DESCRIPTION OF STATA FILE; describe; *LIST FIRST 20 OBSERVATIONS IN THE FILE; list in 1/20; save H109, replace; #delimit cr * data file is stored in H109.dta * log file is stored in H109.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 H109.LOG and a data file named H109.DTA. If these files (H109.DTA and H109.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. ************************************************************************************************/