/************************************************************************************************/ /* Stata User File for H77H 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 */ /* (H77H.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 H77H.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\H77H.DO */ /* The program below will output the Stata dataset H77H.DTA */ /************************************************************************************************/ #delimit ; cd C:\MEPS\DATA; log using H77H.log, replace; clear; * INPUT ALL VARIABLES; infix long DUID 1-5 byte PID 6-7 str DUPERSID 8-15 str EVNTIDX 16-27 byte EVENTRN 28-28 int HHDATEYR 29-32 byte HHDATEMM 33-34 byte MPCELIG 35-35 byte SELFAGEN 36-37 byte HHTYPE 38-38 byte CNA 39-40 byte COMPANN 41-42 byte DIETICN 43-44 byte HHAIDE 45-46 byte HOSPICE 47-48 byte HMEMAKER 49-50 byte IVTHP 51-52 byte MEDLDOC 53-54 byte NURPRACT 55-56 byte NURAIDE 57-58 byte OCCUPTHP 59-60 byte PERSONAL 61-62 byte PHYSLTHP 63-64 byte RESPTHP 65-66 byte SOCIALW 67-68 byte SPEECTHP 69-70 byte OTHRHCW 71-72 byte NONSKILL 73-74 byte SKILLED 75-76 str SKILLWOS 77-101 byte OTHCW 102-103 str OTHCWOS 104-128 byte HOSPITAL 129-130 byte VSTRELCN 131-132 byte TREATMT 133-134 byte MEDEQUIP 135-136 byte DAILYACT 137-138 byte COMPANY 139-140 byte OTHSVCE 141-142 str OTHSVCOS 143-167 byte FREQCY 168-169 byte DAYSPWK 170-171 byte DAYSPMO 172-173 byte HOWOFTEN 174-175 byte TMSPDAY 176-177 byte HRSLONG 178-179 byte MINLONG 180-181 byte SAMESVCE 182-183 byte HHDAYS 184-185 double HHSF03X 186-193 double HHMR03X 194-200 double HHMD03X 201-207 double HHPV03X 208-214 double HHVA03X 215-221 double HHTR03X 222-226 double HHOF03X 227-232 double HHSL03X 233-239 double HHWC03X 240-246 double HHOR03X 247-253 double HHOU03X 254-259 double HHOT03X 260-266 double HHXP03X 267-274 double HHTC03X 275-282 byte IMPFLAG 283-283 double PERWT03F 284-295 int VARSTR 296-298 byte VARPSU 299-299 using H77H.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 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 / WK PROVIDER CAME (AGENCY ONLY)"; label variable DAYSPMO "# DAYS / MTH PROVIDER CAME (AGENCY ONLY)"; label variable HOWOFTEN "PROV CAME ONCE PER DAY/MORE THAN ONCE"; label variable TMSPDAY "TIMES/DAY PROVIDER CAME 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, 2003"; label variable HHSF03X "AMOUNT PAID, FAMILY (IMPUTED)"; label variable HHMR03X "AMOUNT PAID, MEDICARE (IMPUTED)"; label variable HHMD03X "AMOUNT PAID, MEDICAID (IMPUTED)"; label variable HHPV03X "AMOUNT PAID, PRIVATE INSURANCE (IMPUTED)"; label variable HHVA03X "AMOUNT PAID, VETERANS (IMPUTED)"; label variable HHTR03X "AMOUNT PAID, TRICARE (IMPUTED)"; label variable HHOF03X "AMOUNT PAID, OTHER FEDERAL (IMPUTED)"; label variable HHSL03X "AMOUNT PAID, STATE & LOCAL GOV (IMPUTED)"; label variable HHWC03X "AMOUNT PAID, WORKERS COMP (IMPUTED)"; label variable HHOR03X "AMOUNT PAID, OTHER PRIVATE (IMPUTED)"; label variable HHOU03X "AMOUNT PAID, OTHER PUBLIC (IMPUTED)"; label variable HHOT03X "AMOUNT PAID, OTHER INSURANCE (IMPUTED)"; label variable HHXP03X "SUM OF HHSF03X - HHOT03X (IMPUTED)"; label variable HHTC03X "HHLD REPORTED TOTAL CHARGE (IMPUTED)"; label variable IMPFLAG "IMPUTATION STATUS"; label variable PERWT03F "EXPENDITURE FILE PERSON WEIGHT, 2003"; label variable VARSTR "VARIANCE ESTIMATION STRATUM, 2003"; label variable VARPSU "VARIANCE ESTIMATION PSU, 2003"; *DEFINE VALUE LABELS FOR REPORTS; label define H77H0001X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H77H0002X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H77H0003X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES, AT LEAST ONCE" 2 "2 NO" ; label define H77H0004X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES, AT LEAST ONCE" 2 "2 NO" ; label define H77H0005X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H77H0006X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" ; label define H77H0007X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H77H0008X 1 "ROUND 1" 2 "ROUND 2" 3 "ROUND 3" 4 "ROUND 4" 5 "ROUND 5" ; label define H77H0009X -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 H77H0010X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H77H0011X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" ; label define H77H0012X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 2003 "2003" ; label define H77H0013X -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H77H0014X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H77H0015X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H77H0016X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H77H0017X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H77H0018X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H77H0019X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H77H0020X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H77H0021X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H77H0022X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H77H0023X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H77H0024X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H77H0025X -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 H77H0026X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H77H0027X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 0 "0" 1550 "$1,550.00" ; label define H77H0028X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H77H0029X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H77H0030X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H77H0031X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H77H0032X -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 H77H0033X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H77H0034X -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 H77H0035X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H77H0036X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES, AT LEAST ONCE" 2 "2 NO" ; label define H77H0037X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H77H0038X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H77H0039X 1 "1 MPC ELIGIBLE - AGENCY" 2 "2 NOT MPC ELIGIBLE - PAID INDEP" 3 "3 NOT MPC ELIG - INFORMAL CARE" ; label define H77H0040X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H77H0041X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H77H0042X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H77H0043X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H77H0044X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H77H0045X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H77H0046X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES, AT LEAST ONCE" 2 "2 NO" ; label define H77H0047X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H77H0048X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H77H0049X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H77H0050X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H77H0051X -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 H77H0052X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H77H0053X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H77H0054X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H77H0055X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" ; label define H77H0056X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES, AT LEAST ONCE" 2 "2 NO" ; label define H77H0057X -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 H77H0001X; label value COMPANN H77H0002X; label value COMPANY H77H0003X; label value DAILYACT H77H0004X; label value DAYSPMO H77H0005X; label value DAYSPWK H77H0006X; label value DIETICN H77H0007X; label value EVENTRN H77H0008X; label value FREQCY H77H0009X; label value HHAIDE H77H0010X; label value HHDATEMM H77H0011X; label value HHDATEYR H77H0012X; label value HHDAYS H77H0013X; label value HHMD03X H77H0014X; label value HHMR03X H77H0015X; label value HHOF03X H77H0016X; label value HHOR03X H77H0017X; label value HHOT03X H77H0018X; label value HHOU03X H77H0019X; label value HHPV03X H77H0020X; label value HHSF03X H77H0021X; label value HHSL03X H77H0022X; label value HHTC03X H77H0023X; label value HHTR03X H77H0024X; label value HHTYPE H77H0025X; label value HHVA03X H77H0026X; label value HHWC03X H77H0027X; label value HHXP03X H77H0028X; label value HMEMAKER H77H0029X; label value HOSPICE H77H0030X; label value HOSPITAL H77H0031X; label value HOWOFTEN H77H0032X; label value HRSLONG H77H0033X; label value IMPFLAG H77H0034X; label value IVTHP H77H0035X; label value MEDEQUIP H77H0036X; label value MEDLDOC H77H0037X; label value MINLONG H77H0038X; label value MPCELIG H77H0039X; label value NONSKILL H77H0040X; label value NURAIDE H77H0041X; label value NURPRACT H77H0042X; label value OCCUPTHP H77H0043X; label value OTHCW H77H0044X; label value OTHRHCW H77H0045X; label value OTHSVCE H77H0046X; label value PERSONAL H77H0047X; label value PHYSLTHP H77H0048X; label value RESPTHP H77H0049X; label value SAMESVCE H77H0050X; label value SELFAGEN H77H0051X; label value SKILLED H77H0052X; label value SOCIALW H77H0053X; label value SPEECTHP H77H0054X; label value TMSPDAY H77H0055X; label value TREATMT H77H0056X; label value VSTRELCN H77H0057X; *DISPLAY A DESCRIPTION OF STATA FILE; describe; *LIST FIRST 20 OBSERVATIONS IN THE FILE; list in 1/20; save H77H, replace; #delimit cr * data file is stored in H77H.dta * log file is stored in H77H.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 H77H.LOG and a data file named H77H.DTA. If these files (H77H.DTA and H77H.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. ************************************************************************************************/