/*****************************************************************************/
/*  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."                                                */
/*****************************************************************************/


DATA LIST FILE="PROJYR07.DAT"  /
    DUPERIDX 1-8 (A)
    AGESTUB 9-10  
    SEX 11-11  
    RACE7P 12-12  
    INSCOV_A 13-13  
    INSCOV_B 14-15  
    MCDHMO 16-16  
    PRVHMO 17-17  
    POVCAT 18-18  
    TOTEXP07 19-27 (2)
    TOTSLF07 28-36 (2)
    TOTPHI07 37-45 (2)
    TOTMCR07 46-54 (2)
    TOTMCD07 55-63 (2)
    TOTTRI07 64-72 (2)
    TOTVA07 73-81 (2)
    TOTWC07 82-90 (2)
    TOTOTP07 91-98 (2)
    TOTOSR07 99-106 (2)
    HOSEXP07 107-115 (2)
    HOSSLF07 116-123 (2)
    HOSPHI07 124-132 (2)
    HOSMCR07 133-141 (2)
    HOSMCD07 142-150 (2)
    HOSTRI07 151-159 (2)
    HOSVA07 160-168 (2)
    HOSWC07 169-177 (2)
    HOSOTP07 178-185 (2)
    HOSOSR07 186-193 (2)
    PHYEXP07 194-202 (2)
    PHYSLF07 203-210 (2)
    PHYPHI07 211-218 (2)
    PHYMCR07 219-226 (2)
    PHYMCD07 227-234 (2)
    PHYTRI07 235-243 (2)
    PHYVA07 244-250 (2)
    PHYWC07 251-258 (2)
    PHYOTP07 259-266 (2)
    PHYOSR07 267-274 (2)
    DVTEXP07 275-282 (2)
    DVTSLF07 283-290 (2)
    DVTPHI07 291-298 (2)
    DVTMCR07 299-305 (2)
    DVTMCD07 306-313 (2)
    DVTTRI07 314-317 (2)
    DVTVA07 318-323 (2)
    DVTWC07 324-327 (2)
    DVTOTP07 328-334 (2)
    DVTOSR07 335-342 (2)
    OBOEXP07 343-350 (2)
    OBOSLF07 351-358 (2)
    OBOPHI07 359-366 (2)
    OBOMCR07 367-374 (2)
    OBOMCD07 375-382 (2)
    OBOTRI07 383-386 (2)
    OBOVA07 387-392 (2)
    OBOWC07 393-400 (2)
    OBOOTP07 401-407 (2)
    OBOOSR07 408-415 (2)
    HHCEXP07 416-424 (2)
    HHCSLF07 425-432 (2)
    HHCPHI07 433-441 (2)
    HHCMCR07 442-449 (2)
    HHCMCD07 450-458 (2)
    HHCTRI07 459-465 (2)
    HHCVA07 466-473 (2)
    HHCWC07 474-481 (2)
    HHCOTP07 482-489 (2)
    HHCOSR07 490-496 (2)
    RXEXP07 497-505 (2)
    RXSLF07 506-513 (2)
    RXPHI07 514-521 (2)
    RXMCR07 522-530 (2)
    RXMCD07 531-539 (2)
    RXTRI07 540-547 (2)
    RXVA07 548-555 (2)
    RXWC07 556-563 (2)
    RXOTP07 564-571 (2)
    RXOSR07 572-578 (2)
    OTHEXP07 579-586 (2)
    OTHSLF07 587-594 (2)
    OTHPHI07 595-602 (2)
    OTHMCR07 603-610 (2)
    OTHMCD07 611-614 (2)
    OTHTRI07 615-618 (2)
    OTHVA07 619-622 (2)
    OTHWC07 623-630 (2)
    OTHOTP07 631-637 (2)
    OTHOSR07 638-644 (2)
    WTADJ07 645-656 (6) .
