/************************************************************************************************/ /* Stata User File for H33H 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 */ /* (H33H.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 H33H.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\H33H.DO */ /* The program below will output the Stata dataset H33H.DTA */ /************************************************************************************************/ #delimit ; cd C:\MEPS\DATA; log using H33H.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 byte HHR2FLAG 29-30 int HHDATEYR 31-34 byte HHDATEMM 35-36 byte MPCELIG 37-37 byte SELFAGEN 38-39 byte HHTYPE 40-40 byte CNA 41-42 byte COMPANN 43-44 byte DIETICN 45-46 byte HHAIDE 47-48 byte HOSPICE 49-50 byte HMEMAKER 51-52 byte IVTHP 53-54 byte MEDLDOC 55-56 byte NURPRACT 57-58 byte NURAIDE 59-60 byte OCCUPTHP 61-62 byte PERSONAL 63-64 byte PHYSLTHP 65-66 byte RESPTHP 67-68 byte SOCIALW 69-70 byte SPEECTHP 71-72 byte OTHRHCW 73-74 byte NONSKILL 75-76 byte SKILLED 77-78 str SKILLWOS 79-103 byte OTHCW 104-105 str OTHCWOS 106-130 byte HOSPITAL 131-132 byte VSTRELCN 133-134 byte TREATMT 135-136 byte MEDEQUIP 137-138 byte DAILYACT 139-140 byte COMPANY 141-142 byte OTHSVCE 143-144 str OTHSVCOS 145-169 byte FREQCY 170-171 byte DAYSPWK 172-173 byte DAYSPMO 174-175 byte HOWOFTEN 176-177 byte TMSPDAY 178-179 byte HRSLONG 180-181 byte MINLONG 182-183 byte SAMESVCE 184-185 byte HHDAYS 186-187 double HHSF99X 188-194 double HHMR99X 195-201 double HHMD99X 202-209 double HHPV99X 210-216 double HHVA99X 217-223 double HHCH99X 224-229 double HHOF99X 230-235 double HHSL99X 236-242 double HHWC99X 243-247 double HHOR99X 248-254 double HHOU99X 255-260 double HHOT99X 261-266 double HHXP99X 267-274 double HHTC99X 275-282 byte IMPFLAG 283-283 double PERWT99F 284-295 int VARSTR99 296-298 byte VARPSU99 299-300 using H33H.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 HHR2FLAG "FLAG FOR PANEL 3 R2 EVENT IN 1999"; 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 - NURSES 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 EQUIPMT"; label variable DAILYACT "PERSON WAS HELPED WI 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 WK/SOME WKS"; label variable DAYSPWK "# DAYS PER WEEK PROVIDER CAME (HA ONLY)"; label variable DAYSPMO "# DAYS PER MONTH PROVIDER CAME (HA 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, 1999"; label variable HHSF99X "AMOUNT PAID,FAMILY (IMPUTED)"; label variable HHMR99X "AMOUNT PAID,MEDICARE (IMPUTED)"; label variable HHMD99X "AMOUNT PAID,MEDICAID (IMPUTED)"; label variable HHPV99X "AMOUNT PAID,PRIVATE INSURANCE (IMPUTED)"; label variable HHVA99X "AMOUNT PAID,VETERANS (IMPUTED)"; label variable HHCH99X "AMOUNT PAID,CHAMPUS/CHAMPVA (IMPUTED)"; label variable HHOF99X "AMOUNT PAID,OTHER FEDERAL (IMPUTED)"; label variable HHSL99X "AMOUNT PAID,STATE & LOCAL GOV (IMPUTED)"; label variable HHWC99X "AMOUNT PAID,WORKERS COMP (IMPUTED)"; label variable HHOR99X "AMOUNT PAID, OTHER PRIVATE (IMPUTED)"; label variable HHOU99X "AMOUNT PAID, OTHER PUBLIC (IMPUTED)"; label variable HHOT99X "AMOUNT PAID,OTHER INSURANCE (IMPUTED)"; label variable HHXP99X "SUM OF HHSF99X-HHOT99X (IMPUTED)"; label variable HHTC99X "HHLD REPORTED TOTAL CHARGE (IMPUTED)"; label variable IMPFLAG "IMPUTATION STATUS"; label variable PERWT99F "FINAL PERSON LEVEL WEIGHT, 1999"; label variable VARSTR99 "VARIANCE ESTIMATION STRATUM 1999"; label variable VARPSU99 "VARIANCE ESTIMATION PSU 1999"; *DEFINE VALUE LABELS FOR REPORTS; label define H33H0001X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H33H0002X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H33H0003X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES, AT LEAST ONCE" 2 "2 NO" ; label define H33H0004X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES, AT LEAST ONCE" 2 "2 NO" ; label define H33H0005X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H33H0006X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H33H0007X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H33H0008X 1 "1 ROUND 1" 2 "2 ROUND 2" 3 "3 ROUND 3" 4 "4 ROUND 4" 5 "5 ROUND 5" ; label define H33H0009X -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 H33H0010X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H33H0011X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 0 "0" 194.54 "$194.54 - $194.54" ; label define H33H0012X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" ; label define H33H0013X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1999 "1999" ; label define H33H0014X -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H33H0015X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H33H0016X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H33H0017X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H33H0018X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H33H0019X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H33H0020X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H33H0021X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H33H0022X -1 "NO R2 CROSSOVER PROBLEM" 1 "1 PANEL 3 R2 EVENT IN 1999" ; label define H33H0023X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H33H0024X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H33H0025X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H33H0026X -1 "-1 INAPPLICABLE" -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 H33H0027X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H33H0028X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H33H0029X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H33H0030X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H33H0031X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H33H0032X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H33H0033X -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 H33H0034X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H33H0035X 0 "NOT ELIGIBLE FOR IMPUTATION" 1 "COMPLETE HC DATA" 2 "COMPLETE MPC DATA" 3 "FULLY IMPUTED" 4 "PARTIALLY IMPUTED" 5 "CAPITATION IMPUTATION" ; label define H33H0036X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H33H0037X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES, AT LEAST ONCE" 2 "2 NO" ; label define H33H0038X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H33H0039X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H33H0040X 1 "1 MPC ELIGIBLE - AGENCY" 2 "2 NOT MPC ELIGIBLE HHP - PAID INDEP" 3 "3 NOT MPC ELIG - INFORMAL CARE" ; label define H33H0041X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H33H0042X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H33H0043X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H33H0044X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H33H0045X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H33H0046X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H33H0047X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES, AT LEAST ONCE" 2 "2 NO" ; label define H33H0048X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H33H0049X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H33H0050X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H33H0051X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "YES" 2 "NO" ; label define H33H0052X -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 H33H0053X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H33H0054X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H33H0055X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H33H0056X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" ; label define H33H0057X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES, AT LEAST ONCE" 2 "2 NO" ; label define H33H0058X -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 H33H0001X; label value COMPANN H33H0002X; label value COMPANY H33H0003X; label value DAILYACT H33H0004X; label value DAYSPMO H33H0005X; label value DAYSPWK H33H0006X; label value DIETICN H33H0007X; label value EVENTRN H33H0008X; label value FREQCY H33H0009X; label value HHAIDE H33H0010X; label value HHCH99X H33H0011X; label value HHDATEMM H33H0012X; label value HHDATEYR H33H0013X; label value HHDAYS H33H0014X; label value HHMD99X H33H0015X; label value HHMR99X H33H0016X; label value HHOF99X H33H0017X; label value HHOR99X H33H0018X; label value HHOT99X H33H0019X; label value HHOU99X H33H0020X; label value HHPV99X H33H0021X; label value HHR2FLAG H33H0022X; label value HHSF99X H33H0023X; label value HHSL99X H33H0024X; label value HHTC99X H33H0025X; label value HHTYPE H33H0026X; label value HHVA99X H33H0027X; label value HHWC99X H33H0028X; label value HHXP99X H33H0029X; label value HMEMAKER H33H0030X; label value HOSPICE H33H0031X; label value HOSPITAL H33H0032X; label value HOWOFTEN H33H0033X; label value HRSLONG H33H0034X; label value IMPFLAG H33H0035X; label value IVTHP H33H0036X; label value MEDEQUIP H33H0037X; label value MEDLDOC H33H0038X; label value MINLONG H33H0039X; label value MPCELIG H33H0040X; label value NONSKILL H33H0041X; label value NURAIDE H33H0042X; label value NURPRACT H33H0043X; label value OCCUPTHP H33H0044X; label value OTHCW H33H0045X; label value OTHRHCW H33H0046X; label value OTHSVCE H33H0047X; label value PERSONAL H33H0048X; label value PHYSLTHP H33H0049X; label value RESPTHP H33H0050X; label value SAMESVCE H33H0051X; label value SELFAGEN H33H0052X; label value SKILLED H33H0053X; label value SOCIALW H33H0054X; label value SPEECTHP H33H0055X; label value TMSPDAY H33H0056X; label value TREATMT H33H0057X; label value VSTRELCN H33H0058X; *DISPLAY A DESCRIPTION OF STATA FILE; describe; *LIST FIRST 20 OBSERVATIONS IN THE FILE; list in 1/20; save H33H, replace; #delimit cr * data file is stored in H33H.dta * log file is stored in H33H.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 H33H.LOG and a data file named H33H.DTA. If these files (H33H.DTA and H33H.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. ************************************************************************************************/