/************************************************************************************************/ /* Stata User File for H33D 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 */ /* (H33D.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 H33D.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\H33D.DO */ /* The program below will output the Stata dataset H33D.DTA */ /************************************************************************************************/ #delimit ; cd C:\MEPS\DATA; log using H33D.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 IPR2FLAG 30-31 str ERHEVIDX 32-43 str FFEEIDX 44-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 SURGPROC 84-85 byte VAPLACE 86-86 str IPICD1X 87-89 str IPICD2X 90-92 str IPICD3X 93-95 str IPICD4X 96-98 str IPPRO1X 99-101 str IPPRO2X 102-104 str IPCCC1X 105-107 str IPCCC2X 108-110 str IPCCC3X 111-113 str IPCCC4X 114-116 byte DSCHPMED 117-118 byte DROUTSID 119-120 byte FFIPTYPE 121-122 double IPXP99X 123-131 double IPTC99X 132-140 double IPFSF99X 141-148 double IPFMR99X 149-157 double IPFMD99X 158-165 double IPFPV99X 166-174 double IPFVA99X 175-183 double IPFCH99X 184-190 double IPFOF99X 191-198 double IPFSL99X 199-205 double IPFWC99X 206-213 double IPFOR99X 214-221 double IPFOU99X 222-229 double IPFOT99X 230-237 double IPFXP99X 238-246 double IPFTC99X 247-255 double IPDSF99X 256-262 double IPDMR99X 263-270 double IPDMD99X 271-278 double IPDPV99X 279-286 double IPDVA99X 287-292 double IPDCH99X 293-299 double IPDOF99X 300-303 double IPDSL99X 304-310 double IPDWC99X 311-317 double IPDOR99X 318-325 double IPDOU99X 326-332 double IPDOT99X 333-338 double IPDXP99X 339-346 double IPDTC99X 347-354 byte IMPFLAG 355-355 double PERWT99F 356-367 byte VARPSU99 368-369 int VARSTR99 370-372 using H33D.dat; *DEFINE VARIABLE LABELS; label variable DUID "DWELLING UNIT ID"; label variable PID "NUMERIC PID"; label variable DUPERSID "PERSON ID (DUID+PID)"; label variable EVNTIDX "EVENT ID"; label variable EVENTRN "EVENT ROUND NUMBER"; label variable IPR2FLAG "FLAG FOR PANEL 3 R2 EVENT IN 1999"; label variable ERHEVIDX "ER/HS LINK ID"; label variable FFEEIDX "FLAT FEE ID"; label variable MPCDATA "MPC DATA FLAG"; label variable IPBEGYR "EVENT START DATE - YEAR (4-DIGIT)"; label variable IPBEGMM "EVENT START DATE - MONTH"; label variable IPBEGDD "EVENT START DATE - DAY"; label variable IPENDYR "EVENT END DATE - YEAR (4-DIGIT)"; label variable IPENDMM "EVENT END DATE - MONTH"; label variable IPENDDD "EVENT END DATE - DAY"; label variable NUMNIGHX "# NGTS IN HOSP - 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 SURGPROC "MAIN SURGICAL PROCEDURE"; label variable VAPLACE "VA FACILITY FLAG"; label variable IPICD1X "3 DIGIT ICD-9 CONDITION CODE"; label variable IPICD2X "3 DIGIT ICD-9 CONDITION CODE"; label variable IPICD3X "3 DIGIT ICD-9 CONDITION CODE"; label variable IPICD4X "3 DIGIT ICD-9 CONDITION CODE"; label variable IPPRO1X "2 DIGIT ICD-9 PROCEDURE CODE"; label variable IPPRO2X "2 DIGIT ICD-9 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 DROUTSID "ANY OF THE DRS SEEN OUTSIDE THE PROVIDER"; label variable FFIPTYPE "FLAT FEE BUNDLE"; label variable IPXP99X "TOT EXP FOR EVENT(IPFXP99X+IPDXP99X)"; label variable IPTC99X "TOT CHG FOR EVENT(IPFTC99X+IPDTC99X)"; label variable IPFSF99X "FACILITY AMT PD, FAMILY (IMPUTED)"; label variable IPFMR99X "FACILITY AMT PD, MEDICARE (IMPUTED)"; label variable IPFMD99X "FACILITY AMT PD, MEDICAID (IMPUTED)"; label variable IPFPV99X "FACILITY AMT PD, PRIV INSUR (IMPUTED)"; label variable IPFVA99X "FACILITY AMT PD, VETERANS (IMPUTED)"; label variable IPFCH99X "FACILITY AMT PD, CHAMP/CHAMPVA (IMPUTED)"; label variable IPFOF99X "FACILITY AMT PD, OTH FEDERAL (IMPUTED)"; label variable IPFSL99X "FACILITY AMT PD, STATE/LOC GOV (IMPUTED)"; label variable IPFWC99X "FACILITY AMT PD, WORKERS COMP (IMPUTED)"; label variable IPFOR99X "FACILITY AMT PD, OTH PRIV (IMPUTED)"; label variable IPFOU99X "FACILITY AMT PD, OTH PUB (IMPUTED)"; label variable IPFOT99X "FACILITY AMT PD, OTH INSUR (IMPUTED)"; label variable IPFXP99X "FACILITY SUM PAYMENTS IPFSF99X-IPFOT99X"; label variable IPFTC99X "TOTAL FACILITY CHARGE(IMPUTED)"; label variable IPDSF99X "DOCTOR AMT PD, FAMILY (IMPUTED)"; label variable IPDMR99X "DOCTOR AMT PD, MEDICARE (IMPUTED)"; label variable IPDMD99X "DOCTOR AMT PD, MEDICAID (IMPUTED)"; label variable IPDPV99X "DOCTOR AMT PD, PRIV INSUR (IMPUTED)"; label variable IPDVA99X "DOCTOR AMT PD, VETERANS (IMPUTED)"; label variable IPDCH99X "DOCTOR AMT PD, CHAMP/CHAMPVA (IMPUTED)"; label variable IPDOF99X "DOCTOR AMT PD, OTH FEDERAL (IMPUTED)"; label variable IPDSL99X "DOCTOR AMT PD, STATE/LOC GOV (IMPUTED)"; label variable IPDWC99X "DOCTOR AMT PD, WORKERS COMP (IMPUTED)"; label variable IPDOR99X "DOCTOR AMT PD, OTH PRIV (IMPUTED)"; label variable IPDOU99X "DOCTOR AMT PD, OTH PUB (IMPUTED)"; label variable IPDOT99X "DOCTOR AMT PD, OTH INSUR (IMPUTED)"; label variable IPDXP99X "DOCTOR SUM PAYMENTS IPDSF99X-IPDOT99X"; label variable IPDTC99X "TOTAL DOCTOR CHARGE(IMPUTED)"; label variable IMPFLAG "IMPUTATION STATUS"; label variable PERWT99F "FINAL PERSON LEVEL WEIGHT, 1999"; label variable VARPSU99 "VARIANCE ESTIMATION PSU,1999"; label variable VARSTR99 "VARIANCE ESTIMATION STRATUM,1999"; *DEFINE VALUE LABELS FOR REPORTS; label define H33D0001X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H33D0002X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H33D0003X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H33D0004X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" ; label define H33D0005X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H33D0006X 1 "1 ROUND 1" 2 "2 ROUND 2" 3 "3 ROUND 3" 4 "4 ROUND 4" 5 "5 ROUND 5" ; label define H33D0007X -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 H33D0008X -1 "-1 INAPPLICABLE" -2 "-2 DETERMINED IN PREVIOUS ROUND" -3 "-3 NO DATA IN ROUND" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 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 H33D0009X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" ; label define H33D0010X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" ; label define H33D0011X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1997 "1997" 1998 "1998" 1999 "1999" ; label define H33D0012X 0 "0" 536 "$536.01 - $536.00" ; label define H33D0013X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" ; label define H33D0014X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 95 "95 STILL IN HOSPITAL" ; label define H33D0015X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1997 "1997" 1998 "1998" 1999 "1999" ; label define H33D0016X 0 "0" 1166.68 "$1166.68 - $1166.68" ; label define H33D0017X -1 "-1 NO R2 CROSSOVER PROBLEM" -2 "-2 DETERMINED IN PREVIOUS ROUND" -3 "-3 NO DATA IN ROUND" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 PANEL3 R2 EVENT IN 1999" ; label define H33D0018X 1 "1 HAS MPC DATA" 2 "2 NO MPC DATA" ; label define H33D0019X -1 "-1 INAPPLICABLE" -2 "-2 DETERMINED IN PREVIOUS ROUND" -3 "-3 NO DATA IN ROUND" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H33D0020X -1 "-1 INAPPLICABLE" -2 "-2 DETERMINED IN PREVIOUS ROUND" -3 "-3 NO DATA IN ROUND" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H33D0021X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" ; label define H33D0022X -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 H33D0023X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H33D0024X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 APPENDECTOMY" 10 "10 HERNIA REPAIR" 11 "11 HYSTERECTOMY" 12 "12 JOINT (HIP/KNEE) REPLACEMENT SURGERY" 13 "13 MASTECTOMY/LUMPECTOMY" 14 "14 PACEMAKER INSERTION" 15 "15 PLASTIC/RECONSTRUCTIVE SURGERY" 16 "16 PROSTATE SURGERY (PROSTATECTOMY)" 17 "17 SPINAL DISC SURGERY (SLIPPED/PROLAPSED)" 18 "18 SURGICAL SETTING OF BROKEN BONE" 19 "19 THYROID SURGERY (THYROIDECTOMY)" 2 "2 ARTHROSCOPIC SURGERY (VISUAL OF JOINTS)" 20 "20 TISSUE BIOPSY" 21 "21 TONSILLECTOMY" 3 "3 CARDIAC CATHETERIZATION" 4 "4 CATARACT SURGERY" 5 "5 CIRCUMCISION" 6 "6 CORONARY BYPASS" 7 "7 D AND C (DILATION AND CURETTAGE)" 8 "8 DENTAL SURGERY" 9 "9 GALLBLADDER SURGERY (CHOLECYSTECTOMY)" 91 "91 OTHER" ; label define H33D0025X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 0 "0 NO" 1 "1 YES" ; label define H33D0026X -1 "-1 INAPPLICABLE" -2 "-2 DETERMINED IN PREVIOUS ROUND" -3 "-3 NO DATA IN ROUND" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H33D0027X -1 "-1 INAPPLICABLE" -2 "-2 DETERMINED IN PREVIOUS ROUND" -3 "-3 NO DATA IN ROUND" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 0 "0" ; * ASSOCIATE VARIABLES WITH VALUE LABEL DEFINITIONS; label value ANYOPER H33D0001X; label value DROUTSID H33D0002X; label value DSCHPMED H33D0003X; label value DUID H33D0004X; label value EMERROOM H33D0005X; label value EVENTRN H33D0006X; label value FFIPTYPE H33D0007X; label value IMPFLAG H33D0008X; label value IPBEGDD H33D0009X; label value IPBEGMM H33D0010X; label value IPBEGYR H33D0011X; label value IPDOT99X H33D0012X; label value IPENDDD H33D0013X; label value IPENDMM H33D0014X; label value IPENDYR H33D0015X; label value IPFCH99X H33D0016X; label value IPR2FLAG H33D0017X; label value MPCDATA H33D0018X; label value NUMNIGHT H33D0019X; label value NUMNIGHX H33D0020X; label value PID H33D0021X; label value RSNINHOS H33D0022X; label value SPECCOND H33D0023X; label value SURGPROC H33D0024X; label value VAPLACE H33D0025X; label value VARPSU99 H33D0026X; label value VARSTR99 H33D0027X; *DISPLAY A DESCRIPTION OF STATA FILE; describe; *LIST FIRST 20 OBSERVATIONS IN THE FILE; list in 1/20; save H33D, replace; #delimit cr * data file is stored in H33D.dta * log file is stored in H33D.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 H33D.LOG and a data file named H33D.DTA. If these files (H33D.DTA and H33D.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. ************************************************************************************************/