/************************************************************************************************/ /* Stata User File for H59D 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 */ /* (H59D.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 H59D.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\H59D.DO */ /* The program below will output the Stata dataset H59D.DTA */ /************************************************************************************************/ #delimit ; cd C:\MEPS\DATA; log using H59D.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 MPCDATA 54-54 int IPBEGYR 55-58 byte IPBEGMM 59-60 byte IPBEGDD 61-62 int IPENDYR 63-66 byte IPENDMM 67-68 byte IPENDDD 69-70 int NUMNIGHX 71-73 byte NUMNIGHT 74-75 byte EMERROOM 76-77 byte SPECCOND 78-79 byte RSNINHOS 80-81 byte ANYOPER 82-83 byte VAPLACE 84-84 str IPICD1X 85-87 str IPICD2X 88-90 str IPICD3X 91-93 str IPICD4X 94-96 str IPPRO1X 97-98 str IPPRO2X 99-100 str IPCCC1X 101-103 str IPCCC2X 104-106 str IPCCC3X 107-109 str IPCCC4X 110-112 byte DSCHPMED 113-114 byte FFIPTYPE 115-116 byte FFTOT02 117-118 double IPXP01X 119-127 double IPTC01X 128-136 double IPFSF01X 137-143 double IPFMR01X 144-152 double IPFMD01X 153-160 double IPFPV01X 161-169 double IPFVA01X 170-177 double IPFTR01X 178-185 double IPFOF01X 186-192 double IPFSL01X 193-200 double IPFWC01X 201-208 double IPFOR01X 209-216 double IPFOU01X 217-224 double IPFOT01X 225-232 double IPFXP01X 233-241 double IPFTC01X 242-250 double IPDSF01X 251-257 double IPDMR01X 258-265 double IPDMD01X 266-272 double IPDPV01X 273-280 double IPDVA01X 281-287 double IPDTR01X 288-294 double IPDOF01X 295-299 double IPDSL01X 300-305 double IPDWC01X 306-312 double IPDOR01X 313-320 double IPDOU01X 321-327 double IPDOT01X 328-334 double IPDXP01X 335-342 double IPDTC01X 343-350 byte IMPFLAG 351-351 double PERWT01F 352-363 int VARSTR01 364-366 byte VARPSU01 367-368 using H59D.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 EMER RM VISIT"; label variable FFEEIDX "FLAT FEE ID"; label variable MPCDATA "MPC DATA FLAG"; label variable IPBEGYR "EVENT START DATE - YEAR"; label variable IPBEGMM "EVENT START DATE - MONTH"; label variable IPBEGDD "EVENT START DATE - DAY"; label variable IPENDYR "EVENT END DATE - YEAR"; label variable IPENDMM "EVENT END DATE - MONTH"; label variable IPENDDD "EVENT END DATE - DAY"; label variable NUMNIGHX "# OF NIGHTS IN HOSPITAL - EDITED/IMPUTED"; label variable NUMNIGHT "NUMBER OF NIGHTS STAYED AT PROVIDER"; label variable EMERROOM "DID STAY BEGIN WITH EMERGENCY ROOM VISIT"; label variable SPECCOND "HOSPITAL STAY RELATED TO CONDITION"; label variable RSNINHOS "REASON ENTERED HOSPITAL"; label variable ANYOPER "ANY OPERATIONS OR SURGERIES PERFORMED"; label variable VAPLACE "VA FACILITY FLAG"; label variable IPICD1X "3-DIGIT ICD-9-CM CONDITION CODE"; label variable IPICD2X "3-DIGIT ICD-9-CM CONDITION CODE"; label variable IPICD3X "3-DIGIT ICD-9-CM CONDITION CODE"; label variable IPICD4X "3-DIGIT ICD-9-CM CONDITION CODE"; label variable IPPRO1X "2-DIGIT ICD-9-CM PROCEDURE CODE"; label variable IPPRO2X "2-DIGIT ICD-9-CM PROCEDURE CODE"; label variable IPCCC1X "MODIFIED CLINICAL CLASSIFICATION CODE"; label variable IPCCC2X "MODIFIED CLINICAL CLASSIFICATION CODE"; label variable IPCCC3X "MODIFIED CLINICAL CLASSIFICATION CODE"; label variable IPCCC4X "MODIFIED CLINICAL CLASSIFICATION CODE"; label variable DSCHPMED "MEDICINES PRESCRIBED AT DISCHARGE"; label variable FFIPTYPE "FLAT FEE BUNDLE"; label variable FFTOT02 "TOTAL # OF VISITS IN FF AFTER 2001"; label variable IPXP01X "TOT EXP FOR EVENT (IPFXP01X+IPDXP01X)"; label variable IPTC01X "TOTAL CHG FOR EVENT (IPFTC01X+IPDTC01X)"; label variable IPFSF01X "FACILITY AMT PD, FAMILY (IMPUTED)"; label variable IPFMR01X "FACILITY AMT PD, MEDICARE (IMPUTED)"; label variable IPFMD01X "FACILITY AMT PD, MEDICAID (IMPUTED)"; label variable IPFPV01X "FACILITY AMT PD, PRIV INSUR (IMPUTED)"; label variable IPFVA01X "FACILITY AMT PD, VETERANS (IMPUTED)"; label variable IPFTR01X "FACILITY AMT PD, TRICARE (IMPUTED)"; label variable IPFOF01X "FACILITY AMT PD, OTH FEDERAL (IMPUTED)"; label variable IPFSL01X "FACILITY AMT PD, STATE/LOC GOV (IMPUTED)"; label variable IPFWC01X "FACILITY AMT PD, WORKERS COMP (IMPUTED)"; label variable IPFOR01X "FACILITY AMT PD, OTH PRIV (IMPUTED)"; label variable IPFOU01X "FACILITY AMT PD, OTH PUB (IMPUTED)"; label variable IPFOT01X "FACILITY AMT PD, OTH INSUR (IMPUTED)"; label variable IPFXP01X "FACILITY SUM PAYMENTS IPFSF01X-IPFOT01X"; label variable IPFTC01X "TOTAL FACILITY CHARGE (IMPUTED)"; label variable IPDSF01X "DOCTOR AMOUNT PD, FAMILY (IMPUTED)"; label variable IPDMR01X "DOCTOR AMOUNT PD, MEDICARE (IMPUTED)"; label variable IPDMD01X "DOCTOR AMOUNT PAID, MEDICAID (IMPUTED)"; label variable IPDPV01X "DOCTOR AMT PD, PRIV INSUR (IMPUTED)"; label variable IPDVA01X "DOCTOR AMOUNT PD, VETERANS (IMPUTED)"; label variable IPDTR01X "DOCTOR AMOUNT PD, TRICARE (IMPUTED)"; label variable IPDOF01X "DOCTOR AMT PD, OTH FEDERAL (IMPUTED)"; label variable IPDSL01X "DOCTOR AMT PD, STATE/LOC GOV (IMPUTED)"; label variable IPDWC01X "DOCTOR AMOUNT PD, WORKERS COMP (IMPUTED)"; label variable IPDOR01X "DOCTOR AMT PD, OTH PRIVATE (IMPUTED)"; label variable IPDOU01X "DOCTOR AMT PD, OTH PUB (IMPUTED)"; label variable IPDOT01X "DOCTOR AMT PD, OTH INSUR (IMPUTED)"; label variable IPDXP01X "DOCTOR SUM PAYMENTS IPDSF01X-IPDOT01X"; label variable IPDTC01X "TOTAL DOCTOR CHARGE (IMPUTED)"; label variable IMPFLAG "IMPUTATION STATUS"; label variable PERWT01F "FINAL PERSON LEVEL WEIGHT, 2001"; label variable VARSTR01 "VARIANCE ESTIMATION STRATUM, 2001"; label variable VARPSU01 "VARIANCE ESTIMATION PSU, 2001"; *DEFINE VALUE LABELS FOR REPORTS; label define H59D0001X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H59D0002X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H59D0003X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H59D0004X 1 "ROUND 1" 2 "ROUND 2" 3 "ROUND 3" 4 "ROUND 4" 5 "ROUND 5" ; label define H59D0005X -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 H59D0006X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 0 "0" 1 "1" ; label define H59D0007X 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 H59D0008X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" ; label define H59D0009X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" ; label define H59D0010X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 2000 "2000" 2001 "2001" ; label define H59D0011X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H59D0012X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H59D0013X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 0 "0" 50.33 "$50.33" ; label define H59D0014X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H59D0015X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H59D0016X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H59D0017X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H59D0018X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H59D0019X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H59D0020X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H59D0021X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H59D0022X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H59D0023X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H59D0024X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H59D0025X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" ; label define H59D0026X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" ; label define H59D0027X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 2000 "2000" 2001 "2001" ; label define H59D0028X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H59D0029X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H59D0030X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H59D0031X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H59D0032X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H59D0033X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H59D0034X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H59D0035X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H59D0036X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H59D0037X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H59D0038X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H59D0039X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H59D0040X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H59D0041X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H59D0042X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H59D0043X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H59D0044X 1 "1 HAS MPC DATA" 2 "2 NO MPC DATA" ; label define H59D0045X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" ; label define H59D0046X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 0 "0 NUMBER OF NIGHTS" ; label define H59D0047X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 OPERATION OR SURGICAL PROCEDURE" 2 "2 TREATMENT/THERAPY" 3 "3 DIAGNOSTIC TESTS ONLY" 4 "4 GIVE BIRTH TO A BABY (MOTHER)" 5 "5 TO BE BORN (BABY)" 91 "91 OTHER (SPECIFY)" ; label define H59D0048X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H59D0049X -1 "-1 INAPPLICABLE" 0 "0 NO" 1 "1 YES" ; * ASSOCIATE VARIABLES WITH VALUE LABEL DEFINITIONS; label value ANYOPER H59D0001X; label value DSCHPMED H59D0002X; label value EMERROOM H59D0003X; label value EVENTRN H59D0004X; label value FFIPTYPE H59D0005X; label value FFTOT02 H59D0006X; label value IMPFLAG H59D0007X; label value IPBEGDD H59D0008X; label value IPBEGMM H59D0009X; label value IPBEGYR H59D0010X; label value IPDMD01X H59D0011X; label value IPDMR01X H59D0012X; label value IPDOF01X H59D0013X; label value IPDOR01X H59D0014X; label value IPDOT01X H59D0015X; label value IPDOU01X H59D0016X; label value IPDPV01X H59D0017X; label value IPDSF01X H59D0018X; label value IPDSL01X H59D0019X; label value IPDTC01X H59D0020X; label value IPDTR01X H59D0021X; label value IPDVA01X H59D0022X; label value IPDWC01X H59D0023X; label value IPDXP01X H59D0024X; label value IPENDDD H59D0025X; label value IPENDMM H59D0026X; label value IPENDYR H59D0027X; label value IPFMD01X H59D0028X; label value IPFMR01X H59D0029X; label value IPFOF01X H59D0030X; label value IPFOR01X H59D0031X; label value IPFOT01X H59D0032X; label value IPFOU01X H59D0033X; label value IPFPV01X H59D0034X; label value IPFSF01X H59D0035X; label value IPFSL01X H59D0036X; label value IPFTC01X H59D0037X; label value IPFTR01X H59D0038X; label value IPFVA01X H59D0039X; label value IPFWC01X H59D0040X; label value IPFXP01X H59D0041X; label value IPTC01X H59D0042X; label value IPXP01X H59D0043X; label value MPCDATA H59D0044X; label value NUMNIGHT H59D0045X; label value NUMNIGHX H59D0046X; label value RSNINHOS H59D0047X; label value SPECCOND H59D0048X; label value VAPLACE H59D0049X; *DISPLAY A DESCRIPTION OF STATA FILE; describe; *LIST FIRST 20 OBSERVATIONS IN THE FILE; list in 1/20; save H59D, replace; #delimit cr * data file is stored in H59D.dta * log file is stored in H59D.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 H59D.LOG and a data file named H59D.DTA. If these files (H59D.DTA and H59D.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. ************************************************************************************************/