/************************************************************************************************/ /* Stata User File for H118H 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 */ /* (H118H.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 H118H.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\H118H.DO */ /* The program below will output the Stata dataset H118H.DTA */ /************************************************************************************************/ #delimit ; cd C:\MEPS\DATA; log using H118H.log, replace; clear; * INPUT ALL VARIABLES; infix long DUID 1-5 int PID 6-8 str DUPERSID 9-16 str EVNTIDX 17-28 byte EVENTRN 29-29 byte PANEL 30-31 int HHDATEYR 32-35 byte HHDATEMM 36-37 byte MPCELIG 38-38 byte SELFAGEN 39-40 byte HHTYPE 41-41 byte CNA 42-43 byte COMPANN 44-45 byte DIETICN 46-47 byte HHAIDE 48-49 byte HOSPICE 50-51 byte HMEMAKER 52-53 byte IVTHP 54-55 byte MEDLDOC 56-57 byte NURPRACT 58-59 byte NURAIDE 60-61 byte OCCUPTHP 62-63 byte PERSONAL 64-65 byte PHYSLTHP 66-67 byte RESPTHP 68-69 byte SOCIALW 70-71 byte SPEECTHP 72-73 byte OTHRHCW 74-75 byte NONSKILL 76-77 byte SKILLED 78-79 str SKILLWOS 80-104 byte OTHCW 105-106 str OTHCWOS 107-131 byte HOSPITAL 132-133 byte VSTRELCN 134-135 byte TREATMT 136-137 byte MEDEQUIP 138-139 byte DAILYACT 140-141 byte COMPANY 142-143 byte OTHSVCE 144-145 str OTHSVCOS 146-170 byte FREQCY 171-172 byte DAYSPWK 173-174 byte DAYSPMO 175-176 byte HOWOFTEN 177-178 byte TMSPDAY 179-180 byte HRSLONG 181-182 byte MINLONG 183-184 byte SAMESVCE 185-186 byte HHDAYS 187-188 double HHSF08X 189-195 double HHMR08X 196-202 double HHMD08X 203-209 double HHPV08X 210-217 double HHVA08X 218-224 double HHTR08X 225-231 double HHOF08X 232-238 double HHSL08X 239-245 double HHWC08X 246-252 double HHOR08X 253-259 double HHOU08X 260-266 double HHOT08X 267-273 double HHXP08X 274-281 double HHTC08X 282-289 byte IMPFLAG 290-290 double PERWT08F 291-302 int VARSTR 303-306 byte VARPSU 307-307 using H118H.dat; *DEFINE VARIABLE LABELS; label variable DUID "DWELLING UNIT ID"; label variable PID "PERSON NUMBER"; label variable DUPERSID "PERSON ID (DUID + PID)"; label variable EVNTIDX "EVENT ID"; label variable EVENTRN "EVENT ROUND NUMBER"; label variable PANEL "PANEL NUMBER"; label variable HHDATEYR "EVENT DATE - YEAR"; label variable HHDATEMM "EVENT DATE - MONTH"; label variable MPCELIG "MPC ELIGIBILITY FLAG"; label variable SELFAGEN "DOES PROVIDER WORK FOR AGENCY OR SELF"; label variable HHTYPE "HOME HEALTH EVENT TYPE"; label variable CNA "TYPE OF HLTH CARE WRKR - CERT NURSE ASST"; label variable COMPANN "TYPE OF HLTH CARE WRKR - COMPANION"; label variable DIETICN "TYPE OF HLTH CARE WRKR - DIETITIAN/NUTRT"; label variable HHAIDE "TYPE OF HLTH CARE WRKR - HOME CARE AIDE"; label variable HOSPICE "TYPE OF HLTH CARE WRKR - HOSPICE WORKER"; label variable HMEMAKER "TYPE OF HLTH CARE WRKR - HOMEMAKER"; label variable IVTHP "TYPE OF HLTH CARE WRKR - IV THERAPIST"; label variable MEDLDOC "TYPE OF HLTH CARE WRKR - MEDICAL DOCTOR"; label variable NURPRACT "TYPE OF HLTH CARE WRKR - NURSE/PRACTR"; label variable NURAIDE "TYPE OF HLTH CARE WRKR - NURSE S AIDE"; label variable OCCUPTHP "TYPE OF HLTH CARE WRKR - OCCUP THERAP"; label variable PERSONAL "TYPE OF HLTH CARE WRKR - PERS CARE ATTDT"; label variable PHYSLTHP "TYPE OF HLTH CARE WRKR - PHYSICL THERAPY"; label variable RESPTHP "TYPE OF HLTH CARE WRKR - RESPIRA THERAPY"; label variable SOCIALW "TYPE OF HLTH CARE WRKR - SOCIAL WORKER"; label variable SPEECTHP "TYPE OF HLTH CARE WRKR - SPEECH THERAPY"; label variable OTHRHCW "TYPE OF HLTH CARE WRKR - OTHER"; label variable NONSKILL "TYPE OF HLTH CARE WRKR - NON-SKILLED"; label variable SKILLED "TYPE OF HLTH CARE WRKR - SKILLED"; label variable SKILLWOS "SPECIFY TYPE OF SKILLED WORKER"; label variable OTHCW "TYPE OF HLTH CARE WRKR - SOME OTHER"; label variable OTHCWOS "SPECIFY OTHER TYPE HEALTH CARE WORKER"; label variable HOSPITAL "ANY HH CARE SVCE DUE TO HOSPITALIZATION"; label variable VSTRELCN "ANY HH CARE SVCE RELATED TO HLTH COND"; label variable TREATMT "PERSON RECEIVED MEDICAL TREATMENT"; label variable MEDEQUIP "PERSON WAS TAUGHT USE OF MED EQUIPMENT"; label variable DAILYACT "PERSON WAS HELPED WITH DAILY ACTIVITIES"; label variable COMPANY "PERSON RECEIVED COMPANIONSHIP SERVICES"; label variable OTHSVCE "PERSON RECEIVED OTH HOME CARE SERVICES"; label variable OTHSVCOS "SPECIFY OTHER HOME CARE SRVCE RECEIVED"; label variable FREQCY "PROVIDER HELPED EVERY WEEK/SOME WEEKS"; label variable DAYSPWK "# DAYS / WEEK PROVIDER CAME"; label variable DAYSPMO "# DAYS / MONTH PROVIDER CAME"; label variable HOWOFTEN "PROV CAME ONCE PER DAY/MORE THAN ONCE"; label variable TMSPDAY "TIMES/DAY PROVIDER CAME TO HOME TO HELP"; label variable HRSLONG "HOURS EACH VISIT LASTED"; label variable MINLONG "MINUTES EACH VISIT LASTED"; label variable SAMESVCE "ANY OTH MONS PER RECEIVED SAME SERVICES"; label variable HHDAYS "DAYS PER MONTH IN HOME HEALTH, 2008"; label variable HHSF08X "AMOUNT PAID, FAMILY (IMPUTED)"; label variable HHMR08X "AMOUNT PAID, MEDICARE (IMPUTED)"; label variable HHMD08X "AMOUNT PAID, MEDICAID (IMPUTED)"; label variable HHPV08X "AMOUNT PAID, PRIVATE INSURANCE (IMPUTED)"; label variable HHVA08X "AMOUNT PAID, VETERANS/CHAMPVA(IMPUTED)"; label variable HHTR08X "AMOUNT PAID, TRICARE(IMPUTED)"; label variable HHOF08X "AMOUNT PAID, OTHER FEDERAL (IMPUTED)"; label variable HHSL08X "AMOUNT PAID, STATE & LOCAL GOV (IMPUTED)"; label variable HHWC08X "AMOUNT PAID, WORKERS COMP (IMPUTED)"; label variable HHOR08X "AMOUNT PAID, OTHER PRIVATE (IMPUTED)"; label variable HHOU08X "AMOUNT PAID, OTHER PUBLIC (IMPUTED)"; label variable HHOT08X "AMOUNT PAID, OTHER INSURANCE (IMPUTED)"; label variable HHXP08X "SUM OF HHSF08X - HHOT08X (IMPUTED)"; label variable HHTC08X "HHLD REPORTED TOTAL CHARGE (IMPUTED)"; label variable IMPFLAG "IMPUTATION STATUS"; label variable PERWT08F "EXPENDITURE FILE PERSON WEIGHT, 2008"; label variable VARSTR "VARIANCE ESTIMATION STRATUM, 2008"; label variable VARPSU "VARIANCE ESTIMATION PSU, 2008"; *DEFINE VALUE LABELS FOR REPORTS; label define H118H0001X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H118H0002X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H118H0003X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES, AT LEAST ONCE" 2 "2 NO" ; label define H118H0004X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES, AT LEAST ONCE" 2 "2 NO" ; label define H118H0005X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H118H0006X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" ; label define H118H0007X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H118H0008X 1 "ROUND 1" 2 "ROUND 2" 3 "ROUND 3" 4 "ROUND 4" 5 "ROUND 5" ; label define H118H0009X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 EVERY WEEK" 2 "2 SOME WEEKS" 3 "3 ONLY CAME ONCE" ; label define H118H0010X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H118H0011X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" ; label define H118H0012X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 2008 "2008" ; label define H118H0013X -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H118H0014X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H118H0015X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H118H0016X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H118H0017X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H118H0018X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H118H0019X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H118H0020X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H118H0021X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H118H0022X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H118H0023X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H118H0024X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 0 "0" 1817.65 "$1.00 - $1,817.65" ; label define H118H0025X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 FRIEND/NEIGHBOR" 2 "2 RELATIVE" 3 "3 VOLUNTEER" 4 "4 OTHER - PAID" 5 "5 VOLUNTEERED: MEAL SERVICE DELIVERY" ; label define H118H0026X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H118H0027X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 0 "0" 1280 "$1.00 - $1,280.00" ; label define H118H0028X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H118H0029X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H118H0030X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H118H0031X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H118H0032X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 ONCE PER DAY" 2 "2 MORE THAN ONCE PER DAY" 3 "3 24 HOURS PER DAY" ; label define H118H0033X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H118H0034X -1 "-1 INAPPLICABLE" 0 "0 NOT ELIGIBLE FOR IMPUTATION" 1 "1 COMPLETE HC DATA" 2 "2 COMPLETE MPC DATA" 3 "3 FULLY IMPUTED" 4 "4 PARTIALLY IMPUTED" 5 "5 CAPITATION IMPUTATION" ; label define H118H0035X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H118H0036X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES, AT LEAST ONCE" 2 "2 NO" ; label define H118H0037X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H118H0038X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H118H0039X 1 "1 MPC ELIGIBLE - AGENCY" 2 "2 NOT MPC ELIGIBLE - PAID INDEP" 3 "3 NOT MPC ELIG - INFORMAL CARE" ; label define H118H0040X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H118H0041X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H118H0042X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H118H0043X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H118H0044X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H118H0045X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H118H0046X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES, AT LEAST ONCE" 2 "2 NO" ; label define H118H0047X 12 "PANEL 12" 13 "PANEL 13" ; label define H118H0048X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H118H0049X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H118H0050X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H118H0051X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H118H0052X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 WORK FOR AGENCY, HOSP, NURS HOME" 2 "2 WORK FOR SELF" ; label define H118H0053X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H118H0054X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H118H0055X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H118H0056X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" ; label define H118H0057X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES, AT LEAST ONCE" 2 "2 NO" ; label define H118H0058X -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 CNA H118H0001X; label value COMPANN H118H0002X; label value COMPANY H118H0003X; label value DAILYACT H118H0004X; label value DAYSPMO H118H0005X; label value DAYSPWK H118H0006X; label value DIETICN H118H0007X; label value EVENTRN H118H0008X; label value FREQCY H118H0009X; label value HHAIDE H118H0010X; label value HHDATEMM H118H0011X; label value HHDATEYR H118H0012X; label value HHDAYS H118H0013X; label value HHMD08X H118H0014X; label value HHMR08X H118H0015X; label value HHOF08X H118H0016X; label value HHOR08X H118H0017X; label value HHOT08X H118H0018X; label value HHOU08X H118H0019X; label value HHPV08X H118H0020X; label value HHSF08X H118H0021X; label value HHSL08X H118H0022X; label value HHTC08X H118H0023X; label value HHTR08X H118H0024X; label value HHTYPE H118H0025X; label value HHVA08X H118H0026X; label value HHWC08X H118H0027X; label value HHXP08X H118H0028X; label value HMEMAKER H118H0029X; label value HOSPICE H118H0030X; label value HOSPITAL H118H0031X; label value HOWOFTEN H118H0032X; label value HRSLONG H118H0033X; label value IMPFLAG H118H0034X; label value IVTHP H118H0035X; label value MEDEQUIP H118H0036X; label value MEDLDOC H118H0037X; label value MINLONG H118H0038X; label value MPCELIG H118H0039X; label value NONSKILL H118H0040X; label value NURAIDE H118H0041X; label value NURPRACT H118H0042X; label value OCCUPTHP H118H0043X; label value OTHCW H118H0044X; label value OTHRHCW H118H0045X; label value OTHSVCE H118H0046X; label value PANEL H118H0047X; label value PERSONAL H118H0048X; label value PHYSLTHP H118H0049X; label value RESPTHP H118H0050X; label value SAMESVCE H118H0051X; label value SELFAGEN H118H0052X; label value SKILLED H118H0053X; label value SOCIALW H118H0054X; label value SPEECTHP H118H0055X; label value TMSPDAY H118H0056X; label value TREATMT H118H0057X; label value VSTRELCN H118H0058X; *DISPLAY A DESCRIPTION OF STATA FILE; describe; *LIST FIRST 20 OBSERVATIONS IN THE FILE; list in 1/20; save H118H, replace; #delimit cr * data file is stored in H118H.dta * log file is stored in H118H.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 H118H.LOG and a data file named H118H.DTA. If these files (H118H.DTA and H118H.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. ************************************************************************************************/