/************************************************************************************************/ /* Stata User File for H160E 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 */ /* (H160E.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 H160E.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\H160E.DO */ /* The program below will output the Stata dataset H160E.DTA */ /************************************************************************************************/ #delimit ; cd C:\MEPS\DATA; log using H160E.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 str ERHEVIDX 30-41 str FFEEIDX 42-53 byte PANEL 54-55 byte MPCDATA 56-56 int ERDATEYR 57-60 byte ERDATEMM 61-62 byte VSTCTGRY 63-64 byte VSTRELCN 65-66 byte LABTEST 67-68 byte SONOGRAM 69-70 byte XRAYS 71-72 byte MAMMOG 73-74 byte MRI 75-76 byte EKG 77-78 byte EEG 79-80 byte RCVVAC 81-82 byte ANESTH 83-84 byte THRTSWAB 85-86 byte OTHSVCE 87-88 byte SURGPROC 89-90 byte MEDPRESC 91-92 str ERCCC1X 93-95 str ERCCC2X 96-98 str ERCCC3X 99-101 byte FFERTYPE 102-103 double ERXP13X 104-111 double ERTC13X 112-120 double ERFSF13X 121-127 double ERFMR13X 128-135 double ERFMD13X 136-143 double ERFPV13X 144-151 double ERFVA13X 152-158 double ERFTR13X 159-165 double ERFOF13X 166-172 double ERFSL13X 173-180 double ERFWC13X 181-187 double ERFOR13X 188-194 double ERFOU13X 195-201 double ERFOT13X 202-209 double ERFXP13X 210-217 double ERFTC13X 218-226 double ERDSF13X 227-233 double ERDMR13X 234-240 double ERDMD13X 241-247 double ERDPV13X 248-254 double ERDVA13X 255-261 double ERDTR13X 262-268 double ERDOF13X 269-272 double ERDSL13X 273-278 double ERDWC13X 279-285 double ERDOR13X 286-292 double ERDOU13X 293-298 double ERDOT13X 299-304 double ERDXP13X 305-311 double ERDTC13X 312-319 byte IMPFLAG 320-320 double PERWT13F 321-332 int VARSTR 333-336 byte VARPSU 337-337 using H160E.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 ERHEVIDX "EVENT ID FOR CORRESPONDING HOSPITAL STAY"; label variable FFEEIDX "FLAT FEE ID"; label variable PANEL "PANEL NUMBER"; label variable MPCDATA "MPC DATA FLAG"; label variable ERDATEYR "EVENT DATE - YEAR"; label variable ERDATEMM "EVENT DATE - MONTH"; label variable VSTCTGRY "BEST CATEGORY FOR CARE P RECV ON VST DT"; label variable VSTRELCN "THIS VST RELATED TO SPEC CONDITION"; label variable LABTEST "THIS VISIT DID P HAVE LAB TESTS"; label variable SONOGRAM "THIS VISIT DID P HAVE SONOGRAM OR ULTRSD"; label variable XRAYS "THIS VISIT DID P HAVE X-RAYS"; label variable MAMMOG "THIS VISIT DID P HAVE A MAMMOGRAM"; label variable MRI "THIS VISIT DID P HAVE AN MRI/CATSCAN"; label variable EKG "THIS VISIT DID P HAVE AN EKG OR ECG"; label variable EEG "THIS VISIT DID P HAVE AN EEG"; label variable RCVVAC "THIS VISIT DID P RECEIVE A VACCINATION"; label variable ANESTH "THIS VISIT DID P RECEIVE ANESTHESIA"; label variable THRTSWAB "THIS VISIT DID P HAVE A THROAT SWAB"; label variable OTHSVCE "THIS VISIT DID P HAVE OTH DIAG TEST/EXAM"; label variable SURGPROC "WAS SURG PROC PERFORMED ON P THIS VISIT"; label variable MEDPRESC "ANY MEDICINE PRESCRIBED FOR P THIS VISIT"; label variable ERCCC1X "MODIFIED CLINICAL CLASSIFICATION CODE"; label variable ERCCC2X "MODIFIED CLINICAL CLASSIFICATION CODE"; label variable ERCCC3X "MODIFIED CLINICAL CLASSIFICATION CODE"; label variable FFERTYPE "FLAT FEE BUNDLE"; label variable ERXP13X "TOT EXP FOR EVENT (ERFXP13X + ERDXP13X)"; label variable ERTC13X "TOTAL CHG FOR EVENT (ERFTC13X+ERDTC13X)"; label variable ERFSF13X "FACILITY AMT PD, FAMILY (IMPUTED)"; label variable ERFMR13X "FACILITY AMT PD, MEDICARE (IMPUTED)"; label variable ERFMD13X "FACILITY AMT PD, MEDICAID (IMPUTED)"; label variable ERFPV13X "FACILITY AMT PD, PRIV INSUR (IMPUTED)"; label variable ERFVA13X "FAC AMT PD,VETERANS/CHAMPVA(IMPUTED)"; label variable ERFTR13X "FACILITY AMT PD,TRICARE(IMPUTED)"; label variable ERFOF13X "FACILITY AMT PD, OTH FEDERAL (IMPUTED)"; label variable ERFSL13X "FACILITY AMT PD, STATE/LOC GOV (IMPUTED)"; label variable ERFWC13X "FACILITY AMT PD, WORKERS COMP (IMPUTED)"; label variable ERFOR13X "FACILITY AMT PD, OTH PRIV (IMPUTED)"; label variable ERFOU13X "FACILITY AMT PD, OTH PUB (IMPUTED)"; label variable ERFOT13X "FACILITY AMT PD, OTH INSUR (IMPUTED)"; label variable ERFXP13X "FACILITY SUM PAYMENTS ERFSF13X-ERFOT13X"; label variable ERFTC13X "TOTAL FACILITY CHARGE (IMPUTED)"; label variable ERDSF13X "DOCTOR AMOUNT PAID, FAMILY (IMPUTED)"; label variable ERDMR13X "DOCTOR AMOUNT PD, MEDICARE (IMPUTED)"; label variable ERDMD13X "DOCTOR AMOUNT PAID, MEDICAID (IMPUTED)"; label variable ERDPV13X "DOCTOR AMT PD, PRIV INSUR (IMPUTED)"; label variable ERDVA13X "DR AMT PD,VETERANS/CHAMPVA(IMPUTED)"; label variable ERDTR13X "DOCTOR AMT PD,TRICARE(IMPUTED)"; label variable ERDOF13X "DOCTOR AMT PAID, OTH FEDERAL (IMPUTED)"; label variable ERDSL13X "DOCTOR AMT PD, STATE/LOC GOV (IMPUTED)"; label variable ERDWC13X "DOCTOR AMOUNT PD, WORKERS COMP (IMPUTED)"; label variable ERDOR13X "DOCTOR AMT PD, OTH PRIVATE (IMPUTED)"; label variable ERDOU13X "DOCTOR AMT PD, OTH PUB (IMPUTED)"; label variable ERDOT13X "DOCTOR AMT PD, OTH INSUR (IMPUTED)"; label variable ERDXP13X "DOCTOR SUM PAYMENTS ERDSF13X - ERDOT13X"; label variable ERDTC13X "TOTAL DOCTOR CHARGE (IMPUTED)"; label variable IMPFLAG "IMPUTATION STATUS"; label variable PERWT13F "EXPENDITURE FILE PERSON WEIGHT, 2013"; label variable VARSTR "VARIANCE ESTIMATION STRATUM, 2013"; label variable VARPSU "VARIANCE ESTIMATION PSU, 2013"; *DEFINE VALUE LABELS FOR REPORTS; label define H160E0001X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" 95 "95 NO SERVICES RECEIVED" ; label define H160E0002X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" 95 "95 NO SERVICES RECEIVED" ; label define H160E0003X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" 95 "95 NO SERVICES RECEIVED" ; label define H160E0004X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" ; label define H160E0005X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 2013 "2013" ; label define H160E0006X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H160E0007X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H160E0008X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H160E0009X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H160E0010X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H160E0011X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H160E0012X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H160E0013X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H160E0014X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H160E0015X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H160E0016X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H160E0017X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H160E0018X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H160E0019X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H160E0020X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H160E0021X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H160E0022X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H160E0023X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H160E0024X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H160E0025X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H160E0026X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H160E0027X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H160E0028X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H160E0029X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H160E0030X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H160E0031X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H160E0032X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H160E0033X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H160E0034X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H160E0035X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H160E0036X 1 "ROUND 1" 2 "ROUND 2" 3 "ROUND 3" 4 "ROUND 4" 5 "ROUND 5" ; label define H160E0037X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 FLAT FEE STEM" 2 "2 FLAT FEE LEAF" ; label define H160E0038X 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 H160E0039X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" 95 "95 NO SERVICES RECEIVED" ; label define H160E0040X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" 95 "95 NO SERVICES RECEIVED" ; label define H160E0041X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H160E0042X 1 "1 HAS MPC DATA" 2 "2 NO MPC DATA" ; label define H160E0043X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" 95 "95 NO SERVICES RECEIVED" ; label define H160E0044X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" 95 "95 NO SERVICES RECEIVED" ; label define H160E0045X 17 "PANEL 17" 18 "PANEL 18" ; label define H160E0046X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" 95 "95 NO SERVICES RECEIVED" ; label define H160E0047X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" 95 "95 NO SERVICES RECEIVED" ; label define H160E0048X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" 95 "95 NO SERVICES RECEIVED" ; label define H160E0049X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" 95 "95 NO SERVICES RECEIVED" ; label define H160E0050X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 DIAGNOSIS OR TREATMENT" 2 "2 EMERGENCY (E.G., ACCIDENT OR INJURY)" 3 "3 PSYCHOTHERAPY/MENTAL HEALTH COUNSELING" 4 "4 FOLLOW-UP OR POST-OPERATIVE VISIT" 5 "5 IMMUNIZATIONS OR SHOTS" 6 "6 PREGNANCY-RELATED (INC PRENATAL/ DELV)" 91 "91 OTHER" ; label define H160E0051X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H160E0052X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" 95 "95 NO SERVICES RECEIVED" ; * ASSOCIATE VARIABLES WITH VALUE LABEL DEFINITIONS; label value ANESTH H160E0001X; label value EEG H160E0002X; label value EKG H160E0003X; label value ERDATEMM H160E0004X; label value ERDATEYR H160E0005X; label value ERDMD13X H160E0006X; label value ERDMR13X H160E0007X; label value ERDOF13X H160E0008X; label value ERDOR13X H160E0009X; label value ERDOT13X H160E0010X; label value ERDOU13X H160E0011X; label value ERDPV13X H160E0012X; label value ERDSF13X H160E0013X; label value ERDSL13X H160E0014X; label value ERDTC13X H160E0015X; label value ERDTR13X H160E0016X; label value ERDVA13X H160E0017X; label value ERDWC13X H160E0018X; label value ERDXP13X H160E0019X; label value ERFMD13X H160E0020X; label value ERFMR13X H160E0021X; label value ERFOF13X H160E0022X; label value ERFOR13X H160E0023X; label value ERFOT13X H160E0024X; label value ERFOU13X H160E0025X; label value ERFPV13X H160E0026X; label value ERFSF13X H160E0027X; label value ERFSL13X H160E0028X; label value ERFTC13X H160E0029X; label value ERFTR13X H160E0030X; label value ERFVA13X H160E0031X; label value ERFWC13X H160E0032X; label value ERFXP13X H160E0033X; label value ERTC13X H160E0034X; label value ERXP13X H160E0035X; label value EVENTRN H160E0036X; label value FFERTYPE H160E0037X; label value IMPFLAG H160E0038X; label value LABTEST H160E0039X; label value MAMMOG H160E0040X; label value MEDPRESC H160E0041X; label value MPCDATA H160E0042X; label value MRI H160E0043X; label value OTHSVCE H160E0044X; label value PANEL H160E0045X; label value RCVVAC H160E0046X; label value SONOGRAM H160E0047X; label value SURGPROC H160E0048X; label value THRTSWAB H160E0049X; label value VSTCTGRY H160E0050X; label value VSTRELCN H160E0051X; label value XRAYS H160E0052X; *DISPLAY A DESCRIPTION OF STATA FILE; describe; *LIST FIRST 20 OBSERVATIONS IN THE FILE; list in 1/20; save H160E, replace; #delimit cr * data file is stored in H160E.dta * log file is stored in H160E.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 H160E.LOG and a data file named H160E.DTA. If these files (H160E.DTA and H160E.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. ************************************************************************************************/