/************************************************************************************************/ /* Stata User File for H197H 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 */ /* (H197H.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 H197H.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\H197H.DO */ /* The program below will output the Stata dataset H197H.DTA */ /************************************************************************************************/ #delimit ; cd C:\MEPS\DATA; log using H197H.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 VSTRELCN 76-77 byte FREQCY 78-79 byte DAYSPWK 80-81 byte DAYSPMO 82-83 byte SAMESVCE 84-85 byte HHDAYS 86-87 double HHSF17X 88-95 double HHMR17X 96-103 double HHMD17X 104-111 double HHPV17X 112-118 double HHVA17X 119-125 double HHTR17X 126-132 double HHOF17X 133-138 double HHSL17X 139-146 double HHWC17X 147-151 double HHOR17X 152-158 double HHOU17X 159-165 double HHOT17X 166-171 double HHXP17X 172-179 double HHTC17X 180-187 byte IMPFLAG 188-188 double PERWT17F 189-200 int VARSTR 201-204 byte VARPSU 205-205 using H197H.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 VSTRELCN "ANY HH CARE SVCE RELATED TO HLTH COND"; 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 SAMESVCE "ANY OTH MONS PER RECEIVED SAME SERVICES"; label variable HHDAYS "DAYS PER MONTH IN HOME HEALTH, 2017"; label variable HHSF17X "AMOUNT PAID, FAMILY (IMPUTED)"; label variable HHMR17X "AMOUNT PAID, MEDICARE (IMPUTED)"; label variable HHMD17X "AMOUNT PAID, MEDICAID (IMPUTED)"; label variable HHPV17X "AMOUNT PAID, PRIVATE INSURANCE (IMPUTED)"; label variable HHVA17X "AMOUNT PAID, VETERANS/CHAMPVA(IMPUTED)"; label variable HHTR17X "AMOUNT PAID, TRICARE(IMPUTED)"; label variable HHOF17X "AMOUNT PAID, OTHER FEDERAL (IMPUTED)"; label variable HHSL17X "AMOUNT PAID, STATE & LOCAL GOV (IMPUTED)"; label variable HHWC17X "AMOUNT PAID, WORKERS COMP (IMPUTED)"; label variable HHOR17X "AMOUNT PAID, OTHER PRIVATE (IMPUTED)"; label variable HHOU17X "AMOUNT PAID, OTHER PUBLIC (IMPUTED)"; label variable HHOT17X "AMOUNT PAID, OTHER INSURANCE (IMPUTED)"; label variable HHXP17X "SUM OF HHSF17X - HHOT17X (IMPUTED)"; label variable HHTC17X "HHLD REPORTED TOTAL CHARGE (IMPUTED)"; label variable IMPFLAG "IMPUTATION STATUS"; label variable PERWT17F "EXPENDITURE FILE PERSON WEIGHT, 2017"; label variable VARSTR "VARIANCE ESTIMATION STRATUM, 2017"; label variable VARPSU "VARIANCE ESTIMATION PSU, 2017"; *DEFINE VALUE LABELS FOR REPORTS; label define H197H0001X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H197H0002X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H197H0003X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H197H0004X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" ; label define H197H0005X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H197H0006X 1 "ROUND 1" 2 "ROUND 2" 3 "ROUND 3" 4 "ROUND 4" 5 "ROUND 5" ; label define H197H0007X -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 H197H0008X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H197H0009X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" ; label define H197H0010X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 2017 "2017" ; label define H197H0011X -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H197H0012X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H197H0013X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H197H0014X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H197H0015X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H197H0016X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H197H0017X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H197H0018X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H197H0019X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H197H0020X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H197H0021X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H197H0022X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H197H0023X -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 H197H0024X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H197H0025X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H197H0026X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H197H0027X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H197H0028X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H197H0029X -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 H197H0030X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H197H0031X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H197H0032X 1 "1 MPC ELIGIBLE - AGENCY" 2 "2 NOT MPC ELIGIBLE - PAID INDEP" 3 "3 NOT MPC ELIG - INFORMAL CARE" ; label define H197H0033X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H197H0034X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H197H0035X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H197H0036X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H197H0037X 21 "PANEL 21" 22 "PANEL 22" ; label define H197H0038X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H197H0039X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H197H0040X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H197H0041X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H197H0042X -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 H197H0043X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H197H0044X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H197H0045X -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 H197H0001X; label value COMPANN H197H0002X; label value DAYSPMO H197H0003X; label value DAYSPWK H197H0004X; label value DIETICN H197H0005X; label value EVENTRN H197H0006X; label value FREQCY H197H0007X; label value HHAIDE H197H0008X; label value HHDATEMM H197H0009X; label value HHDATEYR H197H0010X; label value HHDAYS H197H0011X; label value HHMD17X H197H0012X; label value HHMR17X H197H0013X; label value HHOF17X H197H0014X; label value HHOR17X H197H0015X; label value HHOT17X H197H0016X; label value HHOU17X H197H0017X; label value HHPV17X H197H0018X; label value HHSF17X H197H0019X; label value HHSL17X H197H0020X; label value HHTC17X H197H0021X; label value HHTR17X H197H0022X; label value HHTYPE H197H0023X; label value HHVA17X H197H0024X; label value HHWC17X H197H0025X; label value HHXP17X H197H0026X; label value HMEMAKER H197H0027X; label value HOSPICE H197H0028X; label value IMPFLAG H197H0029X; label value IVTHP H197H0030X; label value MEDLDOC H197H0031X; label value MPCELIG H197H0032X; label value NURAIDE H197H0033X; label value NURPRACT H197H0034X; label value OCCUPTHP H197H0035X; label value OTHRHCW H197H0036X; label value PANEL H197H0037X; label value PERSONAL H197H0038X; label value PHYSLTHP H197H0039X; label value RESPTHP H197H0040X; label value SAMESVCE H197H0041X; label value SELFAGEN H197H0042X; label value SOCIALW H197H0043X; label value SPEECTHP H197H0044X; label value VSTRELCN H197H0045X; *DISPLAY A DESCRIPTION OF STATA FILE; describe; *LIST FIRST 20 OBSERVATIONS IN THE FILE; list in 1/20; save H197H, replace; #delimit cr * data file is stored in H197H.dta * log file is stored in H197H.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 H197H.LOG and a data file named H197H.DTA. If these files (H197H.DTA and H197H.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. ************************************************************************************************/