/*****************************************************************************/ /* SPSS User Files are being provided for the convenience of analysts who */ /* may wish to use SPSS to analyze the MEPS data. However, users are */ /* cautioned that SPSS does not currently have the capability to produce */ /* appropriate standard errors for estimates from a survey with a complex */ /* sample design like the Medical Expenditure Panel Survey (MEPS). The */ /* annual national probability sample of households selected for the MEPS */ /* is a subsample of those participating in the National Health Interview */ /* Survey (NHIS) for the previous calendar year. The NHIS, an ongoing */ /* general health survey of the civilian noninstitutionalized population, */ /* is conducted by the National Center for Health Statistics, Centers for */ /* Disease Control and Prevention. The NHIS sample design, and thus that */ /* of the MEPS, uses complex sampling techniques including */ /* stratification, clustering, and differential sampling rates for the */ /* oversampling of selected subgroups of the population. Because of this */ /* sampling structure, software that accounts for this complex sample */ /* design must be used. Without the use of appropriate software that */ /* accounts for the complex sample design of the MEPS in conjunction with */ /* the survey's sampling weights (reflecting the survey's sample */ /* selection probabilities and nonresponse and other adjustments), the */ /* estimated standard errors of survey point estimates will generally be */ /* underestimated, and, thus, the inferential conclusions in an analysis */ /* (descriptive or analytical) may be misleading. It is recommended that */ /* sample survey software be used to analyze the MEPS data. Software for */ /* analysis of complex survey data include, for example, SUDAAN (Research */ /* Triangle Institute), STATA (Stata Corporation), VPLX (U.S. Bureau of */ /* the Census), and WESVAR (Westat, Inc.). A more comprehensive summary */ /* of software for the analysis of data from surveys with complex sample */ /* designs can be accessed through the website for the American */ /* Statistical Association's Survey Research Methods Section. Users may */ /* also reference the Agency for Healthcare Research and Quality (AHRQ) */ /* web document "Computing Standard Errors for Medical Expenditure Panel */ /* Survey (MEPS) Estimates." */ /*****************************************************************************/ FILE HANDLE INFILE NAME="H51E.DAT" /LRECL=345. DATA LIST FILE=INFILE / DUID 1-5 PID 6-8 DUPERSID 9-16 (A) EVNTIDX 17-28 (A) EVENTRN 29-29 ERHEVIDX 30-41 (A) FFEEIDX 42-53 (A) MPCDATA 54-54 ERDATEYR 55-58 ERDATEMM 59-60 ERDATEDD 61-62 SEEDOC 63-64 VSTCTGRY 65-66 VSTRELCN 67-68 LABTEST 69-70 SONOGRAM 71-72 XRAYS 73-74 MAMMOG 75-76 MRI 77-78 EKG 79-80 EEG 81-82 RCVVAC 83-84 ANESTH 85-86 OTHSVCE 87-88 SURGPROC 89-90 SURGNAME 91-92 MEDPRESC 93-94 VAPLACE 95-95 ERICD1X 96-98 (A) ERICD2X 99-101 (A) ERICD3X 102-104 (A) ERPRO1X 105-106 (A) ERCCC1X 107-109 (A) ERCCC2X 110-112 (A) ERCCC3X 113-115 (A) FFERTYPE 116-117 FFBEF00 118-119 FFTOT01 120-121 ERXP00X 122-129 (2) ERTC00X 130-137 (2) ERFSF00X 138-144 (2) ERFMR00X 145-151 (2) ERFMD00X 152-158 (2) ERFPV00X 159-166 (2) ERFVA00X 167-174 (2) ERFTR00X 175-181 (2) ERFOF00X 182-188 (2) ERFSL00X 189-195 (2) ERFWC00X 196-202 (2) ERFOR00X 203-209 (2) ERFOU00X 210-216 (2) ERFOT00X 217-223 (2) ERFXP00X 224-231 (2) ERFTC00X 232-239 (2) ERDSF00X 240-246 (2) ERDMR00X 247-253 (2) ERDMD00X 254-259 (2) ERDPV00X 260-266 (2) ERDVA00X 267-272 (2) ERDTR00X 273-278 (2) ERDOF00X 279-284 (2) ERDSL00X 285-290 (2) ERDWC00X 291-296 (2) ERDOR00X 297-302 (2) ERDOU00X 303-308 (2) ERDOT00X 309-314 (2) ERDXP00X 315-321 (2) ERDTC00X 322-328 (2) IMPFLAG 329-329 PERWT00F 330-341 (6) VARSTR00 342-343 VARPSU00 344-345 . VARIABLE LABEL DUID 'DWELLING UNIT ID' PID 'PERSON NUMBER' DUPERSID 'PERSON ID (DUID + PID)' EVNTIDX 'EVENT ID' EVENTRN 'EVENT ROUND NUMBER' ERHEVIDX 'EVENT ID FOR CORRESPONDING HOSPITAL STAY' FFEEIDX 'FLAT FEE ID' MPCDATA 'MPC DATA FLAG' ERDATEYR 'EVENT DATE - YEAR' ERDATEMM 'EVENT DATE - MONTH' ERDATEDD 'EVENT DATE - DAY' SEEDOC 'DID P TALK TO MD THIS VISIT' VSTCTGRY 'BEST CATEGORY FOR CARE P RECV ON VST DT' VSTRELCN 'WAS THIS VISIT RELATED TO SPEC HLTH COND' LABTEST 'THIS VISIT DID P HAVE LAB TESTS' SONOGRAM 'THIS VISIT DID P HAVE SONOGRAM OR ULTRSD' XRAYS 'THIS VISIT DID P HAVE X-RAYS' MAMMOG 'THIS VISIT DID P HAVE A MAMMOGRAM' MRI 'THIS VISIT DID P HAVE AN MRI/CATSCAN' EKG 'THIS VISIT DID P HAVE AN EKG OR ECG' EEG 'THIS VISIT DID P HAVE AN EEG' RCVVAC 'THIS VISIT DID P RECEIVE A VACCINATION' ANESTH 'THIS VISIT DID P RECEIVE ANESTHESIA' OTHSVCE 'THIS VISIT DID P HAVE OTH DIAG TEST/EXAM' SURGPROC 'WAS SURG PROC PERFORMED ON P THIS VISIT' SURGNAME 'SURGICAL PROCEDURE NAME IN CATEGORIES' MEDPRESC 'ANY MEDICINE PRESCRIBED FOR P THIS VISIT' VAPLACE 'VA FACILITY FLAG' ERICD1X '3-DIGIT ICD-9 CONDITION CODE' ERICD2X '3-DIGIT ICD-9 CONDITION CODE' ERICD3X '3-DIGIT ICD-9 CONDITION CODE' ERPRO1X '2-DIGIT ICD-9 PROCEDURE CODE' ERCCC1X 'MODIFIED CLINICAL CLASSIFICATION CODE' ERCCC2X 'MODIFIED CLINICAL CLASSIFICATION CODE' ERCCC3X 'MODIFIED CLINICAL CLASSIFICATION CODE' FFERTYPE 'FLAT FEE BUNDLE' FFBEF00 'TOTAL # OF VISITS IN FF BEFORE 2000' FFTOT01 'TOTAL # OF VISITS IN FF AFTER 2000' ERXP00X 'TOT EXP FOR EVENT (ERFXP00X + ERDXP00X)' ERTC00X 'TOTAL CHG FOR EVENT (ERFTC00X+ERDTC00X)' ERFSF00X 'FACILITY AMT PD, FAMILY (IMPUTED)' ERFMR00X 'FACILITY AMT PD, MEDICARE (IMPUTED)' ERFMD00X 'FACILITY AMT PD, MEDICAID (IMPUTED)' ERFPV00X 'FACILITY AMT PD, PRIV INSUR (IMPUTED)' ERFVA00X 'FACILITY AMT PD, VETERANS (IMPUTED)' ERFTR00X 'FACILITY AMT PD, TRICARE (IMPUTED)' ERFOF00X 'FACILITY AMT PD, OTH FEDERAL (IMPUTED)' ERFSL00X 'FACILITY AMT PD, STATE/LOC GOV (IMPUTED)' ERFWC00X 'FACILITY AMT PD, WORKERS COMP (IMPUTED)' ERFOR00X 'FACILITY AMT PD, OTH PRIV (IMPUTED)' ERFOU00X 'FACILITY AMT PD, OTH PUB (IMPUTED)' ERFOT00X 'FACILITY AMT PD, OTH INSUR (IMPUTED)' ERFXP00X 'FACILITY SUM PAYMENTS ERFSF00X-ERFOT00X' ERFTC00X 'TOTAL FACILITY CHARGE (IMPUTED)' ERDSF00X 'DOCTOR AMOUNT PAID, FAMILY (IMPUTED)' ERDMR00X 'DOCTOR AMOUNT PD, MEDICARE (IMPUTED)' ERDMD00X 'DOCTOR AMOUNT PAID, MEDICAID (IMPUTED)' ERDPV00X 'DOCTOR AMT PD, PRIV INSUR (IMPUTED)' ERDVA00X 'DOCTOR AMOUNT PAID, VETERANS (IMPUTED)' ERDTR00X 'DOCTOR AMOUNT PD, TRICARE (IMPUTED)' ERDOF00X 'DOCTOR AMT PAID, OTH FEDERAL (IMPUTED)' ERDSL00X 'DOCTOR AMT PD, STATE/LOC GOV (IMPUTED)' ERDWC00X 'DOCTOR AMOUNT PD, WORKERS COMP (IMPUTED)' ERDOR00X 'DOCTOR AMT PD, OTH PRIVATE (IMPUTED)' ERDOU00X 'DOCTOR AMT PD, OTH PUB (IMPUTED)' ERDOT00X 'DOCTOR AMT PD, OTH INSUR (IMPUTED)' ERDXP00X 'DOCTOR SUM PAYMENTS ERDSF00X - ERDOT00X' ERDTC00X 'TOTAL DOCTOR CHARGE (IMPUTED)' IMPFLAG 'IMPUTATION STATUS' PERWT00F 'FINAL PERSON LEVEL WEIGHT, 2000' VARSTR00 'VARIANCE ESTIMATION STRATUM, 2000' VARPSU00 'VARIANCE ESTIMATION PSU, 2000' . VALUE LABELS ANESTH -1 '-1 INAPPLICABLE' -7 '-7 REFUSED' -8 '-8 DK' -9 '-9 NOT ASCERTAINED' 1 '1 YES' 2 '2 NO' 95 '95 NO SERVICES RECEIVED' / EEG -1 '-1 INAPPLICABLE' -7 '-7 REFUSED' -8 '-8 DK' -9 '-9 NOT ASCERTAINED' 1 '1 YES' 2 '2 NO' 95 '95 NO SERVICES RECEIVED' / EKG -1 '-1 INAPPLICABLE' -7 '-7 REFUSED' -8 '-8 DK' -9 '-9 NOT ASCERTAINED' 1 '1 YES' 2 '2 NO' 95 '95 NO SERVICES RECEIVED' / ERCCC1X '-1' '-1 INAPPLICABLE' '-7' '-7 REFUSED' '-8' '-8 DK' '-9' '-9 NOT ASCERTAINED' / ERCCC2X '-1' '-1 INAPPLICABLE' '-7' '-7 REFUSED' '-8' '-8 DK' '-9' '-9 NOT ASCERTAINED' / ERCCC3X '-1' '-1 INAPPLICABLE' '-7' '-7 REFUSED' '-8' '-8 DK' '-9' '-9 NOT ASCERTAINED' / ERDATEDD -1 '-1 INAPPLICABLE' -7 '-7 REFUSED' -8 '-8 DK' -9 '-9 NOT ASCERTAINED' / ERDATEMM -1 '-1 INAPPLICABLE' -7 '-7 REFUSED' -8 '-8 DK' -9 '-9 NOT ASCERTAINED' / ERDATEYR -1 '-1 INAPPLICABLE' -7 '-7 REFUSED' -8 '-8 DK' -9 '-9 NOT ASCERTAINED' 2000 '2000' / ERDMD00X -1 '-1 INAPPLICABLE' -9 '-9 NOT ASCERTAINED' 0 '0' / ERDMR00X -1 '-1 INAPPLICABLE' -9 '-9 NOT ASCERTAINED' 0 '0' / ERDOF00X -1 '-1 INAPPLICABLE' -9 '-9 NOT ASCERTAINED' 0 '0' / ERDOR00X -1 '-1 INAPPLICABLE' -9 '-9 NOT ASCERTAINED' 0 '0' / ERDOT00X -1 '-1 INAPPLICABLE' -9 '-9 NOT ASCERTAINED' 0 '0' / ERDOU00X -1 '-1 INAPPLICABLE' -9 '-9 NOT ASCERTAINED' 0 '0' / ERDPV00X -1 '-1 INAPPLICABLE' -9 '-9 NOT ASCERTAINED' 0 '0' / ERDSF00X -1 '-1 INAPPLICABLE' -9 '-9 NOT ASCERTAINED' 0 '0' / ERDSL00X -1 '-1 INAPPLICABLE' -9 '-9 NOT ASCERTAINED' 0 '0' / ERDTC00X -1 '-1 INAPPLICABLE' -9 '-9 NOT ASCERTAINED' 0 '0' / ERDTR00X -1 '-1 INAPPLICABLE' -9 '-9 NOT ASCERTAINED' 0 '0' / ERDVA00X -1 '-1 INAPPLICABLE' -9 '-9 NOT ASCERTAINED' 0 '0' / ERDWC00X -1 '-1 INAPPLICABLE' -9 '-9 NOT ASCERTAINED' 0 '0' / ERDXP00X -1 '-1 INAPPLICABLE' -9 '-9 NOT ASCERTAINED' 0 '0' / ERFMD00X -1 '-1 INAPPLICABLE' -9 '-9 NOT ASCERTAINED' 0 '0' / ERFMR00X -1 '-1 INAPPLICABLE' -9 '-9 NOT ASCERTAINED' 0 '0' / ERFOF00X -1 '-1 INAPPLICABLE' -9 '-9 NOT ASCERTAINED' 0 '0' / ERFOR00X -1 '-1 INAPPLICABLE' -9 '-9 NOT ASCERTAINED' 0 '0' / ERFOT00X -1 '-1 INAPPLICABLE' -9 '-9 NOT ASCERTAINED' 0 '0' / ERFOU00X -1 '-1 INAPPLICABLE' -9 '-9 NOT ASCERTAINED' 0 '0' / ERFPV00X -1 '-1 INAPPLICABLE' -9 '-9 NOT ASCERTAINED' 0 '0' / ERFSF00X -1 '-1 INAPPLICABLE' -9 '-9 NOT ASCERTAINED' 0 '0' / ERFSL00X -1 '-1 INAPPLICABLE' -9 '-9 NOT ASCERTAINED' 0 '0' / ERFTC00X -1 '-1 INAPPLICABLE' -9 '-9 NOT ASCERTAINED' 0 '0' / ERFTR00X -1 '-1 INAPPLICABLE' -9 '-9 NOT ASCERTAINED' 0 '0' / ERFVA00X -1 '-1 INAPPLICABLE' -9 '-9 NOT ASCERTAINED' 0 '0' / ERFWC00X -1 '-1 INAPPLICABLE' -9 '-9 NOT ASCERTAINED' 0 '0' / ERFXP00X -1 '-1 INAPPLICABLE' -9 '-9 NOT ASCERTAINED' 0 '0' / ERICD1X '-1' '-1 INAPPLICABLE' '-7' '-7 REFUSED' '-8' '-8 DK' '-9' '-9 NOT ASCERTAINED' / ERICD2X '-1' '-1 INAPPLICABLE' '-7' '-7 REFUSED' '-8' '-8 DK' '-9' '-9 NOT ASCERTAINED' / ERICD3X '-1' '-1 INAPPLICABLE' '-7' '-7 REFUSED' '-8' '-8 DK' '-9' '-9 NOT ASCERTAINED' / ERPRO1X '-1' '-1 INAPPLICABLE' '-7' '-7 REFUSED' '-8' '-8 DK' '-9' '-9 NOT ASCERTAINED' / ERTC00X -1 '-1 INAPPLICABLE' -9 '-9 NOT ASCERTAINED' 0 '0' / ERXP00X -1 '-1 INAPPLICABLE' -9 '-9 NOT ASCERTAINED' 0 '0' / EVENTRN 1 'ROUND 1' 2 'ROUND 2' 3 'ROUND 3' 4 'ROUND 4' 5 'ROUND 5' / FFBEF00 -1 '-1 INAPPLICABLE' -7 '-7 REFUSED' -8 '-8 DK' -9 '-9 NOT ASCERTAINED' 0 '0' / FFERTYPE -1 '-1 INAPPLICABLE' -7 '-7 REFUSED' -8 '-8 DK' -9 '-9 NOT ASCERTAINED' 1 '1 FLAT FEE STEM' 2 '2 FLAT FEE LEAF' / FFTOT01 -1 '-1 INAPPLICABLE' -7 '-7 REFUSED' -8 '-8 DK' -9 '-9 NOT ASCERTAINED' 0 '0' 1 '1' / IMPFLAG 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' / LABTEST -1 '-1 INAPPLICABLE' -7 '-7 REFUSED' -8 '-8 DK' -9 '-9 NOT ASCERTAINED' 1 '1 YES' 2 '2 NO' 95 '95 NO SERVICES RECEIVED' / MAMMOG -1 '-1 INAPPLICABLE' -7 '-7 REFUSED' -8 '-8 DK' -9 '-9 NOT ASCERTAINED' 1 '1 YES' 2 '2 NO' 95 '95 NO SERVICES RECEIVED' / MEDPRESC -1 '-1 INAPPLICABLE' -7 '-7 REFUSED' -8 '-8 DK' -9 '-9 NOT ASCERTAINED' 1 '1 YES' 2 '2 NO' / MPCDATA 1 '1 HAS MPC DATA' 2 '2 NO MPC DATA' / MRI -1 '-1 INAPPLICABLE' -7 '-7 REFUSED' -8 '-8 DK' -9 '-9 NOT ASCERTAINED' 1 '1 YES' 2 '2 NO' 95 '95 NO SERVICES RECEIVED' / OTHSVCE -1 '-1 INAPPLICABLE' -7 '-7 REFUSED' -8 '-8 DK' -9 '-9 NOT ASCERTAINED' 1 '1 YES' 2 '2 NO' 95 '95 NO SERVICES RECEIVED' / RCVVAC -1 '-1 INAPPLICABLE' -7 '-7 REFUSED' -8 '-8 DK' -9 '-9 NOT ASCERTAINED' 1 '1 YES' 2 '2 NO' 95 '95 NO SERVICES RECEIVED' / SEEDOC -1 '-1 INAPPLICABLE' -7 '-7 REFUSED' -8 '-8 DK' -9 '-9 NOT ASCERTAINED' 1 '1 YES' 2 '2 NO' / SONOGRAM -1 '-1 INAPPLICABLE' -7 '-7 REFUSED' -8 '-8 DK' -9 '-9 NOT ASCERTAINED' 1 '1 YES' 2 '2 NO' 95 '95 NO SERVICES RECEIVED' / SURGNAME -1 '-1 INAPPLICABLE' -7 '-7 REFUSED' -8 '-8 DK' -9 '-9 NOT ASCERTAINED' 1 '1 CLEANING/TREATMT WOUND, INFECTION' 2 '2 STITCHES (WOUND SUTURE)' 3 '3 SURGICAL SETTING OF BROKEN BONE' 91 '91 OTHER' / SURGPROC -1 '-1 INAPPLICABLE' -7 '-7 REFUSED' -8 '-8 DK' -9 '-9 NOT ASCERTAINED' 1 '1 YES' 2 '2 NO' 95 '95 NO SERVICES RECEIVED' / VAPLACE -1 '-1 INAPPLICABLE' 0 '0 NO' 1 '1 YES' / VSTCTGRY -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 MATERNITY CARE (PRE/POSTNATAL)' 91 '91 OTHER' / VSTRELCN -1 '-1 INAPPLICABLE' -7 '-7 REFUSED' -8 '-8 DK' -9 '-9 NOT ASCERTAINED' 1 '1 YES' 2 '2 NO' / XRAYS -1 '-1 INAPPLICABLE' -7 '-7 REFUSED' -8 '-8 DK' -9 '-9 NOT ASCERTAINED' 1 '1 YES' 2 '2 NO' 95 '95 NO SERVICES RECEIVED' . EXECUTE.