/*****************************************************************************/
/*  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="H229E.DAT"  /LRECL=311.
DATA LIST FILE=INFILE /
    DUID 1-7  
    PID 8-10  
    DUPERSID 11-20 (A)
    EVNTIDX 21-36 (A)
    EVENTRN 37-37  
    ERHEVIDX 38-53 (A)
    FFEEIDX 54-65 (A)
    PANEL 66-67  
    MPCDATA 68-68  
    ERDATEYR 69-72  
    ERDATEMM 73-74  
    VSTCTGRY 75-77  
    VSTRELCN 78-79  
    LABTEST_M18 80-81  
    SONOGRAM_M18 82-83  
    XRAYS_M18 84-85  
    MAMMOG_M18 86-87  
    MRI_M18 88-89  
    EKG_M18 90-91  
    RCVVAC_M18 92-93  
    SURGPROC 94-95  
    MEDPRESC 96-97  
    FFERTYPE 98-99  
    ERXP21X 100-107 (2)
    ERTC21X 108-116 (2)
    ERFSF21X 117-123 (2)
    ERFMR21X 124-131 (2)
    ERFMD21X 132-139 (2)
    ERFPV21X 140-147 (2)
    ERFVA21X 148-154 (2)
    ERFTR21X 155-161 (2)
    ERFOF21X 162-168 (2)
    ERFSL21X 169-176 (2)
    ERFWC21X 177-184 (2)
    ERFOT21X 185-192 (2)
    ERFXP21X 193-200 (2)
    ERFTC21X 201-209 (2)
    ERDSF21X 210-216 (2)
    ERDMR21X 217-223 (2)
    ERDMD21X 224-231 (2)
    ERDPV21X 232-238 (2)
    ERDVA21X 239-245 (2)
    ERDTR21X 246-251 (2)
    ERDOF21X 252-257 (2)
    ERDSL21X 258-263 (2)
    ERDWC21X 264-270 (2)
    ERDOT21X 271-277 (2)
    ERDXP21X 278-285 (2)
    ERDTC21X 286-293 (2)
    IMPFLAG 294-294  
    PERWT21F 295-306 (6)
    VARSTR 307-310  
    VARPSU 311-311   .
VARIABLE LABEL 
    DUID "PANEL # + ENCRYPTED DU IDENTIFIER"
    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"
    PANEL "PANEL NUMBER"
    MPCDATA "MPC DATA FLAG"
    ERDATEYR "EVENT DATE - YEAR"
    ERDATEMM "EVENT DATE - MONTH"
    VSTCTGRY "BEST CATEGORY FOR CARE P RECV ON VISIT DT"
    VSTRELCN "THIS VISIT RELATED TO SPEC CONDITION"
    LABTEST_M18 "THIS VISIT DID P HAVE LAB TESTS"
    SONOGRAM_M18 "THIS VISIT DID P HAVE SONOGRAM OR ULTRSD"
    XRAYS_M18 "THIS VISIT DID P HAVE X-RAYS"
    MAMMOG_M18 "THIS VISIT DID P HAVE A MAMMOGRAM"
    MRI_M18 "THIS VISIT DID P HAVE AN MRI/CATSCAN"
    EKG_M18 "THIS VISIT DID P HAVE AN EKG, EEG OR ECG"
    RCVVAC_M18 "THIS VISIT DID P RECEIVE A VACCINATION"
    SURGPROC "WAS SURG PROC PERFORMED ON P THIS VISIT"
    MEDPRESC "ANY MEDICINE PRESCRIBED FOR P THIS VISIT"
    FFERTYPE "FLAT FEE BUNDLE"
    ERXP21X "TOTAL EXP FOR EVENT (ERFXP21X + ERDXP21X)"
    ERTC21X "TOTAL CHG FOR EVENT (ERFTC21X + ERDTC21X)"
    ERFSF21X "FACILITY AMOUNT PAID, FAMILY (IMPUTED)"
    ERFMR21X "FACILITY AMOUNT PAID, MEDICARE (IMPUTED)"
    ERFMD21X "FACILITY AMOUNT PAID, MEDICAID (IMPUTED)"
    ERFPV21X "FACILITY AMOUNT PAID, PRIV INSUR (IMPUTED)"
    ERFVA21X "FACILITY AMOUNT PAID, VETERANS/CHAMPVA (IMPUTED)"
    ERFTR21X "FACILITY AMOUNT PAID, TRICARE (IMPUTED)"
    ERFOF21X "FACILITY AMOUNT PAID, OTH FEDERAL (IMPUTED)"
    ERFSL21X "FACILITY AMOUNT PAID, STATE/LOC GOV (IMPUTED)"
    ERFWC21X "FACILITY AMOUNT PAID, WORKERS COMP (IMPUTED)"
    ERFOT21X "FACILITY AMOUNT PAID, OTH INSUR (IMPUTED)"
    ERFXP21X "FACILITY SUM PAYMENTS ERFSF21X - ERFOT21X"
    ERFTC21X "TOTAL FACILITY CHARGE (IMPUTED)"
    ERDSF21X "DOCTOR AMOUNT PAID, FAMILY (IMPUTED)"
    ERDMR21X "DOCTOR AMOUNT PAID, MEDICARE (IMPUTED)"
    ERDMD21X "DOCTOR AMOUNT PAID, MEDICAID (IMPUTED)"
    ERDPV21X "DOCTOR AMOUNT PAID, PRIV INSUR (IMPUTED)"
    ERDVA21X "DOCTOR AMOUNT PAID, VETERANS/CHAMPVA (IMPUTED)"
    ERDTR21X "DOCTOR AMOUNT PAID, TRICARE (IMPUTED)"
    ERDOF21X "DOCTOR AMOUNT PAID, OTH FEDERAL (IMPUTED)"
    ERDSL21X "DOCTOR AMOUNT PAID, STATE/LOC GOV (IMPUTED)"
    ERDWC21X "DOCTOR AMOUNT PAID, WORKERS COMP (IMPUTED)"
    ERDOT21X "DOCTOR AMOUNT PAID, OTH INSUR (IMPUTED)"
    ERDXP21X "DOCTOR SUM PAYMENTS ERDSF21X - ERDOT21X"
    ERDTC21X "TOTAL DOCTOR CHARGE (IMPUTED)"
    IMPFLAG "IMPUTATION STATUS"
    PERWT21F "EXPENDITURE FILE PERSON WEIGHT, 2021"
    VARSTR "VARIANCE ESTIMATION STRATUM, 2021"
    VARPSU "VARIANCE ESTIMATION PSU, 2021" .
VALUE LABELS 
    EKG_M18
         -7 "-7 REFUSED"
         -8 "-8 DK"
         1 "1 YES"
         2 "2 NO"
         95 "95 NO SERVICES RECEIVED" /
    ERDATEMM
         -7 "-7 REFUSED"
         -8 "-8 DK" /
    ERDATEYR
         -7 "-7 REFUSED"
         -8 "-8 DK"
         2021 "2021" /
    EVENTRN
         1 "1 ROUND 1"
         2 "2 ROUND 2"
         3 "3 ROUND 3"
         4 "4 ROUND 4"
         5 "5 ROUND 5"
         6 "6 ROUND 6"
         7 "7 ROUND 7"
         8 "8 ROUND 8"
         9 "9 ROUND 9" /
    FFERTYPE
         -1 "-1 INAPPLICABLE"
         -7 "-7 REFUSED"
         -8 "-8 DK"
         1 "1 FLAT FEE STEM"
         2 "2 FLAT FEE LEAF" /
    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_M18
         -7 "-7 REFUSED"
         -8 "-8 DK"
         1 "1 YES"
         2 "2 NO"
         95 "95 NO SERVICES RECEIVED" /
    MAMMOG_M18
         -7 "-7 REFUSED"
         -8 "-8 DK"
         1 "1 YES"
         2 "2 NO"
         95 "95 NO SERVICES RECEIVED" /
    MEDPRESC
         -7 "-7 REFUSED"
         -8 "-8 DK"
         1 "1 YES"
         2 "2 NO" /
    MPCDATA
         1 "1 HAS MPC DATA"
         2 "2 NO MPC DATA" /
    MRI_M18
         -7 "-7 REFUSED"
         -8 "-8 DK"
         1 "1 YES"
         2 "2 NO"
         95 "95 NO SERVICES RECEIVED" /
    PANEL
         23 "23 PANEL 23"
         24 "24 PANEL 24"
         25 "25 PANEL 25"
         26 "26 PANEL 26" /
    RCVVAC_M18
         -7 "-7 REFUSED"
         -8 "-8 DK"
         1 "1 YES"
         2 "2 NO"
         95 "95 NO SERVICES RECEIVED" /
    SONOGRAM_M18
         -7 "-7 REFUSED"
         -8 "-8 DK"
         1 "1 YES"
         2 "2 NO"
         95 "95 NO SERVICES RECEIVED" /
    SURGPROC
         -7 "-7 REFUSED"
         -8 "-8 DK"
         1 "1 YES"
         2 "2 NO" /
    VSTCTGRY
         -15 "-15 CANNOT BE COMPUTED"
         -7 "-7 REFUSED"
         -8 "-8 DK"
         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 PREGNANCY-RELATED (INC PRENATAL/ DELV)"
         91 "91 OTHER" /
    VSTRELCN
         -7 "-7 REFUSED"
         -8 "-8 DK"
         1 "1 YES"
         2 "2 NO" /
    XRAYS_M18
         -7 "-7 REFUSED"
         -8 "-8 DK"
         1 "1 YES"
         2 "2 NO"
         95 "95 NO SERVICES RECEIVED" .
EXECUTE.