/************************************************************************************************/ /* Stata User File for H59G 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 */ /* (H59G.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 H59G.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\H59G.DO */ /* The program below will output the Stata dataset H59G.DTA */ /************************************************************************************************/ #delimit ; cd C:\MEPS\DATA; log using H59G.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 FFEEIDX 30-41 byte MPCELIG 42-42 byte MPCDATA 43-43 int OBDATEYR 44-47 byte OBDATEMM 48-49 byte OBDATEDD 50-51 byte SEETLKPV 52-53 byte SEEDOC 54-55 byte MEDPTYPE 56-57 byte DOCATLOC 58-59 byte VSTCTGRY 60-61 byte VSTRELCN 62-63 byte PHYSTH 64-65 byte OCCUPTH 66-67 byte SPEECHTH 68-69 byte CHEMOTH 70-71 byte RADIATTH 72-73 byte KIDNEYD 74-75 byte IVTHER 76-77 byte DRUGTRT 78-79 byte RCVSHOT 80-81 byte PSYCHOTH 82-83 byte LABTEST 84-85 byte SONOGRAM 86-87 byte XRAYS 88-89 byte MAMMOG 90-91 byte MRI 92-93 byte EKG 94-95 byte EEG 96-97 byte RCVVAC 98-99 byte ANESTH 100-101 byte OTHSVCE 102-103 byte SURGPROC 104-105 byte MEDPRESC 106-107 byte VAPLACE 108-108 str OBICD1X 109-111 str OBICD2X 112-114 str OBICD3X 115-117 str OBICD4X 118-120 str OBPRO1X 121-122 str OBCCC1X 123-125 str OBCCC2X 126-128 str OBCCC3X 129-131 str OBCCC4X 132-134 byte FFOBTYPE 135-136 byte FFBEF01 137-138 byte FFTOT02 139-140 double OBSF01X 141-148 double OBMR01X 149-156 double OBMD01X 157-164 double OBPV01X 165-172 double OBVA01X 173-179 double OBTR01X 180-186 double OBOF01X 187-193 double OBSL01X 194-200 double OBWC01X 201-207 double OBOR01X 208-215 double OBOU01X 216-223 double OBOT01X 224-230 double OBXP01X 231-238 double OBTC01X 239-246 byte IMPFLAG 247-247 double PERWT01F 248-259 int VARSTR01 260-262 byte VARPSU01 263-264 using H59G.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 FFEEIDX "FLAT FEE ID"; label variable MPCELIG "MPC ELIGIBILITY FLAG"; label variable MPCDATA "MPC DATA FLAG"; label variable OBDATEYR "EVENT DATE - YEAR"; label variable OBDATEMM "EVENT DATE - MONTH"; label variable OBDATEDD "EVENT DATE - DAY"; label variable SEETLKPV "DID P VISIT PROV IN PERSON OR TELEPHONE"; label variable SEEDOC "DID P TALK TO MD THIS VISIT/PHONE CALL"; label variable MEDPTYPE "TYPE OF MED PERSON P TALKED TO ON VST DT"; label variable DOCATLOC "ANY MD WORK AT LOCATION WHERE P SAW PROV"; label variable VSTCTGRY "BEST CATEGORY FOR CARE P RECV ON VST DT"; label variable VSTRELCN "THIS VST/PHONE CALL RELATED TO SPEC COND"; label variable PHYSTH "THIS VISIT DID P HAVE PHYSICAL THERAPY"; label variable OCCUPTH "THIS VIS DID P HAVE OCCUPATIONAL THERAPY"; label variable SPEECHTH "THIS VISIT DID P HAVE SPEECH THERAPY"; label variable CHEMOTH "THIS VISIT DID P HAVE CHEMOTHERAPY"; label variable RADIATTH "THIS VISIT DID P HAVE RADIATION THERAPY"; label variable KIDNEYD "THIS VISIT DID P HAVE KIDNEY DIALYSIS"; label variable IVTHER "THIS VISIT DID P HAVE IV THERAPY"; label variable DRUGTRT "THIS VIS DID P HAVE TRT FOR DRUG/ALCOHOL"; label variable RCVSHOT "THIS VISIT DID P RECEIVE AN ALLERGY SHOT"; label variable PSYCHOTH "DID P HAVE PSYCHOTHERAPY/COUNSELING"; 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 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 VAPLACE "VA FACILITY FLAG"; label variable OBICD1X "3-DIGIT ICD-9-CM CONDITION CODE"; label variable OBICD2X "3-DIGIT ICD-9-CM CONDITION CODE"; label variable OBICD3X "3-DIGIT ICD-9-CM CONDITION CODE"; label variable OBICD4X "3-DIGIT ICD-9-CM CONDITION CODE"; label variable OBPRO1X "2-DIGIT ICD-9-CM PROCEDURE CODE"; label variable OBCCC1X "MODIFIED CLINICAL CLASSIFICATION CODE"; label variable OBCCC2X "MODIFIED CLINICAL CLASSIFICATION CODE"; label variable OBCCC3X "MODIFIED CLINICAL CLASSIFICATION CODE"; label variable OBCCC4X "MODIFIED CLINICAL CLASSIFICATION CODE"; label variable FFOBTYPE "FLAT FEE BUNDLE"; label variable FFBEF01 "TOTAL # OF VISITS IN FF BEFORE 2001"; label variable FFTOT02 "TOTAL # OF VISITS IN FF AFTER 2001"; label variable OBSF01X "AMOUNT PAID, FAMILY (IMPUTED)"; label variable OBMR01X "AMOUNT PAID, MEDICARE (IMPUTED)"; label variable OBMD01X "AMOUNT PAID, MEDICAID (IMPUTED)"; label variable OBPV01X "AMOUNT PAID, PRIVATE INSURANCE (IMPUTED)"; label variable OBVA01X "AMOUNT PAID, VETERANS (IMPUTED)"; label variable OBTR01X "AMOUNT PAID, TRICARE (IMPUTED)"; label variable OBOF01X "AMOUNT PAID, OTHER FEDERAL (IMPUTED)"; label variable OBSL01X "AMOUNT PAID, STATE & LOCAL GOV (IMPUTED)"; label variable OBWC01X "AMOUNT PAID, WORKERS COMP (IMPUTED)"; label variable OBOR01X "AMOUNT PAID, OTHER PRIVATE (IMPUTED)"; label variable OBOU01X "AMOUNT PAID, OTHER PUBLIC (IMPUTED)"; label variable OBOT01X "AMOUNT PAID, OTHER INSURANCE (IMPUTED)"; label variable OBXP01X "SUM OF OBSF01X - OBOT01X (IMPUTED)"; label variable OBTC01X "HHLD REPORTED TOTAL 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 H59G0001X -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 H59G0002X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" 95 "95 NO TREATMENT RECEIVED" ; label define H59G0003X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H59G0004X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" 95 "95 NO TREATMENT RECEIVED" ; label define H59G0005X -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 H59G0006X -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 H59G0007X 1 "ROUND 1" 2 "ROUND 2" 3 "ROUND 3" 4 "ROUND 4" 5 "ROUND 5" ; label define H59G0008X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H59G0009X -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 H59G0010X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H59G0011X -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 H59G0012X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" 95 "95 NO TREATMENT RECEIVED" ; label define H59G0013X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" 95 "95 NO TREATMENT RECEIVED" ; label define H59G0014X -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 H59G0015X -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 H59G0016X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H59G0017X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 CHIROPRACTOR" 10 "10 PSYCHOLOGIST" 11 "11 SOCIAL WORKER" 12 "12 TECHNICIAN" 13 "13 RECEPTIONIST/CLERK/SECRETARY" 14 "14 ACUPUNCTURE" 15 "15 MASSAGE THERAPIST" 16 "16 HOMEOPATHIC/NATUROPATHIC/HERBALIST" 17 "17 OTHER ALTERNATIVE/COMPLEMENTARY CARE PRO" 2 "2 DENTIST/DENTAL CARE PERSON" 3 "3 MIDWIFE" 4 "4 NURSE/NURSE PRACTITIONER" 5 "5 OPTOMETRIST" 6 "6 PODIATRIST" 7 "7 PHYSICIAN'S ASSISTANT" 8 "8 PHYSICAL THERAPIST" 9 "9 OCCUPATIONAL THERAPIST" 91 "91 OTHER" ; label define H59G0018X 1 "1 HAS MPC DATA" 2 "2 NO MPC DATA" ; label define H59G0019X 1 "1 MPC ELIGIBLE" 2 "2 NOT MPC ELIGIBLE" ; label define H59G0020X -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 H59G0021X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" ; label define H59G0022X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" ; label define H59G0023X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 2001 "2001" ; label define H59G0024X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H59G0025X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H59G0026X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H59G0027X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H59G0028X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H59G0029X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H59G0030X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H59G0031X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H59G0032X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H59G0033X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H59G0034X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H59G0035X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H59G0036X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H59G0037X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H59G0038X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" 95 "95 NO TREATMENT RECEIVED" ; label define H59G0039X -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 H59G0040X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" 95 "95 NO TREATMENT RECEIVED" ; label define H59G0041X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" 95 "95 NO TREATMENT RECEIVED" ; label define H59G0042X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" 95 "95 NO TREATMENT RECEIVED" ; label define H59G0043X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" 95 "95 NO TREATMENT RECEIVED" ; label define H59G0044X -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 H59G0045X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H59G0046X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 SAW PROVIDER" 2 "2 TELEPHONE CALL" ; label define H59G0047X -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 H59G0048X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" 95 "95 NO TREATMENT RECEIVED" ; label define H59G0049X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H59G0050X -1 "-1 INAPPLICABLE" 0 "0 NO" 1 "1 YES" ; label define H59G0051X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 GENERAL CHECKUP" 10 "10 LASER EYE SURGERY" 2 "2 DIAGNOSIS OR TREATMENT" 3 "3 EMERGENCY (E.G., ACCIDENT OR INJURY)" 4 "4 PSYCHOTHERAPY/MENTAL HEALTH COUNSELING" 5 "5 FOLLOW-UP OR POST-OPERATIVE VISIT" 6 "6 IMMUNIZATIONS OR SHOTS" 7 "7 VISION EXAM" 8 "8 MATERNITY CARE (PRE/POSTNATAL)" 9 "9 WELL CHILD EXAM" 91 "91 OTHER" ; label define H59G0052X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H59G0053X -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 H59G0001X; label value CHEMOTH H59G0002X; label value DOCATLOC H59G0003X; label value DRUGTRT H59G0004X; label value EEG H59G0005X; label value EKG H59G0006X; label value EVENTRN H59G0007X; label value FFBEF01 H59G0008X; label value FFOBTYPE H59G0009X; label value FFTOT02 H59G0010X; label value IMPFLAG H59G0011X; label value IVTHER H59G0012X; label value KIDNEYD H59G0013X; label value LABTEST H59G0014X; label value MAMMOG H59G0015X; label value MEDPRESC H59G0016X; label value MEDPTYPE H59G0017X; label value MPCDATA H59G0018X; label value MPCELIG H59G0019X; label value MRI H59G0020X; label value OBDATEDD H59G0021X; label value OBDATEMM H59G0022X; label value OBDATEYR H59G0023X; label value OBMD01X H59G0024X; label value OBMR01X H59G0025X; label value OBOF01X H59G0026X; label value OBOR01X H59G0027X; label value OBOT01X H59G0028X; label value OBOU01X H59G0029X; label value OBPV01X H59G0030X; label value OBSF01X H59G0031X; label value OBSL01X H59G0032X; label value OBTC01X H59G0033X; label value OBTR01X H59G0034X; label value OBVA01X H59G0035X; label value OBWC01X H59G0036X; label value OBXP01X H59G0037X; label value OCCUPTH H59G0038X; label value OTHSVCE H59G0039X; label value PHYSTH H59G0040X; label value PSYCHOTH H59G0041X; label value RADIATTH H59G0042X; label value RCVSHOT H59G0043X; label value RCVVAC H59G0044X; label value SEEDOC H59G0045X; label value SEETLKPV H59G0046X; label value SONOGRAM H59G0047X; label value SPEECHTH H59G0048X; label value SURGPROC H59G0049X; label value VAPLACE H59G0050X; label value VSTCTGRY H59G0051X; label value VSTRELCN H59G0052X; label value XRAYS H59G0053X; *DISPLAY A DESCRIPTION OF STATA FILE; describe; *LIST FIRST 20 OBSERVATIONS IN THE FILE; list in 1/20; save H59G, replace; #delimit cr * data file is stored in H59G.dta * log file is stored in H59G.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 H59G.LOG and a data file named H59G.DTA. If these files (H59G.DTA and H59G.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. ************************************************************************************************/