/************************************************************************************************/ /* Stata User File for H26D 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 */ /* (H26D.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 H26D.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\H26D.DO */ /* The program below will output the Stata dataset H26D.DTA */ /************************************************************************************************/ #delimit ; cd C:\MEPS\DATA; log using H26DF1.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-51 byte MPCDATA 52-52 int IPBEGYR 53-56 byte IPBEGMM 57-58 byte IPBEGDD 59-60 int IPENDYR 61-64 byte IPENDMM 65-66 byte IPENDDD 67-68 int NUMNIGHX 69-71 byte NUMNIGHT 72-73 byte EMERROOM 74-75 byte SPECCOND 76-77 byte RSNINHOS 78-79 byte ANYOPER 80-81 byte SURGPROC 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-99 str IPPRO2X 100-102 str IPCCC1X 103-105 str IPCCC2X 106-108 str IPCCC3X 109-111 str IPCCC4X 112-114 byte DSCHPMED 115-116 byte DROUTSID 117-118 byte FFIPTYPE 119-120 byte FFBEF98 121-122 byte FFTOT99 123-124 double IPXP98X 125-133 double IPTC98X 134-142 double IPFSF98X 143-150 double IPFMR98X 151-159 double IPFMD98X 160-167 double IPFPV98X 168-176 double IPFVA98X 177-184 double IPFCH98X 185-192 double IPFOF98X 193-200 double IPFSL98X 201-207 double IPFWC98X 208-215 double IPFOR98X 216-224 double IPFOU98X 225-232 double IPFOT98X 233-240 double IPFXP98X 241-249 double IPFTC98X 250-258 double IPDSF98X 259-265 double IPDMR98X 266-273 double IPDMD98X 274-280 double IPDPV98X 281-288 double IPDVA98X 289-294 double IPDCH98X 295-300 double IPDOF98X 301-306 double IPDSL98X 307-312 double IPDWC98X 313-319 double IPDOR98X 320-327 double IPDOU98X 328-334 double IPDOT98X 335-340 double IPDXP98X 341-348 double IPDTC98X 349-356 double WTDPER98 357-368 byte VARPSU98 369-370 int VARSTR98 371-373 using H26DF1.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 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 FFBEF98 "TOTAL # OF VISITS IN FF BEFORE 1998"; label variable FFTOT99 "TOTAL # OF VISITS IN FF AFTER 1998"; label variable IPXP98X "TOT EXP FOR EVENT(IPFXP98X+IPDXP98X)"; label variable IPTC98X "TOT CHG FOR EVENT(IPFTC98X+IPDTC98X)"; label variable IPFSF98X "FACILITY AMT PD, FAMILY (IMPUTED)"; label variable IPFMR98X "FACILITY AMT PD, MEDICARE (IMPUTED)"; label variable IPFMD98X "FACILITY AMT PD, MEDICAID (IMPUTED)"; label variable IPFPV98X "FACILITY AMT PD, PRIV INSUR (IMPUTED)"; label variable IPFVA98X "FACILITY AMT PD, VETERANS (IMPUTED)"; label variable IPFCH98X "FACILITY AMT PD, CHAMP/CHAMPVA (IMPUTED)"; label variable IPFOF98X "FACILITY AMT PD, OTH FEDERAL (IMPUTED)"; label variable IPFSL98X "FACILITY AMT PD, STATE/LOC GOV (IMPUTED)"; label variable IPFWC98X "FACILITY AMT PD, WORKERS COMP (IMPUTED)"; label variable IPFOR98X "FACILITY AMT PD, OTH PRIV (IMPUTED)"; label variable IPFOU98X "FACILITY AMT PD, OTH PUB (IMPUTED)"; label variable IPFOT98X "FACILITY AMT PD, OTH INSUR (IMPUTED)"; label variable IPFXP98X "FACILITY SUM PAYMENTS IPFSF98X-IPFOT98X"; label variable IPFTC98X "TOTAL FACILITY CHARGE(IMPUTED)"; label variable IPDSF98X "DOCTOR AMT PD, FAMILY (IMPUTED)"; label variable IPDMR98X "DOCTOR AMT PD, MEDICARE (IMPUTED)"; label variable IPDMD98X "DOCTOR AMT PD, MEDICAID (IMPUTED)"; label variable IPDPV98X "DOCTOR AMT PD, PRIV INSUR (IMPUTED)"; label variable IPDVA98X "DOCTOR AMT PD, VETERANS (IMPUTED)"; label variable IPDCH98X "DOCTOR AMT PD, CHAMP/CHAMPVA (IMPUTED)"; label variable IPDOF98X "DOCTOR AMT PD, OTH FEDERAL (IMPUTED)"; label variable IPDSL98X "DOCTOR AMT PD, STATE/LOC GOV (IMPUTED)"; label variable IPDWC98X "DOCTOR AMT PD, WORKERS COMP (IMPUTED)"; label variable IPDOR98X "DOCTOR AMT PD, OTH PRIV (IMPUTED)"; label variable IPDOU98X "DOCTOR AMT PD, OTH PUB (IMPUTED)"; label variable IPDOT98X "DOCTOR AMT PD, OTH INSUR (IMPUTED)"; label variable IPDXP98X "DOCTOR SUM PAYMENTS IPDSF98X-IPDOT98X"; label variable IPDTC98X "TOTAL DOCTOR CHARGE(IMPUTED)"; label variable WTDPER98 "POVERTY/MORTALITY/NH ADJ PERS LVL WGT 98"; label variable VARPSU98 "VARIANCE ESTIMATION PSU,1998"; label variable VARSTR98 "VARIANCE ESTIMATION STRATUM,1998"; *DEFINE VALUE LABELS FOR REPORTS; label define H26DF10001X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H26DF10002X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H26DF10003X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H26DF10004X -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" ; label define H26DF10005X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H26DF10006X 1 "1 ROUND 1" 2 "2 ROUND 2" 3 "3 ROUND 3" 4 "4 ROUND 4" 5 "5 ROUND 5" ; label define H26DF10007X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 0 "0 NO FLAT FEE VISITS PRIOR TO 1998" ; label define H26DF10008X -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 H26DF10009X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H26DF10010X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" ; label define H26DF10011X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" ; label define H26DF10012X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1995 "1995" 1996 "1996" 1997 "1997" 1998 "1998" 1999 "1999" 95 "1995" 96 "1996" 97 "1997" ; label define H26DF10013X -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H26DF10014X -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H26DF10015X -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H26DF10016X -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H26DF10017X -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H26DF10018X -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H26DF10019X -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H26DF10020X -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H26DF10021X -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H26DF10022X -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H26DF10023X -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H26DF10024X -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H26DF10025X -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H26DF10026X -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H26DF10027X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" ; label define H26DF10028X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 95 "95 STILL IN HOSPITAL" ; label define H26DF10029X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1995 "1995" 1996 "1996" 1997 "1997" 1998 "1998" 1999 "1999" 95 "1995" 96 "1996" 97 "1997" ; label define H26DF10030X -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H26DF10031X -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H26DF10032X -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H26DF10033X -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H26DF10034X -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H26DF10035X -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H26DF10036X -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H26DF10037X -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H26DF10038X -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H26DF10039X -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H26DF10040X -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H26DF10041X -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H26DF10042X -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H26DF10043X -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H26DF10044X -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H26DF10045X -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H26DF10046X 1 "1 HAS MPC DATA" 2 "2 NO MPC DATA" ; label define H26DF10047X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" ; label define H26DF10048X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H26DF10049X -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" ; label define H26DF10050X -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 H26DF10051X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H26DF10052X -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 H26DF10053X -1 "-1 INAPPLICABLE" 0 "0 NO" 1 "1 YES" ; * ASSOCIATE VARIABLES WITH VALUE LABEL DEFINITIONS; label value ANYOPER H26DF10001X; label value DROUTSID H26DF10002X; label value DSCHPMED H26DF10003X; label value DUID H26DF10004X; label value EMERROOM H26DF10005X; label value EVENTRN H26DF10006X; label value FFBEF98 H26DF10007X; label value FFIPTYPE H26DF10008X; label value FFTOT99 H26DF10009X; label value IPBEGDD H26DF10010X; label value IPBEGMM H26DF10011X; label value IPBEGYR H26DF10012X; label value IPDCH98X H26DF10013X; label value IPDMD98X H26DF10014X; label value IPDMR98X H26DF10015X; label value IPDOF98X H26DF10016X; label value IPDOR98X H26DF10017X; label value IPDOT98X H26DF10018X; label value IPDOU98X H26DF10019X; label value IPDPV98X H26DF10020X; label value IPDSF98X H26DF10021X; label value IPDSL98X H26DF10022X; label value IPDTC98X H26DF10023X; label value IPDVA98X H26DF10024X; label value IPDWC98X H26DF10025X; label value IPDXP98X H26DF10026X; label value IPENDDD H26DF10027X; label value IPENDMM H26DF10028X; label value IPENDYR H26DF10029X; label value IPFCH98X H26DF10030X; label value IPFMD98X H26DF10031X; label value IPFMR98X H26DF10032X; label value IPFOF98X H26DF10033X; label value IPFOR98X H26DF10034X; label value IPFOT98X H26DF10035X; label value IPFOU98X H26DF10036X; label value IPFPV98X H26DF10037X; label value IPFSF98X H26DF10038X; label value IPFSL98X H26DF10039X; label value IPFTC98X H26DF10040X; label value IPFVA98X H26DF10041X; label value IPFWC98X H26DF10042X; label value IPFXP98X H26DF10043X; label value IPTC98X H26DF10044X; label value IPXP98X H26DF10045X; label value MPCDATA H26DF10046X; label value NUMNIGHT H26DF10047X; label value NUMNIGHX H26DF10048X; label value PID H26DF10049X; label value RSNINHOS H26DF10050X; label value SPECCOND H26DF10051X; label value SURGPROC H26DF10052X; label value VAPLACE H26DF10053X; *DISPLAY A DESCRIPTION OF STATA FILE; describe; *LIST FIRST 20 OBSERVATIONS IN THE FILE; list in 1/20; save H26DF1, replace; #delimit cr * data file is stored in H26DF1.dta * log file is stored in H26DF1.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 H26D.LOG and a data file named H26D.DTA. If these files (H26D.DTA and H26D.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. ************************************************************************************************/