/* Published: 03/01/2021 */

/***************   IMPORTANT PROGRAMING NOTES   ************************/
/*                                                                     */
/* If you are using PC SAS to read in these files you will have to     */
/* un-zip the files first and use the un-zipped filename statement,    */
/* rather than using the zipped files and statement.                   */
/*                                                                     */
/***********************************************************************/

*filename oth_cc '/directory/mbsf.oth.cc.summary.2019.txt';                   /* reading in an un-zipped file */
*filename oth_cc pipe 'gunzip -c /directory/mbsf.oth.cc.summary.2019.txt.gz'; /* reading in a zipped file */
*filename oth_cc pipe 'gunzip -c /directory/mbsf.oth.cc.summary.*.txt.gz';  /* using wildcard to match multiple files */

options nocenter validvarname=upcase;

data oth_cc;
  infile oth_cc lrecl=382 missover pad;
  input
        @00001 patient_id            $char15. /* Patient ID (for either Cancer or Non-Cancer Patients) */
        @00016 RFRNC_YR                         4.         /* BENE_ENROLLMT_REF_YR             */
        @00020 ENRL_SRC                         $3.        /* ENRL_SRC                         */
        @00023 ACP_MEDICARE                     1.
        @00024 ACP_MEDICARE_EVER                $char8.  /*  YYMMDD8  */
        @00032 ALCO_MEDICARE                    1.
        @00033 ALCO_MEDICARE_EVER               $char8.  /*  YYMMDD8  */
        @00041 ANXI_MEDICARE                    1.
        @00042 ANXI_MEDICARE_EVER               $char8.  /*  YYMMDD8  */
        @00050 AUTISM_MEDICARE                  1.
        @00051 AUTISM_MEDICARE_EVER             $char8.  /*  YYMMDD8  */
        @00059 BIPL_MEDICARE                    1.
        @00060 BIPL_MEDICARE_EVER               $char8.  /*  YYMMDD8  */
        @00068 BRAINJ_MEDICARE                  1.
        @00069 BRAINJ_MEDICARE_EVER             $char8.  /*  YYMMDD8  */
        @00077 CERPAL_MEDICARE                  1.
        @00078 CERPAL_MEDICARE_EVER             $char8.  /*  YYMMDD8  */
        @00086 CYSFIB_MEDICARE                  1.
        @00087 CYSFIB_MEDICARE_EVER             $char8.  /*  YYMMDD8  */
        @00095 DEPSN_MEDICARE                   1.
        @00096 DEPSN_MEDICARE_EVER              $char8.  /*  YYMMDD8  */
        @00104 DRUG_MEDICARE                    1.
        @00105 DRUG_MEDICARE_EVER               $char8.  /*  YYMMDD8  */
        @00113 EPILEP_MEDICARE                  1.
        @00114 EPILEP_MEDICARE_EVER             $char8.  /*  YYMMDD8  */
        @00122 FIBRO_MEDICARE                   1.
        @00123 FIBRO_MEDICARE_EVER              $char8.  /*  YYMMDD8  */
        @00131 HEARIM_MEDICARE                  1.
        @00132 HEARIM_MEDICARE_EVER             $char8.  /*  YYMMDD8  */
        @00140 HEPVIRAL_MEDICARE                1.
        @00141 HEPVIRAL_MEDICARE_EVER           $char8.  /*  YYMMDD8  */
        @00149 HIVAIDS_MEDICARE                 1.
        @00150 HIVAIDS_MEDICARE_EVER            $char8.  /*  YYMMDD8  */
        @00158 INTDIS_MEDICARE                  1.
        @00159 INTDIS_MEDICARE_EVER             $char8.  /*  YYMMDD8  */
        @00167 LEADIS_MEDICARE                  1.
        @00168 LEADIS_MEDICARE_EVER             $char8.  /*  YYMMDD8  */
        @00176 LEUKLYMPH_MEDICARE               1.
        @00177 LEUKLYMPH_MEDICARE_EVER          $char8.  /*  YYMMDD8  */
        @00185 LIVER_MEDICARE                   1.
        @00186 LIVER_MEDICARE_EVER              $char8.  /*  YYMMDD8  */
        @00194 MIGRAINE_MEDICARE                1.
        @00195 MIGRAINE_MEDICARE_EVER           $char8.  /*  YYMMDD8  */
        @00203 MOBIMP_MEDICARE                  1.
        @00204 MOBIMP_MEDICARE_EVER             $char8.  /*  YYMMDD8  */
        @00212 MULSCL_MEDICARE                  1.
        @00213 MULSCL_MEDICARE_EVER             $char8.  /*  YYMMDD8  */
        @00221 MUSDYS_MEDICARE                  1.
        @00222 MUSDYS_MEDICARE_EVER             $char8.  /*  YYMMDD8  */
        @00230 OBESITY_MEDICARE                 1.
        @00231 OBESITY_MEDICARE_EVER            $char8.  /*  YYMMDD8  */
        @00239 OTHDEL_MEDICARE                  1.
        @00240 OTHDEL_MEDICARE_EVER             $char8.  /*  YYMMDD8  */
        @00248 OUD_ANY_MEDICARE                 1.
        @00249 OUD_ANY_MEDICARE_EVER            $char8.  /*  YYMMDD8  */
        @00257 OUD_DX_MEDICARE                  1.
        @00258 OUD_DX_MEDICARE_EVER             $char8.  /*  YYMMDD8  */
        @00266 OUD_HOSP_MEDICARE                1.
        @00267 OUD_HOSP_MEDICARE_EVER           $char8.  /*  YYMMDD8  */
        @00275 OUD_MAT_MEDICARE                 1.
        @00276 OUD_MAT_MEDICARE_EVER            $char8.  /*  YYMMDD8  */
        @00284 PSDS_MEDICARE                    1.
        @00285 PSDS_MEDICARE_EVER               $char8.  /*  YYMMDD8  */
        @00293 PTRA_MEDICARE                    1.
        @00294 PTRA_MEDICARE_EVER               $char8.  /*  YYMMDD8  */
        @00302 PVD_MEDICARE                     1.
        @00303 PVD_MEDICARE_EVER                $char8.  /*  YYMMDD8  */
        @00311 SCD_MEDICARE                     1.
        @00312 SCD_MEDICARE_EVER                $char8.  /*  YYMMDD8  */
        @00320 SCHI_MEDICARE                    1.
        @00321 SCHI_MEDICARE_EVER               $char8.  /*  YYMMDD8  */
        @00329 SCHIOT_MEDICARE                  1.
        @00330 SCHIOT_MEDICARE_EVER             $char8.  /*  YYMMDD8  */
        @00338 SPIBIF_MEDICARE                  1.
        @00339 SPIBIF_MEDICARE_EVER             $char8.  /*  YYMMDD8  */
        @00347 SPIINJ_MEDICARE                  1.
        @00348 SPIINJ_MEDICARE_EVER             $char8.  /*  YYMMDD8  */
        @00356 TOBA_MEDICARE                    1.
        @00357 TOBA_MEDICARE_EVER               $char8.  /*  YYMMDD8  */
        @00365 ULCERS_MEDICARE                  1.
        @00366 ULCERS_MEDICARE_EVER             $char8.  /*  YYMMDD8  */
        @00374 VISUAL_MEDICARE                  1.
        @00375 VISUAL_MEDICARE_EVER             $char8.  /*  YYMMDD8  */
    ;

  label
        PATIENT_ID                       = "Patient ID"
        RFRNC_YR                         = "Beneficiary Enrollment Reference Year"
        ENRL_SRC                         = "Enrollment Source"
        ACP_MEDICARE                     = "ADHD and Other Conduct Disorders"
        ACP_MEDICARE_EVER                = "ADHD and Other Conduct Disorders First Ever Occurrence Date"
        ALCO_MEDICARE                    = "Alcohol Use Disorders"
        ALCO_MEDICARE_EVER               = "Alcohol Use Disorders First Ever Occurrence Date"
        ANXI_MEDICARE                    = "Anxiety Disorders"
        ANXI_MEDICARE_EVER               = "Anxiety Disorders First Ever Occurrence Date"
        AUTISM_MEDICARE                  = "Autism Spectrum Disorders"
        AUTISM_MEDICARE_EVER             = "Autism Spectrum Disorders First Ever Occurrence Date"
        BIPL_MEDICARE                    = "Bipolar Disorder"
        BIPL_MEDICARE_EVER               = "Bipolar Disorder First Ever Occurrence Date"
        BRAINJ_MEDICARE                  = "Traumatic Brain Injury and Nonpsychotic Mental Disorders due to Brain Damage"
        BRAINJ_MEDICARE_EVER             = "TBI & Nonpsychotic Mental Disorders due to Brain Damage 1st Ever Occurrence Date"
        CERPAL_MEDICARE                  = "Cerebral Palsy"
        CERPAL_MEDICARE_EVER             = "Cerebral Palsy First Ever Occurrence Date"
        CYSFIB_MEDICARE                  = "Cystic Fibrosis and Other Metabolic Developmental Disorders"
        CYSFIB_MEDICARE_EVER             = "Cystic Fibrosis & Oth Metabolic Developmental Disorders 1st Ever Occurrence Date"
        DEPSN_MEDICARE                   = "TO10 Depression"
        DEPSN_MEDICARE_EVER              = "TO10 Depression First Ever Occurrence Date"
        DRUG_MEDICARE                    = "Drug Use"
        DRUG_MEDICARE_EVER               = "Drug Use First Ever Occurrence Date"
        EPILEP_MEDICARE                  = "Epilepsy"
        EPILEP_MEDICARE_EVER             = "Epilepsy First Ever Occurrence Date"
        FIBRO_MEDICARE                   = "Chronic Pain Fatigue and Fibromyalgia"
        FIBRO_MEDICARE_EVER              = "Chronic Pain Fatigue and Fibromyalgia First Ever Occurrence Date"
        HEARIM_MEDICARE                  = "Sensory - Deafness and Hearing Impairment"
        HEARIM_MEDICARE_EVER             = "Sensory - Deafness and Hearing Impairment First Ever Occurrence Date"
        HEPVIRAL_MEDICARE                = "Viral Hepatitis (General)"
        HEPVIRAL_MEDICARE_EVER           = "Viral Hepatitis (General) First Ever Occurrence Date"
        HIVAIDS_MEDICARE                 = "HIV/AIDS"
        HIVAIDS_MEDICARE_EVER            = "HIV/AIDS First Ever Occurrence Date"
        INTDIS_MEDICARE                  = "Intellectual Disabilities and Related Conditions"
        INTDIS_MEDICARE_EVER             = "Intellectual Disabilities and Related Conditions First Ever Occurrence Date"
        LEADIS_MEDICARE                  = "Learning Disabilities"
        LEADIS_MEDICARE_EVER             = "Learning Disabilities First Ever Occurrence Date"
        LEUKLYMPH_MEDICARE               = "Leukemias and Lymphomas"
        LEUKLYMPH_MEDICARE_EVER          = "Leukemias and Lymphomas First Ever Occurrence Date"
        LIVER_MEDICARE                   = "Liver Disease Cirrhosis & Oth Liver Cond (excl Hepatitis)"
        LIVER_MEDICARE_EVER              = "Liver Disease Cirrhosis & Oth Liver Cond (excl Hepatitis) 1st Ever Occur Date"
        MIGRAINE_MEDICARE                = "Migraine and other Chronic Headache"
        MIGRAINE_MEDICARE_EVER           = "Migraine and other Chronic Headache First Ever Occurrence Date"
        MOBIMP_MEDICARE                  = "Mobility Impairments"
        MOBIMP_MEDICARE_EVER             = "Mobility Impairments First Ever Occurrence Date"
        MULSCL_MEDICARE                  = "Multiple Sclerosis and Transverse Myelitis"
        MULSCL_MEDICARE_EVER             = "Multiple Sclerosis and Transverse Myelitis First Ever Occurrence Date"
        MUSDYS_MEDICARE                  = "Muscular Dystrophy"
        MUSDYS_MEDICARE_EVER             = "Muscular Dystrophy First Ever Occurrence Date"
        OBESITY_MEDICARE                 = "Obesity"
        OBESITY_MEDICARE_EVER            = "Obesity First Ever Occurrence Date"
        OTHDEL_MEDICARE                  = "Other Developmental Delays"
        OTHDEL_MEDICARE_EVER             = "Other Developmental Delays First Ever Occurrence Date"
        OUD_ANY_MEDICARE                 = "Overarching OUD Disorder (Any of the Three Sub-Indicators) - Medicare Only Claim"
        OUD_ANY_MEDICARE_EVER            = "Overarching OUD Disorder (Any of the Three Sub-Indicators) - First Ever Occurren"
        OUD_DX_MEDICARE                  = "Diagnosis and Procedure Basis for OUD - Medicare Only Claims"
        OUD_DX_MEDICARE_EVER             = "Diagnosis and Procedure Basis for OUD First Ever Occurrence Date - Medicare Only"
        OUD_HOSP_MEDICARE                = "Opioid-Related Hospitalization or ED - Medicare Only Claims"
        OUD_HOSP_MEDICARE_EVER           = "Opioid-Related Hospitalization or ED First Ever Occurrence Date - Medicare Only"
        OUD_MAT_MEDICARE                 = "Use of Medication-Assisted Treatment (MAT) - Medicare Only Claims"
        OUD_MAT_MEDICARE_EVER            = "Use of Medication-Assisted Treatment (MAT) First Ever Occurrence Date - Medicare"
        PSDS_MEDICARE                    = "Personality Disorders"
        PSDS_MEDICARE_EVER               = "Personality Disorders First Ever Occurrence Date"
        PTRA_MEDICARE                    = "Post-Traumatic Stress Disorder"
        PTRA_MEDICARE_EVER               = "Post-Traumatic Stress Disorder First Ever Occurrence Date"
        PVD_MEDICARE                     = "Peripheral Vascular Disease"
        PVD_MEDICARE_EVER                = "Peripheral Vascular Disease First Ever Occurrence Date"
        SCD_MEDICARE                     = "Sickle Cell Disease - Medicare Only Claims"
        SCD_MEDICARE_EVER                = "Sickle Cell Disease First Ever Occurrence Date - Medicare Only Claims"
        SCHI_MEDICARE                    = "Schizophrenia"
        SCHI_MEDICARE_EVER               = "Schizophrenia First Ever Occurrence Date"
        SCHIOT_MEDICARE                  = "Schizophrenia and Other Psychotic Disorders"
        SCHIOT_MEDICARE_EVER             = "Schizophrenia and Other Psychotic Disorders First Ever Occurrence Date"
        SPIBIF_MEDICARE                  = "Spina Bifida & Oth Congenital Anomalies Nervous Sys"
        SPIBIF_MEDICARE_EVER             = "Spina Bifida & Oth Congenital Anomalies Nervous Sys 1st Ever Occurrence Date"
        SPIINJ_MEDICARE                  = "Spinal Cord Injury"
        SPIINJ_MEDICARE_EVER             = "Spinal Cord Injury First Ever Occurrence Date"
        TOBA_MEDICARE                    = "Tobacco Use Disorders"
        TOBA_MEDICARE_EVER               = "Tobacco Use Disorders First Ever Occurrence Date"
        ULCERS_MEDICARE                  = "Pressure Ulcers and Chronic Ulcers"
        ULCERS_MEDICARE_EVER             = "Pressure Ulcers and Chronic Ulcers First Ever Occurrence Date"
        VISUAL_MEDICARE                  = "Sensory - Blindness and Visual Impairment"
        VISUAL_MEDICARE_EVER             = "Sensory - Blindness and Visual Impairment First Ever Occurrence Date"
    ;

run;

proc contents data=oth_cc position;
run;