VARIABLE LABEL 
    DUPERIDX 'PERSON ID'
    AGESTUB 'AGE'
    SEX 'SEX'
    RACE7P 'RACE/ETHNICITY'
    INSCOV_A 'INSURANCE STATUS DURING YEAR - UNDER 65'
    INSCOV_B 'INSURANCE STATUS DURING YEAR - 65 & OVER'
    MCDHMO 'MEDICAID/SCHIP HMO DURING YEAR'
    PRVHMO 'PRIVATE HMO COVERAGE DURING YEAR'
    POVCAT 'FAMILY INCOME AS PERCENT OF POVERTY LINE'
    TOTEXP07 'TOTAL, PAID BY TOTAL, 2007'
    TOTSLF07 'TOTAL, PAID BY OUT OF POCKET, 2007'
    TOTPHI07 'TOTAL, PAID BY PRIV INSU, 2007'
    TOTMCR07 'TOTAL, PAID BY MEDICARE, 2007'
    TOTMCD07 'TOTAL, PAID BY MEDICAID, 2007'
    TOTTRI07 'TOTAL, PAID BY TRICARE, 2007'
    TOTVA07 'TOTAL, PAID BY VA, 2007'
    TOTWC07 'TOTAL, PAID BY WORKERS COMP, 2007'
    TOTOTP07 'TOTAL, PAID BY OTHER PUBLIC, 2007'
    TOTOSR07 'TOTAL, PAID BY OTHER, 2007'
    HOSEXP07 'HOSPITAL, PAID BY TOTAL, 2007'
    HOSSLF07 'HOSPITAL, PAID BY OUT OF POCKET, 2007'
    HOSPHI07 'HOSPITAL, PAID BY PRIV INSU, 2007'
    HOSMCR07 'HOSPITAL, PAID BY MEDICARE, 2007'
    HOSMCD07 'HOSPITAL, PAID BY MEDICAID, 2007'
    HOSTRI07 'HOSPITAL, PAID BY TRICARE, 2007'
    HOSVA07 'HOSPITAL, PAID BY VA, 2007'
    HOSWC07 'HOSPITAL, PAID BY WORKERS COMP, 2007'
    HOSOTP07 'HOSPITAL, PAID BY OTHER PUBLIC, 2007'
    HOSOSR07 'HOSPITAL, PAID BY OTHER, 2007'
    PHYEXP07 'PHYSICIAN, PAID BY TOTAL, 2007'
    PHYSLF07 'PHYSICIAN, PAID BY OUT OF POCKET, 2007'
    PHYPHI07 'PHYSICIAN, PAID BY PRIV INSU, 2007'
    PHYMCR07 'PHYSICIAN, PAID BY MEDICARE, 2007'
    PHYMCD07 'PHYSICIAN, PAID BY MEDICAID, 2007'
    PHYTRI07 'PHYSICIAN, PAID BY TRICARE, 2007'
    PHYVA07 'PHYSICIAN, PAID BY VA, 2007'
    PHYWC07 'PHYSICIAN, PAID BY WORKERS COMP, 2007'
    PHYOTP07 'PHYSICIAN, PAID BY OTHER PUBLIC, 2007'
    PHYOSR07 'PHYSICIAN, PAID BY OTHER, 2007'
    DVTEXP07 'DENTAL, PAID BY TOTAL, 2007'
    DVTSLF07 'DENTAL, PAID BY OUT OF POCKET, 2007'
    DVTPHI07 'DENTAL, PAID BY PRIV INSU, 2007'
    DVTMCR07 'DENTAL, PAID BY MEDICARE, 2007'
    DVTMCD07 'DENTAL, PAID BY MEDICAID, 2007'
    DVTTRI07 'DENTAL, PAID BY TRICARE, 2007'
    DVTVA07 'DENTAL, PAID BY VA, 2007'
    DVTWC07 'DENTAL, PAID BY WORKERS COMP, 2007'
    DVTOTP07 'DENTAL, PAID BY OTHER PUBLIC, 2007'
    DVTOSR07 'DENTAL, PAID BY OTHER, 2007'
    OBOEXP07 'OTHER PROVIDER, PAID BY TOTAL, 2007'
    OBOSLF07 'OTHER PROVIDER, BY OUT OF POCKET, 2007'
    OBOPHI07 'OTHER PROVIDER, PAID BY PRIV INSU, 2007'
    OBOMCR07 'OTHER PROVIDER, PAID BY MEDICARE, 2007'
    OBOMCD07 'OTHER PROVIDER, PAID BY MEDICAID, 2007'
    OBOTRI07 'OTHER PROVIDER, PAID BY TRICARE, 2007'
    OBOVA07 'OTHER PROVIDER, PAID BY VA, 2007'
    OBOWC07 'OTHER PROVIDER, BY WORKERS COMP, 2007'
    OBOOTP07 'OTHER PROVIDER, BY OTHER PUBLIC, 2007'
    OBOOSR07 'OTHER PROVIDER, PAID BY OTHER, 2007'
    HHCEXP07 'HOME HEALTH, PAID BY TOTAL, 2007'
    HHCSLF07 'HOME HEALTH, PAID BY OUT OF POCKET, 2007'
    HHCPHI07 'HOME HEALTH, PAID BY PRIV INSU, 2007'
    HHCMCR07 'HOME HEALTH, PAID BY MEDICARE, 2007'
    HHCMCD07 'HOME HEALTH, PAID BY MEDICAID, 2007'
    HHCTRI07 'HOME HEALTH, PAID BY TRICARE, 2007'
    HHCVA07 'HOME HEALTH, PAID BY VA, 2007'
    HHCWC07 'HOME HEALTH, PAID BY WORKERS COMP, 2007'
    HHCOTP07 'HOME HEALTH, PAID BY OTHER PUBLIC, 2007'
    HHCOSR07 'HOME HEALTH, PAID BY OTHER, 2007'
    RXEXP07 'RX, PAID BY TOTAL, 2007'
    RXSLF07 'RX, PAID BY OUT OF POCKET, 2007'
    RXPHI07 'RX, PAID BY PRIV INSU, 2007'
    RXMCR07 'RX, PAID BY MEDICARE, 2007'
    RXMCD07 'RX, PAID BY MEDICAID, 2007'
    RXTRI07 'RX, PAID BY TRICARE, 2007'
    RXVA07 'RX, PAID BY VA, 2007'
    RXWC07 'RX, PAID BY WORKERS COMP, 2007'
    RXOTP07 'RX, PAID BY OTHER PUBLIC, 2007'
    RXOSR07 'RX, PAID BY OTHER, 2007'
    OTHEXP07 'OTHER MEDICAL, PAID BY TOTAL, 2007'
    OTHSLF07 'OTHER MEDICAL, BY OUT OF POCKET, 2007'
    OTHPHI07 'OTHER MEDICAL, PAID BY PRIV INSU, 2007'
    OTHMCR07 'OTHER MEDICAL, PAID BY MEDICARE, 2007'
    OTHMCD07 'OTHER MEDICAL, PAID BY MEDICAID, 2007'
    OTHTRI07 'OTHER MEDICAL, PAID BY TRICARE, 2007'
    OTHVA07 'OTHER MEDICAL, PAID BY VA, 2007'
    OTHWC07 'OTHER MEDICAL, BY WORKERS COMP, 2007'
    OTHOTP07 'OTHER MEDICAL, PAID BY OTHR PUBLIC, 2007'
    OTHOSR07 'OTHER MEDICAL, PAID BY OTHER, 2007'
    WTADJ07 'GROWTH/FERTILITY/MORTALITY ADJ WGT,2007' .
