/* Published: 03/11/2024 */

/**************************   COMMENTS   *******************************/
/* THIS INPUT STATMENT IS FOR THE 2022 SEER-MEDICARE LINKAGE.          */
/***********************************************************************/

/***************   IMPORTANT PROGRAMING NOTES   ************************/
/*               TO IDENTIFY CLAIMS PER PATIENT                        */
/*                                                                     */
/* The Patient ID and ENC_JOIN_KEY ID (column 16/18) should be used to */
/* identify all the records for each claim per patient.  Both are      */
/* needed to identify a claim.                                         */
/***********************************************************************/
/* Six segments are provided for the SNF claims files: base            */
/* (claims), revenue, condition, occurrence, span and value.           */
/* This version has the long SAS version 8 variable names.             */
/* The Patient ID and Claim ID (column 16) should be used to merge     */
/* these files.                                                        */
/***********************************************************************/
/* 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 snfbase '/directory/snf2019.base.enc.txt';                    /* reading in an un-zipped file* /
*filename snfbase pipe 'gunzip -c /directory/snf2019.base.enc.txt.gz';  /* reading in a zipped file */
*filename snfbase pipe 'gunzip -c /directory/snf*.base.enc.txt.gz';   /* using wildcard to match multiple files */

options nocenter validvarname=upcase;

