/*****************************************************************************/
/*  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="H239D.DAT"  /LRECL=320.
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  
    IPXP22X 96-104 (2)
    IPTC22X 105-114 (2)
    IPFSF22X 115-123 (2)
    IPFMR22X 124-132 (2)
    IPFMD22X 133-140 (2)
    IPFPV22X 141-149 (2)
    IPFVA22X 150-158 (2)
    IPFTR22X 159-166 (2)
    IPFOF22X 167-174 (2)
    IPFSL22X 175-182 (2)
    IPFWC22X 183-190 (2)
    IPFOT22X 191-198 (2)
    IPFXP22X 199-207 (2)
    IPFTC22X 208-217 (2)
    IPDSF22X 218-224 (2)
    IPDMR22X 225-232 (2)
    IPDMD22X 233-240 (2)
    IPDPV22X 241-248 (2)
    IPDVA22X 249-255 (2)
    IPDTR22X 256-262 (2)
    IPDOF22X 263-266 (2)
    IPDSL22X 267-270 (2)
    IPDWC22X 271-277 (2)
    IPDOT22X 278-285 (2)
    IPDXP22X 286-293 (2)
    IPDTC22X 294-302 (2)
    IMPFLAG 303-303  
    PERWT22F 304-315 (6)
    VARSTR 316-319  
    VARPSU 320-320   .
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"
    IPXP22X "TOTAL EXP FOR EVENT (IPFXP22X + IPDXP22X)"
    IPTC22X "TOTAL CHG FOR EVENT (IPFTC22X + IPDTC22X)"
    IPFSF22X "FACILITY AMOUNT PAID, FAMILY (IMPUTED)"
    IPFMR22X "FACILITY AMOUNT PAID, MEDICARE (IMPUTED)"
    IPFMD22X "FACILITY AMOUNT PAID, MEDICAID (IMPUTED)"
    IPFPV22X "FACILITY AMOUNT PAID, PRIV INSUR (IMPUTED)"
    IPFVA22X "FACILITY AMOUNT PAID, VETERANS/CHAMPVA (IMPUTED)"
    IPFTR22X "FACILITY AMOUNT PAID, TRICARE (IMPUTED)"
    IPFOF22X "FACILITY AMOUNT PAID, OTH FEDERAL (IMPUTED)"
    IPFSL22X "FACILITY AMOUNT PAID, STATE/LOC GOV (IMPUTED)"
    IPFWC22X "FACILITY AMOUNT PAID, WORKERS COMP (IMPUTED)"
    IPFOT22X "FACILITY AMOUNT PAID, OTH INSUR (IMPUTED)"
    IPFXP22X "FACILITY SUM PAYMENTS IPFSF22X - IPFOT22X"
    IPFTC22X "TOTAL FACILITY CHARGE (IMPUTED)"
    IPDSF22X "DOCTOR AMOUNT PAID, FAMILY (IMPUTED)"
    IPDMR22X "DOCTOR AMOUNT PAID, MEDICARE (IMPUTED)"
    IPDMD22X "DOCTOR AMOUNT PAID, MEDICAID (IMPUTED)"
    IPDPV22X "DOCTOR AMOUNT PAID, PRIV INSUR (IMPUTED)"
    IPDVA22X "DOCTOR AMOUNT PAID, VETERANS/CHAMPVA (IMPUTED)"
    IPDTR22X "DOCTOR AMOUNT PAID, TRICARE (IMPUTED)"
    IPDOF22X "DOCTOR AMOUNT PAID, OTH FEDERAL (IMPUTED)"
    IPDSL22X "DOCTOR AMOUNT PAID, STATE/LOC GOV (IMPUTED)"
    IPDWC22X "DOCTOR AMOUNT PAID, WORKERS COMP (IMPUTED)"
    IPDOT22X "DOCTOR AMOUNT PAID, OTH INSUR (IMPUTED)"
    IPDXP22X "DOCTOR SUM PAYMENTS IPDSF22X - IPDOT22X"
    IPDTC22X "TOTAL DOCTOR CHARGE (IMPUTED)"
    IMPFLAG "IMPUTATION STATUS"
    PERWT22F "EXPENDITURE FILE PERSON WEIGHT, 2022"
    VARSTR "VARIANCE ESTIMATION STRATUM, 2022"
    VARPSU "VARIANCE ESTIMATION PSU, 2022" .
VALUE LABELS 
    ANYOPER
         -7 "-7 REFUSED"
         -8 "-8 DK"
         1 "1 YES"
         2 "2 NO" /
    DSCHPMED
         -7 "-7 REFUSED"
         -8 "-8 DK"
         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"
         6 "6 ROUND 6"
         7 "7 ROUND 7"
         8 "8 ROUND 8"
         9 "9 ROUND 9" /
    FFIPTYPE
         -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" /
    IPBEGMM
         -7 "-7 REFUSED"
         -8 "-8 DK" /
    IPBEGYR
         -7 "-7 REFUSED"
         -8 "-8 DK"
         2021 "2021"
         2022 "2022" /
    IPENDMM
         -7 "-7 REFUSED"
         -8 "-8 DK" /
    IPENDYR
         -7 "-7 REFUSED"
         -8 "-8 DK"
         2022 "2022" /
    MPCDATA
         1 "1 HAS MPC DATA"
         2 "2 NO MPC DATA" /
    PANEL
         24 "24 PANEL 24"
         26 "26 PANEL 26"
         27 "27 PANEL 27" /
    RSNINHOS
         -15 "-15 CANNOT BE COMPUTED"
         -7 "-7 REFUSED"
         -8 "-8 DK"
         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 DK"
         1 "1 YES"
         2 "2 NO" .
EXECUTE.