VALUE LABELS 
    DVTEXP07
         -9 '-9 NOT ASCERTAINED'
         0 '0' /
    DVTMCD07
         -9 '-9 NOT ASCERTAINED'
         0 '0' /
    DVTMCR07
         -9 '-9 NOT ASCERTAINED'
         0 '0' /
    DVTOSR07
         -9 '-9 NOT ASCERTAINED'
         0 '0' /
    DVTOTP07
         -9 '-9 NOT ASCERTAINED'
         0 '0' /
    DVTPHI07
         -9 '-9 NOT ASCERTAINED'
         0 '0' /
    DVTSLF07
         -9 '-9 NOT ASCERTAINED'
         0 '0' /
    DVTVA07
         -9 '-9 NOT ASCERTAINED'
         0 '0' /
    HHCEXP07
         -9 '-9 NOT ASCERTAINED'
         0 '0' /
    HHCMCD07
         -9 '-9 NOT ASCERTAINED'
         0 '0' /
    HHCMCR07
         -9 '-9 NOT ASCERTAINED'
         0 '0' /
    HHCOSR07
         -9 '-9 NOT ASCERTAINED'
         0 '0' /
    HHCOTP07
         -9 '-9 NOT ASCERTAINED'
         0 '0' /
    HHCPHI07
         -9 '-9 NOT ASCERTAINED'
         0 '0' /
    HHCSLF07
         -9 '-9 NOT ASCERTAINED'
         0 '0' /
    HHCTRI07
         -9 '-9 NOT ASCERTAINED'
         0 '0' /
    HHCVA07
         -9 '-9 NOT ASCERTAINED'
         0 '0' /
    HOSEXP07
         -9 '-9 NOT ASCERTAINED'
         0 '0' /
    HOSMCD07
         -9 '-9 NOT ASCERTAINED'
         0 '0' /
    HOSMCR07
         -9 '-9 NOT ASCERTAINED'
         0 '0' /
    HOSOSR07
         -9 '-9 NOT ASCERTAINED'
         0 '0' /
    HOSOTP07
         -9 '-9 NOT ASCERTAINED'
         0 '0' /
    HOSPHI07
         -9 '-9 NOT ASCERTAINED'
         0 '0' /
    HOSSLF07
         -9 '-9 NOT ASCERTAINED'
         0 '0' /
    HOSTRI07
         -9 '-9 NOT ASCERTAINED'
         0 '0' /
    HOSVA07
         -9 '-9 NOT ASCERTAINED'
         0 '0' /
    HOSWC07
         -9 '-9 NOT ASCERTAINED'
         0 '0' /
    INSCOV_A
         1 '1 Any Private, employment related or TRICARE'
         2 '2 Any Private, not employment related'
         3 '3 Any Public (Medicaid, SCHIP, Medicare)'
         4 '4 Uninsured for entire year'
         5 '5 Age 65 or older' /
    INSCOV_B
         -1 '-1 Inapplicable (under age 65)'
         1 '1 Held Medicaid and Medicare at same time'
         2 '2 Held Mcare & Priv via emplymnt at same time'
         3 '3 Held Mcare & Priv-nonemplmnt at same time'
         4 '4 Held Medicare alone during the year'
         5 '5 Held no Medicare during the year' /
    MCDHMO
         0 '0 No'
         1 '1 Yes' /
    OBOEXP07
         -9 '-9 NOT ASCERTAINED'
         0 '0' /
    OBOMCD07
         -9 '-9 NOT ASCERTAINED'
         0 '0' /
    OBOMCR07
         -9 '-9 NOT ASCERTAINED'
         0 '0' /
    OBOOSR07
         -9 '-9 NOT ASCERTAINED'
         0 '0' /
    OBOOTP07
         -9 '-9 NOT ASCERTAINED'
         0 '0' /
    OBOPHI07
         -9 '-9 NOT ASCERTAINED'
         0 '0' /
    OBOSLF07
         -9 '-9 NOT ASCERTAINED'
         0 '0' /
    OBOVA07
         -9 '-9 NOT ASCERTAINED'
         0 '0' /
    OBOWC07
         -9 '-9 NOT ASCERTAINED'
         0 '0' /
    OTHEXP07
         -9 '-9 NOT ASCERTAINED'
         0 '0' /
    OTHMCR07
         -9 '-9 NOT ASCERTAINED'
         0 '0' /
    OTHOSR07
         -9 '-9 NOT ASCERTAINED'
         0 '0' /
    OTHOTP07
         -9 '-9 NOT ASCERTAINED'
         0 '0' /
    OTHPHI07
         -9 '-9 NOT ASCERTAINED'
         0 '0' /
    OTHSLF07
         -9 '-9 NOT ASCERTAINED'
         0 '0' /
    OTHWC07
         -9 '-9 NOT ASCERTAINED'
         0 '0' /
    PHYEXP07
         -9 '-9 NOT ASCERTAINED'
         0 '0' /
    PHYMCD07
         -9 '-9 NOT ASCERTAINED'
         0 '0' /
    PHYMCR07
         -9 '-9 NOT ASCERTAINED'
         0 '0' /
    PHYOSR07
         -9 '-9 NOT ASCERTAINED'
         0 '0' /
    PHYOTP07
         -9 '-9 NOT ASCERTAINED'
         0 '0' /
    PHYPHI07
         -9 '-9 NOT ASCERTAINED'
         0 '0' /
    PHYSLF07
         -9 '-9 NOT ASCERTAINED'
         0 '0' /
    PHYTRI07
         -9 '-9 NOT ASCERTAINED'
         0 '0' /
    PHYVA07
         -9 '-9 NOT ASCERTAINED'
         0 '0' /
    PHYWC07
         -9 '-9 NOT ASCERTAINED'
         0 '0' /
    POVCAT
         1 '1 Less than 1.00 times poverty line'
         2 '2 1.01 to 1.24 times poverty line'
         3 '3 1.25 to 1.99 times poverty line'
         4 '4 2.0 to 3.99 times poverty line'
         5 '5 4.00 or more times poverty line' /
    PRVHMO
         0 '0 No'
         1 '1 Yes' /
    RACE7P
         1 '1 Hispanic'
         2 '2 White Alone, NH'
         3 '3 Black Alone, NH'
         4 '4 American Indian and Alaska Native Alone, NH'
         5 '5 Asian Alone, NH'
         6 '6 Native Hawaiian/Pacific Islander Alone, NH'
         7 '7 Two or more Races, NH' /
    RXEXP07
         -9 '-9 NOT ASCERTAINED'
         0 '0' /
    RXMCD07
         -9 '-9 NOT ASCERTAINED'
         0 '0' /
    RXMCR07
         -9 '-9 NOT ASCERTAINED'
         0 '0' /
    RXOSR07
         -9 '-9 NOT ASCERTAINED'
         0 '0' /
    RXOTP07
         -9 '-9 NOT ASCERTAINED'
         0 '0' /
    RXPHI07
         -9 '-9 NOT ASCERTAINED'
         0 '0' /
    RXSLF07
         -9 '-9 NOT ASCERTAINED'
         0 '0' /
    RXTRI07
         -9 '-9 NOT ASCERTAINED'
         0 '0' /
    RXVA07
         -9 '-9 NOT ASCERTAINED'
         0 '0' /
    RXWC07
         -9 '-9 NOT ASCERTAINED'
         0 '0' /
    SEX
         1 '1 Male'
         2 '2 Female' /
    TOTEXP07
         -9 '-9 NOT ASCERTAINED'
         0 '0' /
    TOTMCD07
         -9 '-9 NOT ASCERTAINED'
         0 '0' /
    TOTMCR07
         -9 '-9 NOT ASCERTAINED'
         0 '0' /
    TOTOSR07
         -9 '-9 NOT ASCERTAINED'
         0 '0' /
    TOTOTP07
         -9 '-9 NOT ASCERTAINED'
         0 '0' /
    TOTPHI07
         -9 '-9 NOT ASCERTAINED'
         0 '0' /
    TOTSLF07
         -9 '-9 NOT ASCERTAINED'
         0 '0' /
    TOTTRI07
         -9 '-9 NOT ASCERTAINED'
         0 '0' /
    TOTVA07
         -9 '-9 NOT ASCERTAINED'
         0 '0' /
    TOTWC07
         -9 '-9 NOT ASCERTAINED'
         0 '0' .
EXECUTE.