data snfbase_enc;
  infile snfbase lrecl=860 missover pad;
  input
        @001 patient_id                       $char15.  /*  Patient ID (for either Cancer or Non-Cancer Patients) */
        @016 SAMPLE_GROUP                     $char2.
        @018 ENC_JOIN_KEY                     $char15.
        @033 CLM_TYPE_CD                      $char4.
        @037 CLM_FROM_DT                      $char8.
        @045 CLM_THRU_DT                      $char8.
        @053 SRVC_MONTH                       $char6.
        @059 CLM_CHRT_RVW_SW                  $char1.
        @060 CLM_CNTL_NUM                     $char23.
        @083 CLM_ORIG_CNTL_NUM                $char23.
        @106 CLM_FINL_ACTN_IND                $char1.
        @107 CLM_LTST_CLM_IND                 $char1.
        @108 EDPS_CREATE_DT                   $char8.
        @116 CLM_RCPT_DT                      $char8.
        @124 CLM_FAC_TYPE_CD                  $char1.
        @125 CLM_SRVC_CLSFCTN_TYPE_CD         $char1.
        @126 CLM_FREQ_CD                      $char1.
        @127 CNTRCT_NUM                       $char5.
        @132 CNTRCT_PBP_NUM                   $char3.
        @135 CLM_MDCL_REC                     $char1.
        @136 ORG_NPI                          $char10.
        @146 ORG_TXNMY_CD                     $char10.
        @156 RNDRNG_PHYSN_NPI                 $char10.
        @166 AT_PHYSN_NPI                     $char10.
        @176 AT_PHYSN_TXNMY_CD                $char10.
        @186 OP_PHYSN_NPI                     $char10.
        @196 OT_PHYSN_NPI                     $char10.
        @206 CLM_ADMSN_DT                     $char8.
        @214 CLM_IP_ADMSN_TYPE_CD             $char1.
        @215 CLM_SRC_IP_ADMSN_CD              $char1.
        @216 PTNT_DSCHRG_STUS_CD              $char2.
        @218 CLM_DAY_CNT                      $char4.
        @222 BENE_DSCHRG_DT                   $char8.
        @230 CLM_DRG_CD                       $char3.
        @233 DRVD_DRG_CD                      $char4.
        @237 ADMTG_DGNS_CD                    $char7.
        @244 PRNCPAL_DGNS_CD                  $char7.
        @251 ICD_DGNS_CD1                     $char7.
        @258 ICD_DGNS_CD2                     $char7.
        @265 ICD_DGNS_CD3                     $char7.
        @272 ICD_DGNS_CD4                     $char7.
        @279 ICD_DGNS_CD5                     $char7.
        @286 ICD_DGNS_CD6                     $char7.
        @293 ICD_DGNS_CD7                     $char7.
        @300 ICD_DGNS_CD8                     $char7.
        @307 ICD_DGNS_CD9                     $char7.
        @314 ICD_DGNS_CD10                    $char7.
        @321 ICD_DGNS_CD11                    $char7.
        @328 ICD_DGNS_CD12                    $char7.
        @335 ICD_DGNS_CD13                    $char7.
        @342 ICD_DGNS_CD14                    $char7.
        @349 ICD_DGNS_CD15                    $char7.
        @356 ICD_DGNS_CD16                    $char7.
        @363 ICD_DGNS_CD17                    $char7.
        @370 ICD_DGNS_CD18                    $char7.
        @377 ICD_DGNS_CD19                    $char7.
        @384 ICD_DGNS_CD20                    $char7.
        @391 ICD_DGNS_CD21                    $char7.
        @398 ICD_DGNS_CD22                    $char7.
        @405 ICD_DGNS_CD23                    $char7.
        @412 ICD_DGNS_CD24                    $char7.
        @419 ICD_DGNS_CD25                    $char7.
        @426 CLM_POA_IND_SW1                  $char1.
        @427 CLM_POA_IND_SW2                  $char1.
        @428 CLM_POA_IND_SW3                  $char1.
        @429 CLM_POA_IND_SW4                  $char1.
        @430 CLM_POA_IND_SW5                  $char1.
        @431 CLM_POA_IND_SW6                  $char1.
        @432 CLM_POA_IND_SW7                  $char1.
        @433 CLM_POA_IND_SW8                  $char1.
        @434 CLM_POA_IND_SW9                  $char1.
        @435 CLM_POA_IND_SW10                 $char1.
        @436 CLM_POA_IND_SW11                 $char1.
        @437 CLM_POA_IND_SW12                 $char1.
        @438 CLM_POA_IND_SW13                 $char1.
        @439 CLM_POA_IND_SW14                 $char1.
        @440 CLM_POA_IND_SW15                 $char1.
        @441 CLM_POA_IND_SW16                 $char1.
        @442 CLM_POA_IND_SW17                 $char1.
        @443 CLM_POA_IND_SW18                 $char1.
        @444 CLM_POA_IND_SW19                 $char1.
        @445 CLM_POA_IND_SW20                 $char1.
        @446 CLM_POA_IND_SW21                 $char1.
        @447 CLM_POA_IND_SW22                 $char1.
        @448 CLM_POA_IND_SW23                 $char1.
        @449 CLM_POA_IND_SW24                 $char1.
        @450 CLM_POA_IND_SW25                 $char1.
        @451 CLM_1ST_DGNS_E_CD                $char7.
        @458 ICD_DGNS_E_CD1                   $char7.
        @465 ICD_DGNS_E_CD2                   $char7.
        @472 ICD_DGNS_E_CD3                   $char7.
        @479 ICD_DGNS_E_CD4                   $char7.
        @486 ICD_DGNS_E_CD5                   $char7.
        @493 ICD_DGNS_E_CD6                   $char7.
        @500 ICD_DGNS_E_CD7                   $char7.
        @507 ICD_DGNS_E_CD8                   $char7.
        @514 ICD_DGNS_E_CD9                   $char7.
        @521 ICD_DGNS_E_CD10                  $char7.
        @528 CLM_E_POA_IND_SW1                $char1.
        @529 CLM_E_POA_IND_SW2                $char1.
        @530 CLM_E_POA_IND_SW3                $char1.
        @531 CLM_E_POA_IND_SW4                $char1.
        @532 CLM_E_POA_IND_SW5                $char1.
        @533 CLM_E_POA_IND_SW6                $char1.
        @534 CLM_E_POA_IND_SW7                $char1.
        @535 CLM_E_POA_IND_SW8                $char1.
        @536 CLM_E_POA_IND_SW9                $char1.
        @537 CLM_E_POA_IND_SW10               $char1.
        @538 ICD_PRCDR_CD1                    $char7.
        @545 ICD_PRCDR_CD2                    $char7.
        @552 ICD_PRCDR_CD3                    $char7.
        @559 ICD_PRCDR_CD4                    $char7.
        @566 ICD_PRCDR_CD5                    $char7.
        @573 ICD_PRCDR_CD6                    $char7.
        @580 ICD_PRCDR_CD7                    $char7.
        @587 ICD_PRCDR_CD8                    $char7.
        @594 ICD_PRCDR_CD9                    $char7.
        @601 ICD_PRCDR_CD10                   $char7.
        @608 ICD_PRCDR_CD11                   $char7.
        @615 ICD_PRCDR_CD12                   $char7.
        @622 ICD_PRCDR_CD13                   $char7.
        @629 PRCDR_DT1                        $char8.
        @637 PRCDR_DT2                        $char8.
        @645 PRCDR_DT3                        $char8.
        @653 PRCDR_DT4                        $char8.
        @661 PRCDR_DT5                        $char8.
        @669 PRCDR_DT6                        $char8.
        @677 PRCDR_DT7                        $char8.
        @685 PRCDR_DT8                        $char8.
        @693 PRCDR_DT9                        $char8.
        @701 PRCDR_DT10                       $char8.
        @709 PRCDR_DT11                       $char8.
        @717 PRCDR_DT12                       $char8.
        @725 PRCDR_DT13                       $char8.
        @733 CLM_OBSLT_DT                     $char8.
        @771 CLM_BPRVDR_USPS_STATE_CD         $char2.
        @773 CLM_BPRVDR_ADR_ZIP_CD            $char9.
        @812 CLM_SUBSCR_USPS_STATE_CD         $char2.
        @814 CLM_SUBSCR_ADR_ZIP_CD            $char9.
        @823 BENE_CNTY_CD                     $char3.
        @826 BENE_STATE_CD                    $char2.
        @828 BENE_MLG_CNTCT_ZIP_CD            $char9.
        @837 GNDR_CD                          $char1.
        @838 BENE_RACE_CD                     $char1.
        @839 DOB_YEAR                         $char4.
        @847 BENE_MDCR_STUS_CD                $char2.
        @849 TAX_NUM                          $char10.
        @859 BENE_STATE                       $char2.
        ;

  label
        patient_id                       = "Patient ID"
        SAMPLE_GROUP                     = "CCW Beneficiary Random Sample Group"
        ENC_JOIN_KEY                     = "Unique Encounter Join Key"
        CLM_TYPE_CD                      = "Claim Type Code"
        CLM_FROM_DT                      = "Claim From Date"
        CLM_THRU_DT                      = "Claim Through Date"
        SRVC_MONTH                       = "Service Month"
        CLM_CHRT_RVW_SW                  = "Claim Chart Review Switch"
        CLM_CNTL_NUM                     = "Claim Control Number"
        CLM_ORIG_CNTL_NUM                = "Claim Original Control Number"
        CLM_FINL_ACTN_IND                = "Claim Final Action Indicator"
        CLM_LTST_CLM_IND                 = "Latest Claim Indicator"
        EDPS_CREATE_DT                   = "Encounter Data Processing System (EDPS) Create Date"
        CLM_RCPT_DT                      = "Claim Receipt Date"
        CLM_FAC_TYPE_CD                  = "Claim Facility Type Code"
        CLM_SRVC_CLSFCTN_TYPE_CD         = "Claim Service classification Type Code"
        CLM_FREQ_CD                      = "Claim Frequency Code"
        CNTRCT_NUM                       = "Medicare Part C Contract Number"
        CNTRCT_PBP_NUM                   = "Medicare Part C Plan Benefit Package (PBP) Number"
        CLM_MDCL_REC                     = "Claim Medical Record Number"
        ORG_NPI                          = "Organization NPI Number"
        ORG_TXNMY_CD                     = "Organization Taxonomy Code"
        RNDRNG_PHYSN_NPI                 = "Claim Rendering Physician NPI Number"
        AT_PHYSN_NPI                     = "Claim Attending Physician NPI Number"
        AT_PHYSN_TXNMY_CD                = "Claim Attending Physician Taxonomy Code"
        OP_PHYSN_NPI                     = "Claim Operating Physician NPI Number"
        OT_PHYSN_NPI                     = "Claim Other Physician NPI Number"
        CLM_ADMSN_DT                     = "Claim Admission Date"
        CLM_IP_ADMSN_TYPE_CD             = "Claim Inpatient Admission Type Code"
        CLM_SRC_IP_ADMSN_CD              = "Claim Source Inpatient Admission Code"
        PTNT_DSCHRG_STUS_CD              = "Patient Discharge Status Code"
        CLM_DAY_CNT                      = "Day Count (Length of Stay)"
        BENE_DSCHRG_DT                   = "Beneficiary Discharge Date"
        CLM_DRG_CD                       = "Claim MS-Diagnosis Related Group Code (MS-DRG)"
        DRVD_DRG_CD                      = "Derived MS-Diagnosis Related Group Code (MS-DRG)"
        ADMTG_DGNS_CD                    = "Claim Admitting Diagnosis Code"
        PRNCPAL_DGNS_CD                  = "Claim Principal Diagnosis Code"
        ICD_DGNS_CD1                     = "Claim Diagnosis Code 1"
        ICD_DGNS_CD2                     = "Claim Diagnosis Code 2"
        ICD_DGNS_CD3                     = "Claim Diagnosis Code 3"
        ICD_DGNS_CD4                     = "Claim Diagnosis Code 4"
        ICD_DGNS_CD5                     = "Claim Diagnosis Code 5"
        ICD_DGNS_CD6                     = "Claim Diagnosis Code 6"
        ICD_DGNS_CD7                     = "Claim Diagnosis Code 7"
        ICD_DGNS_CD8                     = "Claim Diagnosis Code 8"
        ICD_DGNS_CD9                     = "Claim Diagnosis Code 9"
        ICD_DGNS_CD10                    = "Claim Diagnosis Code 10"
        ICD_DGNS_CD11                    = "Claim Diagnosis Code 11"
        ICD_DGNS_CD12                    = "Claim Diagnosis Code 12"
        ICD_DGNS_CD13                    = "Claim Diagnosis Code 13"
        ICD_DGNS_CD14                    = "Claim Diagnosis Code 14"
        ICD_DGNS_CD15                    = "Claim Diagnosis Code 15"
        ICD_DGNS_CD16                    = "Claim Diagnosis Code 16"
        ICD_DGNS_CD17                    = "Claim Diagnosis Code 17"
        ICD_DGNS_CD18                    = "Claim Diagnosis Code 18"
        ICD_DGNS_CD19                    = "Claim Diagnosis Code 19"
        ICD_DGNS_CD20                    = "Claim Diagnosis Code 20"
        ICD_DGNS_CD21                    = "Claim Diagnosis Code 21"
        ICD_DGNS_CD22                    = "Claim Diagnosis Code 22"
        ICD_DGNS_CD23                    = "Claim Diagnosis Code 23"
        ICD_DGNS_CD24                    = "Claim Diagnosis Code 24"
        ICD_DGNS_CD25                    = "Claim Diagnosis Code 25"
        CLM_POA_IND_SW1                  = "Claim Diagnosis Code 1 Diagnosis Present on Admission (POA) Indicator Code"
        CLM_POA_IND_SW2                  = "Claim Diagnosis Code 2 Diagnosis Present on Admission (POA) Indicator Code"
        CLM_POA_IND_SW3                  = "Claim Diagnosis Code 3 Diagnosis Present on Admission (POA) Indicator Code"
        CLM_POA_IND_SW4                  = "Claim Diagnosis Code 4 Diagnosis Present on Admission (POA) Indicator Code"
        CLM_POA_IND_SW5                  = "Claim Diagnosis Code 5 Diagnosis Present on Admission (POA) Indicator Code"
        CLM_POA_IND_SW6                  = "Claim Diagnosis Code 6 Diagnosis Present on Admission (POA) Indicator Code"
        CLM_POA_IND_SW7                  = "Claim Diagnosis Code 7 Diagnosis Present on Admission (POA) Indicator Code"
        CLM_POA_IND_SW8                  = "Claim Diagnosis Code 8 Diagnosis Present on Admission (POA) Indicator Code"
        CLM_POA_IND_SW9                  = "Claim Diagnosis Code 9 Diagnosis Present on Admission (POA) Indicator Code"
        CLM_POA_IND_SW10                 = "Claim Diagnosis Code 10 Diagnosis Present on Admission (POA) Indicator Code"
        CLM_POA_IND_SW11                 = "Claim Diagnosis Code 11 Diagnosis Present on Admission (POA) Indicator Code"
        CLM_POA_IND_SW12                 = "Claim Diagnosis Code 12 Diagnosis Present on Admission (POA) Indicator Code"
        CLM_POA_IND_SW13                 = "Claim Diagnosis Code 13 Diagnosis Present on Admission (POA) Indicator Code"
        CLM_POA_IND_SW14                 = "Claim Diagnosis Code 14 Diagnosis Present on Admission (POA) Indicator Code"
        CLM_POA_IND_SW15                 = "Claim Diagnosis Code 15 Diagnosis Present on Admission (POA) Indicator Code"
        CLM_POA_IND_SW16                 = "Claim Diagnosis Code 16 Diagnosis Present on Admission (POA) Indicator Code"
        CLM_POA_IND_SW17                 = "Claim Diagnosis Code 17 Diagnosis Present on Admission (POA) Indicator Code"
        CLM_POA_IND_SW18                 = "Claim Diagnosis Code 18 Diagnosis Present on Admission (POA) Indicator Code"
        CLM_POA_IND_SW19                 = "Claim Diagnosis Code 19 Diagnosis Present on Admission (POA) Indicator Code"
        CLM_POA_IND_SW20                 = "Claim Diagnosis Code 20 Diagnosis Present on Admission (POA) Indicator Code"
        CLM_POA_IND_SW21                 = "Claim Diagnosis Code 21 Diagnosis Present on Admission (POA) Indicator Code"
        CLM_POA_IND_SW22                 = "Claim Diagnosis Code 22 Diagnosis Present on Admission (POA) Indicator Code"
        CLM_POA_IND_SW23                 = "Claim Diagnosis Code 23 Diagnosis Present on Admission (POA) Indicator Code"
        CLM_POA_IND_SW24                 = "Claim Diagnosis Code 24 Diagnosis Present on Admission (POA) Indicator Code"
        CLM_POA_IND_SW25                 = "Claim Diagnosis Code 25 Diagnosis Present on Admission (POA) Indicator Code"
        CLM_1ST_DGNS_E_CD                = "First Claim Diagnosis E Code"
        ICD_DGNS_E_CD1                   = "Claim Diagnosis E Code 1"
        ICD_DGNS_E_CD2                   = "Claim Diagnosis E Code 2"
        ICD_DGNS_E_CD3                   = "Claim Diagnosis E Code 3"
        ICD_DGNS_E_CD4                   = "Claim Diagnosis E Code 4"
        ICD_DGNS_E_CD5                   = "Claim Diagnosis E Code 5"
        ICD_DGNS_E_CD6                   = "Claim Diagnosis E Code 6"
        ICD_DGNS_E_CD7                   = "Claim Diagnosis E Code 7"
        ICD_DGNS_E_CD8                   = "Claim Diagnosis E Code 8"
        ICD_DGNS_E_CD9                   = "Claim Diagnosis E Code 9"
        ICD_DGNS_E_CD10                  = "Claim Diagnosis E Code 10"
        CLM_E_POA_IND_SW1                = "Claim Diagnosis E Code 1 Diagnosis Present on Admission Indicator Code"
        CLM_E_POA_IND_SW2                = "Claim Diagnosis E Code 2 Diagnosis Present on Admission Indicator Code"
        CLM_E_POA_IND_SW3                = "Claim Diagnosis E Code 3 Diagnosis Present on Admission Indicator Code"
        CLM_E_POA_IND_SW4                = "Claim Diagnosis E Code 4 Diagnosis Present on Admission Indicator Code"
        CLM_E_POA_IND_SW5                = "Claim Diagnosis E Code 5 Diagnosis Present on Admission Indicator Code"
        CLM_E_POA_IND_SW6                = "Claim Diagnosis E Code 6 Diagnosis Present on Admission Indicator Code"
        CLM_E_POA_IND_SW7                = "Claim Diagnosis E Code 7 Diagnosis Present on Admission Indicator Code"
        CLM_E_POA_IND_SW8                = "Claim Diagnosis E Code 8 Diagnosis Present on Admission Indicator Code"
        CLM_E_POA_IND_SW9                = "Claim Diagnosis E Code 9 Diagnosis Present on Admission Indicator Code"
        CLM_E_POA_IND_SW10               = "Claim Diagnosis E Code 10 Diagnosis Present on Admission Indicator Code"
        ICD_PRCDR_CD1                    = "Claim Procedure Code 1"
        ICD_PRCDR_CD2                    = "Claim Procedure Code 2"
        ICD_PRCDR_CD3                    = "Claim Procedure Code 3"
        ICD_PRCDR_CD4                    = "Claim Procedure Code 4"
        ICD_PRCDR_CD5                    = "Claim Procedure Code 5"
        ICD_PRCDR_CD6                    = "Claim Procedure Code 6"
        ICD_PRCDR_CD7                    = "Claim Procedure Code 7"
        ICD_PRCDR_CD8                    = "Claim Procedure Code 8"
        ICD_PRCDR_CD9                    = "Claim Procedure Code 9"
        ICD_PRCDR_CD10                   = "Claim Procedure Code 10"
        ICD_PRCDR_CD11                   = "Claim Procedure Code 11"
        ICD_PRCDR_CD12                   = "Claim Procedure Code 12"
        ICD_PRCDR_CD13                   = "Claim Procedure Code 13"
        PRCDR_DT1                        = "Claim Procedure Code 1 Date"
        PRCDR_DT2                        = "Claim Procedure Code 2 Date"
        PRCDR_DT3                        = "Claim Procedure Code 3 Date"
        PRCDR_DT4                        = "Claim Procedure Code 4 Date"
        PRCDR_DT5                        = "Claim Procedure Code 5 Date"
        PRCDR_DT6                        = "Claim Procedure Code 6 Date"
        PRCDR_DT7                        = "Claim Procedure Code 7 Date"
        PRCDR_DT8                        = "Claim Procedure Code 8 Date"
        PRCDR_DT9                        = "Claim Procedure Code 9 Date"
        PRCDR_DT10                       = "Claim Procedure Code 10 Date"
        PRCDR_DT11                       = "Claim Procedure Code 11 Date"
        PRCDR_DT12                       = "Claim Procedure Code 12 Date"
        PRCDR_DT13                       = "Claim Procedure Code 13 Date"
        CLM_OBSLT_DT                     = "Claim Obsolete Date"
        CLM_BPRVDR_USPS_STATE_CD         = "Billing Provider Address - USPS State Code"
        CLM_BPRVDR_ADR_ZIP_CD            = "Billing Provider Address - ZIP Code"
        CLM_SUBSCR_USPS_STATE_CD         = "Medicare Subscriber Address - USPS State Code"
        CLM_SUBSCR_ADR_ZIP_CD            = "Medicare Subscriber Address - ZIP Code"
        BENE_CNTY_CD                     = "Beneficiary County Code from Claim (SSA)"
        BENE_STATE_CD                    = "Beneficiary Residence (SSA) State Code"
        BENE_MLG_CNTCT_ZIP_CD            = "Beneficiary ZIP Code of Residence"
        GNDR_CD                          = "Gender Code"
        BENE_RACE_CD                     = "Race Code"
        DOB_YEAR                         = "Year of Birth"
        BENE_MDCR_STUS_CD                = "Beneficiary Medicare Status Code"
        TAX_NUM                          = "Provider Tax Number"
        BENE_STATE                       = "Beneficiary State Postal Code"
         ;

