/*****************************************************************************/
/*  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="H248G.DAT"  /LRECL=211.
DATA LIST FILE=INFILE /
    DUID 1-7  
    PID 8-10  
    DUPERSID 11-20 (A)
    EVNTIDX 21-36 (A)
    EVENTRN 37-37  
    FFEEIDX 38-51 (A)
    PANEL 52-53  
    MPCELIG 54-54  
    MPCDATA 55-55  
    OBDATEYR 56-59  
    OBDATEMM 60-61  
    SEEDOC_M18 62-63  
    DRSPLTY_M18 64-65  
    MEDPTYPE_M18 66-67  
    DOCATLOC 68-69  
    VSTCTGRY 70-72  
    VSTRELCN_M18 73-74  
    LABTEST_M18 75-76  
    SONOGRAM_M18 77-78  
    XRAYS_M18 79-80  
    MAMMOG_M18 81-82  
    MRI_M18 83-84  
    EKG_M18 85-86  
    RCVVAC_M18 87-88  
    SURGPROC 89-90  
    MEDPRESC 91-93  
    TELEHEALTHFLAG 94-94  
    VISITTYPE 95-96  
    FFOBTYPE 97-98  
    OBSF23X 99-106 (2)
    OBMR23X 107-114 (2)
    OBMD23X 115-122 (2)
    OBPV23X 123-130 (2)
    OBVA23X 131-138 (2)
    OBTR23X 139-146 (2)
    OBOF23X 147-153 (2)
    OBSL23X 154-160 (2)
    OBWC23X 161-168 (2)
    OBOT23X 169-175 (2)
    OBXP23X 176-183 (2)
    OBTC23X 184-192 (2)
    IMPFLAG 193-193  
    PERWT23F 194-206 (6)
    VARSTR 207-210  
    VARPSU 211-211   .
VARIABLE LABEL 
    DUID "PANEL # + ENCRYPTED DU IDENTIFIER"
    PID "PERSON NUMBER"
    DUPERSID "PERSON ID (DUID + PID)"
    EVNTIDX "EVENT ID"
    EVENTRN "EVENT ROUND NUMBER"
    FFEEIDX "FLAT FEE ID"
    PANEL "PANEL NUMBER"
    MPCELIG "MPC ELIGIBILITY FLAG"
    MPCDATA "MPC DATA FLAG"
    OBDATEYR "EVENT DATE - YEAR"
    OBDATEMM "EVENT DATE - MONTH"
    SEEDOC_M18 "DID P TALK TO MD THIS VISIT"
    DRSPLTY_M18 "MVIS DOCTOR S SPECIALTY"
    MEDPTYPE_M18 "TYPE OF MED PERSON P TALKED TO ON VISIT DT"
    DOCATLOC "ANY MD WORK AT LOCATION WHERE P SAW PROV"
    VSTCTGRY "BEST CATEGORY FOR CARE P RECV ON VISIT DT"
    VSTRELCN_M18 "THIS VISIT RELATED TO SPEC COND"
    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"
    TELEHEALTHFLAG "IS THIS A TELEHEALTH EVENT"
    VISITTYPE "TYPE OF TELEHEALTH VISIT"
    FFOBTYPE "FLAT FEE BUNDLE"
    OBSF23X "AMOUNT PAID, FAMILY (IMPUTED)"
    OBMR23X "AMOUNT PAID, MEDICARE (IMPUTED)"
    OBMD23X "AMOUNT PAID, MEDICAID (IMPUTED)"
    OBPV23X "AMOUNT PAID, PRIVATE INSURANCE (IMPUTED)"
    OBVA23X "AMOUNT PAID, VETERANS/CHAMPVA (IMPUTED)"
    OBTR23X "AMOUNT PAID, TRICARE (IMPUTED)"
    OBOF23X "AMOUNT PAID, OTHER FEDERAL (IMPUTED)"
    OBSL23X "AMOUNT PAID, STATE & LOCAL GOV (IMPUTED)"
    OBWC23X "AMOUNT PAID, WORKERS COMP (IMPUTED)"
    OBOT23X "AMOUNT PAID, OTHER INSURANCE (IMPUTED)"
    OBXP23X "SUM OF OBSF23X - OBOT23X (IMPUTED)"
    OBTC23X "HHLD REPORTED TOTAL CHARGE (IMPUTED)"
    IMPFLAG "IMPUTATION STATUS"
    PERWT23F "EXPENDITURE FILE PERSON WEIGHT, 2023"
    VARSTR "VARIANCE ESTIMATION STRATUM, 2023"
    VARPSU "VARIANCE ESTIMATION PSU, 2023" .
VALUE LABELS 
    DOCATLOC
         -1 "-1 INAPPLICABLE"
         -7 "-7 REFUSED"
         -8 "-8 DON'T KNOW"
         1 "1 YES"
         2 "2 NO" /
    DRSPLTY_M18
         -1 "-1 INAPPLICABLE"
         -7 "-7 REFUSED"
         -8 "-8 DON'T KNOW"
         1 "1 ALLERGY/IMMUNOLOGY"
         10 "10 GERIATRICS (ELDERLY)"
         11 "11 GYNECOLOGY/OBSTETRICS"
         12 "12 HEMATOLOGY (BLOOD)"
         13 "13 HOSPITAL RESIDENCE"
         14 "14 INTERNAL MEDICINE (INTERNIST)"
         15 "15 NEPHROLOGY (KIDNEYS)"
         16 "16 NEUROLOGY"
         18 "18 ONCOLOGY (TUMORS, CANCER)"
         19 "19 OPHTHALMOLOGY (EYES)"
         2 "2 ANESTHESIOLOGY"
         20 "20 ORTHOPEDICS"
         21 "21 OSTEOPATHY (DO)"
         22 "22 OTORHINOLARYNGOLOGY (EAR, NOSE, THROAT)"
         23 "23 PATHOLOGY"
         24 "24 PEDIATRICIAN"
         25 "25 PHYSICAL MEDICINE/REHAB"
         26 "26 PLASTIC SURGERY"
         27 "27 PROCTOLOGY"
         28 "28 PSYCHIATRY/PSYCHIATRIST"
         29 "29 PULMONARY"
         3 "3 CARDIOLOGY (HEART)"
         30 "30 RADIOLOGY"
         31 "31 RHEUMATOLOGY (ARTHRITIS)"
         32 "32 THORACIC SURGERY (CHEST)"
         33 "33 UROLOGY"
         4 "4 DERMATOLOGY (SKIN)"
         5 "5 ENDOCRINOLOGY/METABOLISM (DIABETES, THYROID)"
         6 "6 FAMILY PRACTICE"
         7 "7 GASTROENTEROLOGY"
         8 "8 GENERAL PRACTICE"
         9 "9 GENERAL SURGERY"
         91 "91 OTHER DR SPECIALTY" /
    EKG_M18
         -1 "-1 INAPPLICABLE"
         -7 "-7 REFUSED"
         -8 "-8 DON'T KNOW"
         1 "1 YES"
         2 "2 NO"
         95 "95 NO SERVICES RECEIVED" /
    EVENTRN
         1 "1 ROUND 1"
         2 "2 ROUND 2"
         3 "3 ROUND 3"
         4 "4 ROUND 4"
         5 "5 ROUND 5" /
    FFOBTYPE
         -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" /
    LABTEST_M18
         -1 "-1 INAPPLICABLE"
         -7 "-7 REFUSED"
         -8 "-8 DON'T KNOW"
         1 "1 YES"
         2 "2 NO"
         95 "95 NO SERVICES RECEIVED" /
    MAMMOG_M18
         -1 "-1 INAPPLICABLE"
         -7 "-7 REFUSED"
         -8 "-8 DON'T KNOW"
         1 "1 YES"
         2 "2 NO"
         95 "95 NO SERVICES RECEIVED" /
    MEDPRESC
         -15 "-15 CANNOT BE COMPUTED"
         -7 "-7 REFUSED"
         -8 "-8 DON'T KNOW"
         1 "1 YES"
         2 "2 NO" /
    MEDPTYPE_M18
         -1 "-1 INAPPLICABLE"
         -15 "-15 CANNOT BE COMPUTED"
         -7 "-7 REFUSED"
         -8 "-8 DON'T KNOW"
         1 "1 ACUPUNCTURIST"
         10 "10 PHYSICAL/OCCUPATIONAL THERAPIST"
         11 "11 PHYSICIAN'S ASSISTANT"
         12 "12 PODIATRIST"
         13 "13 PSYCHOLOGIST"
         14 "14 SOCIAL WORKER"
         15 "15 TECHNICIAN"
         2 "2 CHIROPRACTOR"
         3 "3 DENTIST/DENTAL CARE PERSON"
         4 "4 ALTERNATIVE MEDICINE PROVIDER"
         5 "5 MASSAGE THERAPIST"
         6 "6 MENTAL HLTH CNSLR/MARITAL OR FAM THERAPIST"
         7 "7 MIDWIFE"
         8 "8 NURSE/NURSE PRACTITIONER"
         9 "9 OPTOMETRIST"
         91 "91 OTHER" /
    MPCDATA
         1 "1 HAS MPC DATA"
         2 "2 NO MPC DATA" /
    MPCELIG
         1 "1 MPC ELIGIBLE"
         2 "2 NOT MPC ELIGIBLE" /
    MRI_M18
         -1 "-1 INAPPLICABLE"
         -7 "-7 REFUSED"
         -8 "-8 DON'T KNOW"
         1 "1 YES"
         2 "2 NO"
         95 "95 NO SERVICES RECEIVED" /
    OBDATEMM
         -7 "-7 REFUSED"
         -8 "-8 DON'T KNOW" /
    OBDATEYR
         -7 "-7 REFUSED"
         -8 "-8 DON'T KNOW"
         2023 "2023" /
    PANEL
         27 "27 PANEL 27"
         28 "28 PANEL 28" /
    RCVVAC_M18
         -1 "-1 INAPPLICABLE"
         -7 "-7 REFUSED"
         -8 "-8 DON'T KNOW"
         1 "1 YES"
         2 "2 NO"
         95 "95 NO SERVICES RECEIVED" /
    SEEDOC_M18
         -7 "-7 REFUSED"
         -8 "-8 DON'T KNOW"
         1 "1 YES"
         2 "2 NO" /
    SONOGRAM_M18
         -1 "-1 INAPPLICABLE"
         -7 "-7 REFUSED"
         -8 "-8 DON'T KNOW"
         1 "1 YES"
         2 "2 NO"
         95 "95 NO SERVICES RECEIVED" /
    SURGPROC
         -1 "-1 INAPPLICABLE"
         -7 "-7 REFUSED"
         -8 "-8 DON'T KNOW"
         1 "1 YES"
         2 "2 NO" /
    TELEHEALTHFLAG
         -15 "-15 CANNOT BE COMPUTED"
         1 "1 YES"
         2 "2 NO" /
    VISITTYPE
         -1 "-1 INAPPLICABLE"
         -7 "-7 REFUSED"
         -8 "-8 DON'T KNOW"
         1 "1 PHONE"
         2 "2 VIDEO"
         3 "3 SOME OTHER WAY" /
    VSTCTGRY
         -15 "-15 CANNOT BE COMPUTED"
         -7 "-7 REFUSED"
         -8 "-8 DON'T KNOW"
         1 "1 GENERAL CHECKUP"
         10 "10 LASER EYE SURGERY"
         2 "2 DIAGNOSIS OR TREATMENT"
         3 "3 EMERGENCY (E.G., ACCIDENT OR INJURY)"
         4 "4 PSYCHOTHERAPY/MENTAL HEALTH COUNSELING"
         5 "5 FOLLOW-UP OR POST-OPERATIVE VISIT"
         6 "6 IMMUNIZATIONS OR SHOTS"
         7 "7 VISION EXAM"
         8 "8 PREGNANCY-RELATED (INC PRENATAL/ DELV)"
         9 "9 WELL CHILD EXAM"
         91 "91 OTHER" /
    VSTRELCN_M18
         -7 "-7 REFUSED"
         -8 "-8 DON'T KNOW"
         1 "1 YES"
         2 "2 NO" /
    XRAYS_M18
         -1 "-1 INAPPLICABLE"
         -7 "-7 REFUSED"
         -8 "-8 DON'T KNOW"
         1 "1 YES"
         2 "2 NO"
         95 "95 NO SERVICES RECEIVED" .
EXECUTE.