/* Published: 09/01/2022 */

/***************   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 ccw_chr '/directory/mbsf.chronic.summary.2019.txt';                   /* reading in an un-zipped file */
*filename ccw_chr pipe 'gunzip -c /directory/mbsf.chronic.summary.2019.txt.gz'; /* reading in a zipped file */
*filename ccw_chr pipe 'gunzip -c /directory/mbsf.chronic.summary.*.txt.gz';  /* using wildcard to match multiple files */

options nocenter validvarname=upcase;

data ccw_chron30;
  infile ccw_chr lrecl=290 missover pad;
  input
        @00001 patient_id            $char15. /* Patient ID (for either Cancer or Non-Cancer Patients) */
        @00016 BENE_ENROLLMT_REF_YR             4.
        @00020 ALZH                             1.
        @00021 ALZH_EVER                        $char8.  /*  YYMMDD8  */
        @00029 AMI                              1.
        @00030 AMI_EVER                         $char8.  /*  YYMMDD8  */
        @00038 ANEMIA                           1.
        @00039 ANEMIA_EVER                      $char8.  /*  YYMMDD8  */
        @00047 ASTHMA                           1.
        @00048 ASTHMA_EVER                      $char8.  /*  YYMMDD8  */
        @00056 ATRIAL_FIB                       1.
        @00057 ATRIAL_FIB_EVER                  $char8.  /*  YYMMDD8  */
        @00065 BPH                              1.
        @00066 BPH_EVER                         $char8.  /*  YYMMDD8  */
        @00074 CANCER_BREAST                    1.
        @00075 CANCER_BREAST_EVER               $char8.  /*  YYMMDD8  */
        @00083 CANCER_COLORECTAL                1.
        @00084 CANCER_COLORECTAL_EVER           $char8.  /*  YYMMDD8  */
        @00092 CANCER_ENDOMETRIAL               1.
        @00093 CANCER_ENDOMETRIAL_EVER          $char8.  /*  YYMMDD8  */
        @00101 CANCER_LUNG                      1.
        @00102 CANCER_LUNG_EVER                 $char8.  /*  YYMMDD8  */
        @00110 CANCER_PROSTATE                  1.
        @00111 CANCER_PROSTATE_EVER             $char8.  /*  YYMMDD8  */
        @00119 CANCER_UROLOGIC                  1.
        @00120 CANCER_UROLOGIC_EVER             $char8.  /*  YYMMDD8  */
        @00128 CATARACT                         1.
        @00129 CATARACT_EVER                    $char8.  /*  YYMMDD8  */
        @00137 CHRONICKIDNEY                    1.
        @00138 CHRONICKIDNEY_EVER               $char8.  /*  YYMMDD8  */
        @00146 COPD                             1.
        @00147 COPD_EVER                        $char8.  /*  YYMMDD8  */
        @00155 DEPRESSION                       1.
        @00156 DEPRESSION_EVER                  $char8.  /*  YYMMDD8  */
        @00164 DIABETES                         1.
        @00165 DIABETES_EVER                    $char8.  /*  YYMMDD8  */
        @00173 GLAUCOMA                         1.
        @00174 GLAUCOMA_EVER                    $char8.  /*  YYMMDD8  */
        @00182 HF                               1.
        @00183 HF_EVER                          $char8.  /*  YYMMDD8  */
        @00191 HIP_FRACTURE                     1.
        @00192 HIP_FRACTURE_EVER                $char8.  /*  YYMMDD8  */
        @00200 HLP                              1.
        @00201 HLP_EVER                         $char8.  /*  YYMMDD8  */
        @00209 HTN                              1.
        @00210 HTN_EVER                         $char8.  /*  YYMMDD8  */
        @00218 HYPTHYRD                         1.
        @00219 HYPTHYRD_EVER                    $char8.  /*  YYMMDD8  */
        @00227 ISCHEMICHEART                    1.
        @00228 ISCHEMICHEART_EVER               $char8.  /*  YYMMDD8  */
        @00236 NONALZH_DEMEN                    1.
        @00237 NONALZH_DEMEN_EVER               $char8.  /*  YYMMDD8  */
        @00245 OSTEOPOROSIS                     1.
        @00246 OSTEOPOROSIS_EVER                $char8.  /*  YYMMDD8  */
        @00254 PNEUMO                           1.
        @00255 PNEUMO_EVER                      $char8.  /*  YYMMDD8  */
        @00263 PRKNSN                           1.
        @00264 PRKNSN_EVER                      $char8.  /*  YYMMDD8  */
        @00272 RA_OA                            1.
        @00273 RA_OA_EVER                       $char8.  /*  YYMMDD8  */
        @00281 STROKE_TIA                       1.
        @00282 STROKE_TIA_EVER                  $char8.  /*  YYMMDD8  */
    ;

  label
        PATIENT_ID                       = "Patient ID"
        BENE_ENROLLMT_REF_YR             = "Reference Year"
        ALZH                             = "Alzheimer's Disease End-of-Year Indicator"
        ALZH_EVER                        = "First Occurrence of Alzheimer's Disease"
        AMI                              = "Acute Myocardial Infarction End-of-Year Indicator"
        AMI_EVER                         = "First Occurrence of Acute Myocardial Infarction"
        ANEMIA                           = "Anemia End-of-Year Indicator"
        ANEMIA_EVER                      = "First Occurrence of Anemia"
        ASTHMA                           = "Asthma End-of-Year Indicator"
        ASTHMA_EVER                      = "First Occurrence of Asthma"
        ATRIAL_FIB                       = "Atrial Fibrillation and Flutter End-of-Year Indicator"
        ATRIAL_FIB_EVER                  = "First Occurrence of Atrial Fibrillation and Flutter"
        BPH                              = "Benign Prostatic Hyperplasia End-of-Year Indicator"
        BPH_EVER                         = "First Occurrence of Benign Prostatic Hyperplasia"
        CANCER_BREAST                    = "Breast Cancer End-of-Year Indicator"
        CANCER_BREAST_EVER               = "First Occurrence of Breast Cancer"
        CANCER_COLORECTAL                = "Colorectal Cancer End-of-Year Indicator"
        CANCER_COLORECTAL_EVER           = "First Occurrence of Colorectal Cancer"
        CANCER_ENDOMETRIAL               = "Endometrial Cancer End-of-Year Indicator"
        CANCER_ENDOMETRIAL_EVER          = "First Occurrence of Endometrial Cancer"
        CANCER_LUNG                      = "Lung Cancer End-of-Year Indicator"
        CANCER_LUNG_EVER                 = "First Occurrence of Lung Cancer"
        CANCER_PROSTATE                  = "Prostate Cancer End-of-Year Indicator"
        CANCER_PROSTATE_EVER             = "First Occurrence of Prostate Cancer"
        CANCER_UROLOGIC                  = "Urologic Cancer (Kidney, Renal Pelvis and Ureter) End-of-Year Indicator"
        CANCER_UROLOGIC_EVER             = "First Occurrence of Urologic Cancer (Kidney, Renal Pelvis and Ureter)"
        CATARACT                         = "Cataract End-of-Year Indicator"
        CATARACT_EVER                    = "First Occurrence of Cataract"
        CHRONICKIDNEY                    = "Chronic Kidney Disease End-of-Year Indicator"
        CHRONICKIDNEY_EVER               = "First Occurrence of Chronic Kidney Disease"
        COPD                             = "Chronic Obstructive Pulmonary Disease End-of-Year Indicator"
        COPD_EVER                        = "First Occurrence of Chronic Obstructive Pulmonary Disease"
        DEPRESSION                       = "Depression, Bipolar or Other Depressive Mood Disorders End-of-Year Indicator"
        DEPRESSION_EVER                  = "First Occurrence of Depression, Bipolar or Other Depressive Mood Disorders"
        DIABETES                         = "Diabetes End-of-Year Indicator"
        DIABETES_EVER                    = "First Occurrence of Diabetes"
        GLAUCOMA                         = "Glaucoma End-of-Year Indicator"
        GLAUCOMA_EVER                    = "First Occurrence of Glaucoma"
        HF                               = "Heart Failure and Non-Ischemic Heart Disease End-of-Year Indicator"
        HF_EVER                          = "First Occurrence of Heart Failure and Non-Ischemic Heart Disease"
        HIP_FRACTURE                     = "Hip/Pelvic Fracture End-of-Year Indicator"
        HIP_FRACTURE_EVER                = "First Occurrence of Hip/Pelvic Fracture"
        HLP                              = "Hyperlipidemia End-of-Year Indicator"
        HLP_EVER                         = "First Occurrence of Hyperlipidemia"
        HTN                              = "Hypertension End-of-Year Indicator"
        HTN_EVER                         = "First Occurrence of Hypertension"
        HYPTHYRD                         = "Hypothyroidism End-of-Year Indicator"
        HYPTHYRD_EVER                    = "First Occurrence of Hypothyroidism"
        ISCHEMICHEART                    = "Ischemic Heart Disease End-of-Year Indicator"
        ISCHEMICHEART_EVER               = "First Occurrence of Ischemic Heart Disease"
        NONALZH_DEMEN                    = "Non-Alzheimer's Dementia End-of-Year Indicator"
        NONALZH_DEMEN_EVER               = "First Occurrence of Non-Alzheimer's Dementia"
        OSTEOPOROSIS                     = "Osteoporosis With or Without Pathological Fracture End-of-Year Indicator"
        OSTEOPOROSIS_EVER                = "First Occurrence of Osteoporosis With or Without Pathological Fracture"
        PNEUMO                           = "All Cause Pneumonia End-of-Year Indicator"
        PNEUMO_EVER                      = "First Occurrence of All Cause Pneumonia"
        PRKNSN                           = "Parkinson's Disease and Secondary Parkinsonism End-of-Year Indicator"
        PRKNSN_EVER                      = "First Occurrence of Parkinson's Disease and Secondary Parkinsonism"
        RA_OA                            = "Rheumatoid Arthritis / Osteoarthritis End-of-Year Indicator"
        RA_OA_EVER                       = "First Occurrence of Rheumatoid Arthritis / Osteoarthritis"
        STROKE_TIA                       = "Stroke / Transient Ischemic Attack End-of-Year Indicator"
        STROKE_TIA_EVER                  = "First Occurrence of Stroke / Transient Ischemic Attack"
    ;

run;

proc contents data=ccw_chron30 position;
run;