run;
proc contents data=snfbase_enc position;
Title 'proc contents, SNF Base Encounter file';
run;

*filename snfrev '/directory/snf2019.revenue.enc.txt';                    /* reading in an un-zipped file* /
*filename snfrev pipe 'gunzip -c /directory/snf2019.revenue.enc.txt.gz';  /* reading in a zipped file */
*filename snfrev pipe 'gunzip -c /directory/snf*.revenue.enc.txt.gz';   /* using wildcard to match multiple files */

options nocenter validvarname=upcase;

data snfrevenue_enc;
  infile snfrev lrecl=154 missover pad;
  input
        @001 patient_id                       $char15.  /*  Patient ID (for either Cancer or Non-Cancer Patients) */
        @016 ENC_JOIN_KEY                     $char15.
        @031 CLM_TYPE_CD                      $char4.
        @035 CLM_LINE_NUM                     $char13.
        @048 CLM_THRU_DT                      $char8.
        @056 REV_CNTR                         $char4.
        @060 REV_CNTR_FROM_DT                 $char8.
        @068 REV_CNTR_THRU_DT                 $char8.
        @076 REV_CNTR_UNIT_CNT                $char8.
        @084 HCPCS_CD                         $char5.
        @089 HCPCS_1ST_MDFR_CD                $char2.
        @091 HCPCS_2ND_MDFR_CD                $char2.
        @093 HCPCS_3RD_MDFR_CD                $char2.
        @095 REV_CNTR_IDE_NDC_UPC_NUM         $char24.
        @119 REV_CNTR_NDC_QTY                 10.3
        @129 REV_CNTR_NDC_QTY_QLFR_CD         $char2.
        @131 REV_CNTR_RNDRNG_PHYSN_NPI        $char10.
        @141 LINE_LTST_CLM_IND                $char1.
        @142 LINE_NUM_ORIG                    $char13.
        ;

  label
        patient_id                       = "Patient ID"
        ENC_JOIN_KEY                     = "Unique Encounter Join Key"
        CLM_TYPE_CD                      = "Claim Type Code"
        CLM_LINE_NUM                     = "Claim Line Number"
        CLM_THRU_DT                      = "Claim Through Date"
        REV_CNTR                         = "Revenue Center Code"
        REV_CNTR_FROM_DT                 = "Revenue Center From Date"
        REV_CNTR_THRU_DT                 = "Revenue Center Thru Date"
        REV_CNTR_UNIT_CNT                = "Revenue Center Unit Count"
        HCPCS_CD                         = "HCFA Common Procedure Coding System (HCPCS) Code"
        HCPCS_1ST_MDFR_CD                = "HCPCS Initial Modifier Code"
        HCPCS_2ND_MDFR_CD                = "HCPCS Second Modifier Code"
        HCPCS_3RD_MDFR_CD                = "HCPCS Third Modifier Code"
        REV_CNTR_IDE_NDC_UPC_NUM         = "Revenue Center IDE, NDC, or UPC Number"
        REV_CNTR_NDC_QTY                 = "Revenue Center National Drug Code (NDC) Quantity"
        REV_CNTR_NDC_QTY_QLFR_CD         = "Revenue Center NDC Quantity Qualifier Code"
        REV_CNTR_RNDRNG_PHYSN_NPI        = "Revenue Center Rendering Physician NPI"
        LINE_LTST_CLM_IND                = "Line Latest Claim Indicator"
        LINE_NUM_ORIG                    = "Original Claim Line Number"
        ;

