/*****************************************************************************/
/*  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="H248D.DAT"  /LRECL=326.
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  
    IPBEGYR 69-72  
    IPBEGMM 73-74  
    IPENDYR 75-78  
    IPENDMM 79-80  
    NUMNIGHX 81-83  
    EMERROOM 84-84  
    SPECCOND 85-86  
    RSNINHOS 87-89  
    ANYOPER 90-91  
    DSCHPMED 92-93  
    FFIPTYPE 94-95  
    IPXP23X 96-104 (2)
    IPTC23X 105-114 (2)
    IPFSF23X 115-123 (2)
    IPFMR23X 124-132 (2)
    IPFMD23X 133-141 (2)
    IPFPV23X 142-150 (2)
    IPFVA23X 151-159 (2)
    IPFTR23X 160-168 (2)
    IPFOF23X 169-176 (2)
    IPFSL23X 177-184 (2)
    IPFWC23X 185-192 (2)
    IPFOT23X 193-200 (2)
    IPFXP23X 201-209 (2)
    IPFTC23X 210-219 (2)
    IPDSF23X 220-226 (2)
    IPDMR23X 227-234 (2)
    IPDMD23X 235-242 (2)
    IPDPV23X 243-251 (2)
    IPDVA23X 252-258 (2)
    IPDTR23X 259-265 (2)
    IPDOF23X 266-269 (2)
    IPDSL23X 270-276 (2)
    IPDWC23X 277-283 (2)
    IPDOT23X 284-290 (2)
    IPDXP23X 291-299 (2)
    IPDTC23X 300-308 (2)
    IMPFLAG 309-309  
    PERWT23F 310-321 (6)
    VARSTR 322-325  
    VARPSU 326-326   .
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 EMER RM VISIT"
    FFEEIDX "FLAT FEE ID"
    PANEL "PANEL NUMBER"
    MPCDATA "MPC DATA FLAG"
    IPBEGYR "EVENT START DATE - YEAR"
    IPBEGMM "EVENT START DATE - MONTH"
    IPENDYR "EVENT END DATE - YEAR"
    IPENDMM "EVENT END DATE - MONTH"
    NUMNIGHX "# OF NIGHTS IN HOSPITAL - EDITED/IMPUTED"
    EMERROOM "DID STAY BEGIN WITH EMERGENCY ROOM VISIT"
    SPECCOND "HOSPITAL STAY RELATED TO CONDITION"
    RSNINHOS "REASON ENTERED HOSPITAL"
    ANYOPER "ANY OPERATIONS OR SURGERIES PERFORMED"
    DSCHPMED "MEDICINES PRESCRIBED AT DISCHARGE"
    FFIPTYPE "FLAT FEE BUNDLE"
    IPXP23X "TOTAL EXP FOR EVENT (IPFXP23X + IPDXP23X)"
    IPTC23X "TOTAL CHG FOR EVENT (IPFTC23X + IPDTC23X)"
    IPFSF23X "FACILITY AMOUNT PAID, FAMILY (IMPUTED)"
    IPFMR23X "FACILITY AMOUNT PAID, MEDICARE (IMPUTED)"
    IPFMD23X "FACILITY AMOUNT PAID, MEDICAID (IMPUTED)"
    IPFPV23X "FACILITY AMOUNT PAID, PRIV INSUR (IMPUTED)"
    IPFVA23X "FACILITY AMOUNT PAID, VETERANS/CHAMPVA (IMPUTED)"
    IPFTR23X "FACILITY AMOUNT PAID, TRICARE (IMPUTED)"
    IPFOF23X "FACILITY AMOUNT PAID, OTH FEDERAL (IMPUTED)"
    IPFSL23X "FACILITY AMOUNT PAID, STATE/LOC GOV (IMPUTED)"
    IPFWC23X "FACILITY AMOUNT PAID, WORKERS COMP (IMPUTED)"
    IPFOT23X "FACILITY AMOUNT PAID, OTH INSUR (IMPUTED)"
    IPFXP23X "FACILITY SUM PAYMENTS IPFSF23X - IPFOT23X"
    IPFTC23X "TOTAL FACILITY CHARGE (IMPUTED)"
    IPDSF23X "DOCTOR AMOUNT PAID, FAMILY (IMPUTED)"
    IPDMR23X "DOCTOR AMOUNT PAID, MEDICARE (IMPUTED)"
    IPDMD23X "DOCTOR AMOUNT PAID, MEDICAID (IMPUTED)"
    IPDPV23X "DOCTOR AMOUNT PAID, PRIV INSUR (IMPUTED)"
    IPDVA23X "DOCTOR AMOUNT PAID, VETERANS/CHAMPVA (IMPUTED)"
    IPDTR23X "DOCTOR AMOUNT PAID, TRICARE (IMPUTED)"
    IPDOF23X "DOCTOR AMOUNT PAID, OTH FEDERAL (IMPUTED)"
    IPDSL23X "DOCTOR AMOUNT PAID, STATE/LOC GOV (IMPUTED)"
    IPDWC23X "DOCTOR AMOUNT PAID, WORKERS COMP (IMPUTED)"
    IPDOT23X "DOCTOR AMOUNT PAID, OTH INSUR (IMPUTED)"
    IPDXP23X "DOCTOR SUM PAYMENTS IPDSF23X - IPDOT23X"
    IPDTC23X "TOTAL DOCTOR CHARGE (IMPUTED)"
    IMPFLAG "IMPUTATION STATUS"
    PERWT23F "EXPENDITURE FILE PERSON WEIGHT, 2023"
    VARSTR "VARIANCE ESTIMATION STRATUM, 2023"
    VARPSU "VARIANCE ESTIMATION PSU, 2023" .
VALUE LABELS 
    ANYOPER
         -7 "-7 REFUSED"
         -8 "-8 DON'T KNOW"
         1 "1 YES"
         2 "2 NO" /
    DSCHPMED
         -7 "-7 REFUSED"
         -8 "-8 DON'T KNOW"
         1 "1 YES"
         2 "2 NO" /
    EMERROOM
         1 "1 YES"
         2 "2 NO" /
    EVENTRN
         1 "1 ROUND 1"
         2 "2 ROUND 2"
         3 "3 ROUND 3"
         4 "4 ROUND 4"
         5 "5 ROUND 5" /
    FFIPTYPE
         -1 "-1 INAPPLICABLE"
         -7 "-7 REFUSED"
         -8 "-8 DON'T KNOW"
         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" /
    IPBEGMM
         -7 "-7 REFUSED"
         -8 "-8 DON'T KNOW" /
    IPBEGYR
         -7 "-7 REFUSED"
         -8 "-8 DON'T KNOW"
         2022 "2022"
         2023 "2023" /
    IPENDMM
         -7 "-7 REFUSED"
         -8 "-8 DON'T KNOW" /
    IPENDYR
         -7 "-7 REFUSED"
         -8 "-8 DON'T KNOW"
         2023 "2023" /
    MPCDATA
         1 "1 HAS MPC DATA"
         2 "2 NO MPC DATA" /
    PANEL
         27 "27 PANEL 27"
         28 "28 PANEL 28" /
    RSNINHOS
         -15 "-15 CANNOT BE COMPUTED"
         -7 "-7 REFUSED"
         -8 "-8 DON'T KNOW"
         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)"
         6 "6 PREGNANCY-RELATED COMPLICATIONS"
         91 "91 OTHER (SPECIFY)" /
    SPECCOND
         -7 "-7 REFUSED"
         -8 "-8 DON'T KNOW"
         1 "1 YES"
         2 "2 NO" .
EXECUTE.