/************************************************************************************************/ /* Stata User File for H161 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 */ /* (H161.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 H161.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\H161.DO */ /* The program below will output the Stata dataset H161.DTA */ /************************************************************************************************/ #delimit ; cd C:\MEPS\DATA; log using H161.log, replace; clear; * INPUT ALL VARIABLES; infix str EPCPIDX 1-28 str DUPERSID 29-36 str PHLDRIDX 37-44 str ESTBIDX 45-55 str EPRSIDX 56-75 byte PANEL 76-77 byte RN 78-78 str JOBSIDX 79-89 byte JOBSINFR 90-91 int JOBSFILE 92-94 byte PITFLG 95-95 byte FYFLG 96-96 byte CMJINS 97-98 byte EMPLSTAT 99-100 byte PHOLDER 101-101 byte DEPNDNT 102-102 byte EVALCOVR 103-104 byte STATUS1 105-106 byte STATUS2 107-108 byte STATUS3 109-110 byte STATUS4 111-112 byte STATUS5 113-114 byte STATUS6 115-116 byte STATUS7 117-118 byte STATUS8 119-120 byte STATUS9 121-122 byte STATUS10 123-124 byte STATUS11 125-126 byte STATUS12 127-128 byte STATUS13 129-130 byte STATUS14 131-132 byte STATUS15 133-134 byte STATUS16 135-136 byte STATUS17 137-138 byte STATUS18 139-140 byte STATUS19 141-142 byte STATUS20 143-144 byte STATUS21 145-146 byte STATUS22 147-148 byte STATUS23 149-150 byte STATUS24 151-152 byte DECPHLDR 153-153 byte OUTPHLDR 154-154 byte NOPUFLG 155-155 byte COVROUT 156-157 byte TYPEFLAG 158-159 byte PRIVCAT 160-161 byte HOSPINSX 162-163 byte MSUPINSX 164-165 byte DENTLINS 166-167 byte VISIONIN 168-169 byte PMEDINS 170-171 byte COBRA 172-173 byte COVTYPIN 174-174 byte OOPELIG 175-175 double OOPPREM 176-182 double OOPPREMX 183-189 double OOPX12X 190-197 byte OOPFLAG 198-199 byte PREMLEVX 200-201 byte BYFED 202-203 byte BYSTATE 204-205 byte BYLOCAL 206-207 byte BYSOMGOV 208-209 byte BYEMPL 210-211 byte BYUNION 212-213 byte BYOTHER 214-215 str ANNDEDCT 216-217 byte HSAACCT 218-219 byte UPRHMO 220-221 byte NAMECHNG 222-223 using H161.dat; *DEFINE VARIABLE LABELS; label variable EPCPIDX "UNIQUE RECORD ID (EPRSIDX + DUPERSID)"; label variable DUPERSID "PERSON ID (DUID + PID)"; label variable PHLDRIDX "POLICYHOLDER S DUPERSID"; label variable ESTBIDX "ESTABLISHMENT ID"; label variable EPRSIDX "ESTABLISHMENT ID + POLICYHOLDER ID + RN"; label variable PANEL "PANEL NUMBER"; label variable RN "ROUND NUMBER"; label variable JOBSIDX "JOB IDENTIFIER"; label variable JOBSINFR "JOBSIDX INFERRED RATHER THAN REPORTED ID"; label variable JOBSFILE "PUF NUMBER WITH JOBSIDX"; label variable PITFLG "PERSON IN POINT-IN-TIME PUF"; label variable FYFLG "PERSON IN FY PUFS"; label variable CMJINS "CMJ AS THE SOURCE OF PLAN: 1 YES, 2 NO"; label variable EMPLSTAT "POLICYHOLDER EMPLOYMENT STATUS"; label variable PHOLDER "POLICY HOLDER"; label variable DEPNDNT "DEPENDENT OF POLICY HOLDER"; label variable EVALCOVR "COVERED @ INTERVIEW DATE OR 12/31"; label variable STATUS1 "STATUS - MONTH 1"; label variable STATUS2 "STATUS - MONTH 2"; label variable STATUS3 "STATUS - MONTH 3"; label variable STATUS4 "STATUS - MONTH 4"; label variable STATUS5 "STATUS - MONTH 5"; label variable STATUS6 "STATUS - MONTH 6"; label variable STATUS7 "STATUS - MONTH 7"; label variable STATUS8 "STATUS - MONTH 8"; label variable STATUS9 "STATUS - MONTH 9"; label variable STATUS10 "STATUS - MONTH 10"; label variable STATUS11 "STATUS - MONTH 11"; label variable STATUS12 "STATUS - MONTH 12"; label variable STATUS13 "STATUS - MONTH 13"; label variable STATUS14 "STATUS - MONTH 14"; label variable STATUS15 "STATUS - MONTH 15"; label variable STATUS16 "STATUS - MONTH 16"; label variable STATUS17 "STATUS - MONTH 17"; label variable STATUS18 "STATUS - MONTH 18"; label variable STATUS19 "STATUS - MONTH 19"; label variable STATUS20 "STATUS - MONTH 20"; label variable STATUS21 "STATUS - MONTH 21"; label variable STATUS22 "STATUS - MONTH 22"; label variable STATUS23 "STATUS - MONTH 23"; label variable STATUS24 "STATUS - MONTH 24"; label variable DECPHLDR "DECEASED POLICYHOLDER FLAG: 1 YES, 2 NO"; label variable OUTPHLDR "OUT-OF-RU POLICYHOLDER FLAG: 1 YES, 2 NO"; label variable NOPUFLG "PHLDR NOT IN FY OR PIT PUFS"; label variable COVROUT "POLICY COVERS PERS NOT IN RU"; label variable TYPEFLAG "TYPE OF ESTABLISHMENT"; label variable PRIVCAT "CATEGORY OF PRIVATE COVERAGE"; label variable HOSPINSX "TYPE OF HI GOTTEN: HOSPITAL/HMO (EDITED)"; label variable MSUPINSX "TYPE OF HI GOTTEN: MEDIGAP (EDITED)"; label variable DENTLINS "TYPE OF HI GOTTEN: DENTAL"; label variable VISIONIN "TYPE OF HI GOTTEN: VISION"; label variable PMEDINS "TYPE OF HI GOTTEN: PRESCRIPTION DRUG"; label variable COBRA "COBRA COVERAGE: 1=YES, 2=NO"; label variable COVTYPIN "COVERAGE @INTVW: 1=SINGLE, 2=FAMILY"; label variable OOPELIG "FLAG: POLICYHOLDER ESTB HAS PREMIUM"; label variable OOPPREM "MONTHLY OUT-OF-POCKET PREMIUM"; label variable OOPPREMX "MONTHLY OUT-OF-POCKET PREMIUM (ED/IMP)"; label variable OOPX12X "ANNUAL OUT-OF-POCKET PREMIUM (ED/IMP)"; label variable OOPFLAG "1=OOPPREMX ED/IMP, ELSE 0"; label variable PREMLEVX "EDITED PREMLEVL"; label variable BYFED "FEDERAL GOVT PAID FOR PRIV PLAN PREMIUM"; label variable BYSTATE "STATE GOVT PAID FOR PRIV PLAN PREMIUM"; label variable BYLOCAL "LOCAL GOVT PAID FOR PRIV PLAN PREMIUM"; label variable BYSOMGOV "SOME GOVT PAID FOR PRIV PLAN PREMIUM"; label variable BYEMPL "EMPLOYER PAID FOR PRIV PLAN PREMIUM"; label variable BYUNION "UNION PAID FOR PRIV PLAN PREMIUM"; label variable BYOTHER "OTHER PAID FOR PRIV PLAN PREMIUM"; label variable ANNDEDCT "ANNUAL DEDUCTIBLE"; label variable HSAACCT "HSA W/THIS PLAN"; label variable UPRHMO "HMO COVERAGE (FROM PRPL)"; label variable NAMECHNG "HAS THERE BEEN A CHANGE IN PLAN NAME"; *DEFINE VALUE LABELS FOR REPORTS; label define H1610001X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H1610002X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H1610003X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H1610004X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H1610005X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H1610006X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H1610007X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H1610008X -1 "-1 INAPPLICABLE" 1 "1 YES" 2 "2 NO" ; label define H1610009X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H1610010X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H1610011X 1 "1 SINGLE" 2 "2 FAMILY" ; label define H1610012X 1 "1 YES" 2 "2 NO" ; label define H1610013X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H1610014X 0 "0 POLICYHOLDER" 1 "1 DEPENDENT" ; label define H1610015X -1 "-1 INAPPLICABLE" -2 "-2 ED IN PREV RND" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 CURRENTLY EMPLOYED" 2 "2 RETIRED" 3 "3 PREVIOUSLY EMPLOYED" 4 "4 DECEASED" 91 "91 OTHER" ; label define H1610016X -1 "-1 INAPPLICABLE" 1 "1 YES" 2 "2 NO" ; label define H1610017X 0 "0 NO" 1 "1 YES" ; label define H1610018X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H1610019X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H1610020X -1 "-1 INAPPLICABLE" 150 "HC150 2012 JOBSFILE" 158 "HC158 2013 JOBSFILE" ; label define H1610021X -1 "-1 INAPPLICABLE" 0 "0 NO" 1 "1 YES" ; label define H1610022X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H1610023X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H1610024X 1 "1 YES" 2 "2 NO" ; label define H1610025X 1 "1 YES" 2 "2 NO" ; label define H1610026X -1 "-1 INAPPLICABLE" 0 "0 NO" 1 "1 YES" ; label define H1610027X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 0 "0 NO PREMIUM CONTRIBUTION" ; label define H1610028X -1 "-1 INAPPLICABLE" 0 "0 NO PREMIUM CONTRIBUTION" ; label define H1610029X -1 "-1 INAPPLICABLE" 0 "0 NO PREMIUM CONTRIBUTION" ; label define H1610030X 1 "1 YES" 2 "2 NO" ; label define H1610031X 17 "17" 18 "18" ; label define H1610032X 0 "0 DEPENDENT" 1 "1 POLICYHOLDER" ; label define H1610033X 0 "0 NO" 1 "1 YES" ; label define H1610034X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H1610035X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 FAMILY PAYS ALL PREMIUM COST" 2 "2 FAMILY PAYS SOME PREMIUM COST" 3 "3 FAMILY DOES NOT KNOW" 4 "4 FAMILY DOES NOT PAY PREMIUM COST" ; label define H1610036X 0 "0 NOT HOSP/PHYS OR MEDIGAP COVERAGE" 1 "1 EMPLOYER/UNION" 2 "2 NONGROUP" 3 "3 OTHER GROUP" 4 "4 OUT OF HOUSEHOLD" 5 "5 SELF-EMPLOYED" 99 "99 DONT KNOW WHAT KIND PRIV COV" ; label define H1610037X 1 "1" 2 "2" 3 "3" 4 "4" 5 "5" ; label define H1610038X -1 "-1 INAPPLICABLE" 1 "1 YES" 2 "2 NO" ; label define H1610039X -1 "-1 INAPPLICABLE" 1 "1 YES" 2 "2 NO" ; label define H1610040X -1 "-1 INAPPLICABLE" 1 "1 YES" 2 "2 NO" ; label define H1610041X -1 "-1 INAPPLICABLE" 1 "1 YES" 2 "2 NO" ; label define H1610042X -1 "-1 INAPPLICABLE" 1 "1 YES" 2 "2 NO" ; label define H1610043X -1 "-1 INAPPLICABLE" 1 "1 YES" 2 "2 NO" ; label define H1610044X -1 "-1 INAPPLICABLE" 1 "1 YES" 2 "2 NO" ; label define H1610045X -1 "-1 INAPPLICABLE" 1 "1 YES" 2 "2 NO" ; label define H1610046X -1 "-1 INAPPLICABLE" 1 "1 YES" 2 "2 NO" ; label define H1610047X -1 "-1 INAPPLICABLE" 1 "1 YES" 2 "2 NO" ; label define H1610048X -1 "-1 INAPPLICABLE" 1 "1 YES" 2 "2 NO" ; label define H1610049X -1 "-1 INAPPLICABLE" 1 "1 YES" 2 "2 NO" ; label define H1610050X -1 "-1 INAPPLICABLE" 1 "1 YES" 2 "2 NO" ; label define H1610051X -1 "-1 INAPPLICABLE" 1 "1 YES" 2 "2 NO" ; label define H1610052X -1 "-1 INAPPLICABLE" 1 "1 YES" 2 "2 NO" ; label define H1610053X -1 "-1 INAPPLICABLE" 1 "1 YES" 2 "2 NO" ; label define H1610054X -1 "-1 INAPPLICABLE" 1 "1 YES" 2 "2 NO" ; label define H1610055X -1 "-1 INAPPLICABLE" 1 "1 YES" 2 "2 NO" ; label define H1610056X -1 "-1 INAPPLICABLE" 1 "1 YES" 2 "2 NO" ; label define H1610057X -1 "-1 INAPPLICABLE" 1 "1 YES" 2 "2 NO" ; label define H1610058X -1 "-1 INAPPLICABLE" 1 "1 YES" 2 "2 NO" ; label define H1610059X -1 "-1 INAPPLICABLE" 1 "1 YES" 2 "2 NO" ; label define H1610060X -1 "-1 INAPPLICABLE" 1 "1 YES" 2 "2 NO" ; label define H1610061X -1 "-1 INAPPLICABLE" 1 "1 YES" 2 "2 NO" ; label define H1610062X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 EMPLOYER" 10 "10 SPOUSES/DECEASED SPOUSES PREV EMPL" 11 "11 SCHOOL" 12 "12 UNKNOWN TYPE-OUTSIDE RU" 13 "13 UNKNOWN TYPE-COLLECTED AT OTHER" 2 "2 UNION" 20 "20 HIGH RISK POOL" 3 "3 GROUP" 5 "5 INSURANCE COMPANY-FROM AN AGENT" 6 "6 INSURANCE COMPANY" 7 "7 HMO" 8 "8 COBRA" 9 "9 PREVIOUS EMPLOYER-NOT COBRA" ; label define H1610063X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 PRIVATE PLAN IS HMO" 2 "2 PRIVATE PLAN IS NOT HMO" ; label define H1610064X -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 BYEMPL H1610001X; label value BYFED H1610002X; label value BYLOCAL H1610003X; label value BYOTHER H1610004X; label value BYSOMGOV H1610005X; label value BYSTATE H1610006X; label value BYUNION H1610007X; label value CMJINS H1610008X; label value COBRA H1610009X; label value COVROUT H1610010X; label value COVTYPIN H1610011X; label value DECPHLDR H1610012X; label value DENTLINS H1610013X; label value DEPNDNT H1610014X; label value EMPLSTAT H1610015X; label value EVALCOVR H1610016X; label value FYFLG H1610017X; label value HOSPINSX H1610018X; label value HSAACCT H1610019X; label value JOBSFILE H1610020X; label value JOBSINFR H1610021X; label value MSUPINSX H1610022X; label value NAMECHNG H1610023X; label value NOPUFLG H1610024X; label value OOPELIG H1610025X; label value OOPFLAG H1610026X; label value OOPPREM H1610027X; label value OOPPREMX H1610028X; label value OOPX12X H1610029X; label value OUTPHLDR H1610030X; label value PANEL H1610031X; label value PHOLDER H1610032X; label value PITFLG H1610033X; label value PMEDINS H1610034X; label value PREMLEVX H1610035X; label value PRIVCAT H1610036X; label value RN H1610037X; label value STATUS1 H1610038X; label value STATUS10 H1610039X; label value STATUS11 H1610040X; label value STATUS12 H1610041X; label value STATUS13 H1610042X; label value STATUS14 H1610043X; label value STATUS15 H1610044X; label value STATUS16 H1610045X; label value STATUS17 H1610046X; label value STATUS18 H1610047X; label value STATUS19 H1610048X; label value STATUS2 H1610049X; label value STATUS20 H1610050X; label value STATUS21 H1610051X; label value STATUS22 H1610052X; label value STATUS23 H1610053X; label value STATUS24 H1610054X; label value STATUS3 H1610055X; label value STATUS4 H1610056X; label value STATUS5 H1610057X; label value STATUS6 H1610058X; label value STATUS7 H1610059X; label value STATUS8 H1610060X; label value STATUS9 H1610061X; label value TYPEFLAG H1610062X; label value UPRHMO H1610063X; label value VISIONIN H1610064X; *DISPLAY A DESCRIPTION OF STATA FILE; describe; *LIST FIRST 20 OBSERVATIONS IN THE FILE; list in 1/20; save H161, replace; #delimit cr * data file is stored in H161.dta * log file is stored in H161.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 H161.LOG and a data file named H161.DTA. If these files (H161.DTA and H161.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. ************************************************************************************************/