run;
proc contents data=snfrevenue_enc position;
Title 'proc contents, SNF Revenue Encounter file';
run;

*filename snfcond '/directory/snf2019.condition.enc.txt';                    /* reading in an un-zipped file* /
*filename snfcond pipe 'gunzip -c /directory/snf2019.condition.enc.txt.gz';  /* reading in a zipped file */
*filename snfcond pipe 'gunzip -c /directory/snf*.condition.enc.txt.gz';   /* using wildcard to match multiple files */

options nocenter validvarname=upcase;

data snfcondition_enc;
  infile snfcond lrecl=36 missover pad;
  input
       @01  patient_id               $char15.  /*  Patient ID (for either Cancer or Non-Cancer Patients) */
       @16  ENC_JOIN_KEY             $char15.
       @31  CLM_TYPE_CD              $char4.
       @35  RLT_COND_CD_SEQ          $char2.
       @37  CLM_RLT_COND_CD          $char2.
     ;

  label
     patient_id             = "Patient ID"
     ENC_JOIN_KEY           = "Unique Encounter Join Key"
     CLM_TYPE_CD            = "Claim Type Code"
     RLT_COND_CD_SEQ        = "Claim Related Condition Code Sequence"
     CLM_RLT_COND_CD        = "Claim Related Condition Code"
    ;
run;
proc contents data=snfcondition_enc position;
Title 'proc contents, SNF Condition Encounter file';
run;

*filename snfoccur '/directory/snf2019.occurrence.enc.txt';                    /* reading in an un-zipped file* /
*filename snfoccur pipe 'gunzip -c /directory/snf2019.occurrence.enc.txt.gz';  /* reading in a zipped file */
*filename snfoccur pipe 'gunzip -c /directory/snf*.occurrence.enc.txt.gz';   /* using wildcard to match multiple files */

options nocenter validvarname=upcase;

data snfoccurrence_enc;
  infile snfoccur lrecl=46 missover pad;
  input
      @001 patient_id               $char15.  /* Patient ID (for either Cancer or Non-Cancer Patients) */
      @16  ENC_JOIN_KEY             $char15.
      @31  CLM_TYPE_CD              $char4.
      @35  RLT_OCRNC_CD_SEQ         $char2.
      @37  CLM_RLT_OCRNC_CD         $char2.
      @39  CLM_RLT_OCRNC_DT         $char8.  /*  YYMMDD8  */
     ;

  label
     patient_id           = "Patient ID"
     ENC_JOIN_KEY         = "Unique Encounter Join Key"
     CLM_TYPE_CD          = "Claim Type Code"
     RLT_OCRNC_CD_SEQ     = "Claim Related Occurrence Code Sequence"
     CLM_RLT_OCRNC_CD     = "Claim Related Occurrence Code"
     CLM_RLT_OCRNC_DT     = "Claim Related Occurrence Date"
    ;
run;
proc contents data=snfoccurrence_enc position;
Title 'proc contents, SNF Occurrence Encounter file';
run;

*filename snfspan '/directory/snf2019.span.enc.txt';                    /* reading in an un-zipped file* /
*filename snfspan pipe 'gunzip -c /directory/snf2019.span.enc.txt.gz';  /* reading in a zipped file */
*filename snfspan pipe 'gunzip -c /directory/snf*.span.enc.txt.gz';   /* using wildcard to match multiple files */

options nocenter validvarname=upcase;

data snfspan_enc;
  infile snfspan lrecl=54 missover pad;
  input
      @01  patient_id            $char15.  /*  Patient ID (for either Cancer or Non-Cancer Patients) */
      @16  ENC_JOIN_KEY          $char15.
      @31  CLM_TYPE_CD           $char4.
      @35  RLT_SPAN_CD_SEQ       $char2.
      @37  CLM_SPAN_CD           $char2.
      @39  CLM_SPAN_FROM_DT      $char8.  /*  YYMMDD8  */
      @47  CLM_SPAN_THRU_DT      $char8.  /*  YYMMDD8  */
     ;

  label
     patient_id          = "Patient ID"
     ENC_JOIN_KEY        = "Unique Encounter Join Key"
     CLM_TYPE_CD         = "Claim Type Code"
     RLT_SPAN_CD_SEQ     = "Claim Related Span Code Sequence"
     CLM_SPAN_CD         = "Claim Occurrence Span Code"
     CLM_SPAN_FROM_DT    = "Claim Occurrence Span From Date"
     CLM_SPAN_THRU_DT    = "Claim Occurrence Span Through Date"
    ;
run;
proc contents data=snfspan_enc position;
Title 'proc contents, SNF SPAN Encounter file';
run;

*filename snfvalue '/directory/snf2019.value.enc.txt';                    /* reading in an un-zipped file* /
*filename snfvalue pipe 'gunzip -c /directory/snf2019.value.enc.txt.gz';  /* reading in a zipped file */
*filename snfvalue pipe 'gunzip -c /directory/snf*.value.enc.txt.gz';   /* using wildcard to match multiple files */

options nocenter validvarname=upcase;

data snfvalue_enc;
  infile snfvalue lrecl=38 missover pad;
  input
       @01  patient_id               $char15.  /*  Patient ID (for either Cancer or Non-Cancer Patients) */
       @16  ENC_JOIN_KEY             $char15.
       @31  CLM_TYPE_CD              $char4.
       @35  RLT_VAL_CD_SEQ           $char2.
       @37  CLM_VAL_CD               $char2.
      ;

  label
     patient_id        = "Patient ID"
     ENC_JOIN_KEY      = "Unique Encounter Join Key"
     CLM_TYPE_CD       = "Claim Type Code"
     RLT_VAL_CD_SEQ    = "Claim Related Value Code Sequence"
     CLM_VAL_CD        = "Claim Value Code"
     ;
run;
proc contents data=snfvalue_enc position;
Title 'proc contents, SNF Value Encounter file';
run;