/* Published: 09/01/2022 */

/**************************   COMMENTS   *******************************/
/* THIS INPUT STATMENT IS FOR THE 2022 SEER-MEDICARE LINKAGE.          */
/* IF YOU RECEIVED HHA FILES BEFORE NOVEMBER 2022 THEN YOU WILL        */
/* NEED A DIFFERENT INPUT STATEMENT. PLEASE CONTACT IMS VIA E-MAIL AT  */
/* SEER-MEDICARE@IMSWEB.COM AND AN INPUT STATEMENT WILL BE SENT TO YOU */
/***********************************************************************/

/***************   IMPORTANT PROGRAMING NOTES   ************************/
/*               TO IDENTIFY CLAIMS PER PATIENT                        */
/*                                                                     */
/* The Patient ID and Claim ID (column 16) 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 HHA claims files: base (claims),  */
/* revenue, condition, occurrence, span and value.                     */
/* 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 hhabase '/directory/hha2019.base.txt';                    /* reading in an un-zipped file* /
*filename hhabase pipe 'gunzip -c /directory/hha2019.base.txt.gz';  /* reading in a zipped file */
*filename hhabase pipe 'gunzip -c /directory/hha*.base.txt.gz';   /* using wildcard to match multiple files */

options nocenter validvarname=upcase;

data hhabase;
  infile hhabase lrecl=664 missover pad;
  input
      @001 patient_id                   $char15.  /*  Patient ID (for either Cancer or Non-Cancer Patients) */
      @016 CLM_ID                       $char15.  /*  Encrypted  */
      @031 NCH_NEAR_LINE_REC_IDENT_CD   $char1.
      @032 NCH_CLM_TYPE_CD              $char2.
      @034 CLM_FROM_DT                  $char8.  /*  YYMMDD8  */
      @042 CLM_THRU_DT                  $char8.  /*  YYMMDD8  */
      @050 NCH_WKLY_PROC_DT             $char8.  /*  YYMMDD8  */
      @058 FI_CLM_PROC_DT               $char8.  /*  YYMMDD8  */
      @066 PRVDR_NUM                    $char6.   /*  Encrypted  */
      @076 CLM_FAC_TYPE_CD              $char1.
      @077 CLM_SRVC_CLSFCTN_TYPE_CD     $char1.
      @078 CLM_FREQ_CD                  $char1.
      @079 FI_NUM                       $char5.
      @084 CLM_MDCR_NON_PMT_RSN_CD      $char2.
      @086 CLM_PMT_AMT                  12.2
      @098 NCH_PRMRY_PYR_CLM_PD_AMT     12.2
      @110 NCH_PRMRY_PYR_CD             $char1.
      @111 PRVDR_STATE_CD               $char2.
      @113 ORG_NPI_NUM                  $char10.  /*  Encrypted  */
      @123 SRVC_LOC_NPI_NUM             $char10.  /*  Encrypted  */
      @145 AT_PHYSN_UPIN                $char6.   /*  Encrypted  */
      @157 AT_PHYSN_NPI                 $char10.  /*  Encrypted  */
      @169 AT_PHYSN_SPCLTY_CD           $char2.
      @171 OP_PHYSN_NPI                 $char10.  /*  Encrypted  */
      @183 OP_PHYSN_SPCLTY_CD           $char2.
      @185 OT_PHYSN_NPI                 $char10.  /*  Encrypted  */
      @197 OT_PHYSN_SPCLTY_CD           $char2.
      @199 RNDRNG_PHYSN_NPI             $char10.  /*  Encrypted  */
      @211 RNDRNG_PHYSN_SPCLTY_CD       $char2.
      @213 RFR_PHYSN_NPI                $char10.  /*  Encrypted  */
      @225 RFR_PHYSN_SPCLTY_CD          $char2.
      @227 PTNT_DSCHRG_STUS_CD          $char2.
      @229 CLM_PPS_IND_CD               $char1.
      @230 CLM_TOT_CHRG_AMT             12.2
      @242 PRNCPAL_DGNS_CD              $char7.
      @249 ICD_DGNS_CD1                 $char7.
      @256 ICD_DGNS_CD2                 $char7.
      @263 ICD_DGNS_CD3                 $char7.
      @270 ICD_DGNS_CD4                 $char7.
      @277 ICD_DGNS_CD5                 $char7.
      @284 ICD_DGNS_CD6                 $char7.
      @291 ICD_DGNS_CD7                 $char7.
      @298 ICD_DGNS_CD8                 $char7.
      @305 ICD_DGNS_CD9                 $char7.
      @312 ICD_DGNS_CD10                $char7.
      @319 ICD_DGNS_CD11                $char7.
      @326 ICD_DGNS_CD12                $char7.
      @333 ICD_DGNS_CD13                $char7.
      @340 ICD_DGNS_CD14                $char7.
      @347 ICD_DGNS_CD15                $char7.
      @354 ICD_DGNS_CD16                $char7.
      @361 ICD_DGNS_CD17                $char7.
      @368 ICD_DGNS_CD18                $char7.
      @375 ICD_DGNS_CD19                $char7.
      @382 ICD_DGNS_CD20                $char7.
      @389 ICD_DGNS_CD21                $char7.
      @396 ICD_DGNS_CD22                $char7.
      @403 ICD_DGNS_CD23                $char7.
      @410 ICD_DGNS_CD24                $char7.
      @417 ICD_DGNS_CD25                $char7.
      @424 FST_DGNS_E_CD                $char7.
      @431 ICD_DGNS_E_CD1               $char7.
      @438 ICD_DGNS_E_CD2               $char7.
      @445 ICD_DGNS_E_CD3               $char7.
      @452 ICD_DGNS_E_CD4               $char7.
      @459 ICD_DGNS_E_CD5               $char7.
      @466 ICD_DGNS_E_CD6               $char7.
      @473 ICD_DGNS_E_CD7               $char7.
      @480 ICD_DGNS_E_CD8               $char7.
      @487 ICD_DGNS_E_CD9               $char7.
      @494 ICD_DGNS_E_CD10              $char7.
      @501 ICD_DGNS_E_CD11              $char7.
      @508 ICD_DGNS_E_CD12              $char7.
      @515 CLM_HHA_LUPA_IND_CD          $char1.
      @516 CLM_HHA_RFRL_CD              $char1.
      @517 CLM_HHA_TOT_VISIT_CNT        $char3.
      @520 CLM_ADMSN_DT                 $char8.  /*  YYMMDD8  */
      @528 DOB_YEAR                     $char4.
      @536 GNDR_CD                      $char1.
      @537 BENE_RACE_CD                 $char1.
      @538 BENE_CNTY_CD                 $char3.
      @541 BENE_STATE_CD                $char2.
      @543 BENE_MLG_CNTCT_ZIP_CD        $char9.   /*  Encrypted  */
      @552 CLM_MDCL_REC                 $char17.  /*  Encrypted  */
      @569 CLAIM_QUERY_CODE             $char1.
      @570 FI_CLM_ACTN_CD               $char1.
      @571 CLM_MCO_PD_SW                $char1.
      @572 NCH_BENE_DSCHRG_DT           $char8.  /*  YYMMDD8  */
      @580 CLM_TRTMT_AUTHRZTN_NUM       $char18.  /*  Encrypted  */
      @598 CLM_PRCR_RTRN_CD             $char2.
      @600 CLM_SRVC_FAC_ZIP_CD          $char9.   /*  Encrypted  */
      @609 CLM_NEXT_GNRTN_ACO_IND_CD1   $char1.
      @610 CLM_NEXT_GNRTN_ACO_IND_CD2   $char1.
      @611 CLM_NEXT_GNRTN_ACO_IND_CD3   $char1.
      @612 CLM_NEXT_GNRTN_ACO_IND_CD4   $char1.
      @613 CLM_NEXT_GNRTN_ACO_IND_CD5   $char1.
      @614 ACO_ID_NUM                   $char10.  /*  Encrypted  */
      @624 FINL_STD_AMT                 12.2
      @636 CLM_BENE_ID_TYPE_CD          $char1.
      @637 CLM_RSDL_PYMT_IND_CD         $char1.
      @638 PRVDR_VLDTN_TYPE_CD          $char2.
      @640 RR_BRD_EXCLSN_IND_SW         $char1.
      @641 PPS_STD_VAL_PYMT_AMT         12.2
      @653 CLM_MODEL_REIMBRSMT_AMT      12.2
     ;

  label
     patient_id                       = "Patient ID"
     CLM_ID                           = "Encrypted Claim ID"
     NCH_NEAR_LINE_REC_IDENT_CD       = "NCH Near Line Record Identification Code"
     NCH_CLM_TYPE_CD                  = "NCH Claim Type Code"
     CLM_FROM_DT                      = "Claim From Date"
     CLM_THRU_DT                      = "Claim Through Date (Determines Year of Claim)"
     NCH_WKLY_PROC_DT                 = "NCH Weekly Claim Processing Date"
     FI_CLM_PROC_DT                   = "FI Claim Process Date"
     PRVDR_NUM                        = "Provider Number"
     CLM_FAC_TYPE_CD                  = "Claim Facility Type Code"
     CLM_SRVC_CLSFCTN_TYPE_CD         = "Claim Service classification Type Code"
     CLM_FREQ_CD                      = "Claim Frequency Code"
     FI_NUM                           = "FI Number"
     CLM_MDCR_NON_PMT_RSN_CD          = "Claim Medicare Non Payment Reason Code"
     CLM_PMT_AMT                      = "Claim Payment Amount"
     NCH_PRMRY_PYR_CLM_PD_AMT         = "NCH Primary Payer Claim Paid Amount"
     NCH_PRMRY_PYR_CD                 = "NCH Primary Payer Code"
     PRVDR_STATE_CD                   = "NCH Provider State Code"
     ORG_NPI_NUM                      = "Organization NPI Number"
     SRVC_LOC_NPI_NUM                 = "Claim Service Location NPI Number"
     AT_PHYSN_UPIN                    = "Claim Attending Physician UPIN Number"
     AT_PHYSN_NPI                     = "Claim Attending Physician NPI Number"
     AT_PHYSN_SPCLTY_CD               = "Claim Attending Physician Specialty Code"
     OP_PHYSN_NPI                     = "Claim Operating Physician NPI Number"
     OP_PHYSN_SPCLTY_CD               = "Claim Operating Physician Specialty Code"
     OT_PHYSN_NPI                     = "Claim Other Physician NPI Number"
     OT_PHYSN_SPCLTY_CD               = "Claim Other Physician Specialty Code"
     RNDRNG_PHYSN_NPI                 = "Claim Rendering Physician NPI"
     RNDRNG_PHYSN_SPCLTY_CD           = "Claim Rendering Physician Specialty Code"
     RFR_PHYSN_NPI                    = "Claim Referring Physician NPI"
     RFR_PHYSN_SPCLTY_CD              = "Claim Referring Physician Specialty Code"
     PTNT_DSCHRG_STUS_CD              = "Patient Discharge Status Code"
     CLM_PPS_IND_CD                   = "Claim PPS Indicator Code"
     CLM_TOT_CHRG_AMT                 = "Claim Total Charge Amount"
     PRNCPAL_DGNS_CD                  = "Primary Claim Diagnosis Code"
     ICD_DGNS_CD1                     = "Claim Diagnosis Code I"
     ICD_DGNS_CD2                     = "Claim Diagnosis Code II"
     ICD_DGNS_CD3                     = "Claim Diagnosis Code III"
     ICD_DGNS_CD4                     = "Claim Diagnosis Code IV"
     ICD_DGNS_CD5                     = "Claim Diagnosis Code V"
     ICD_DGNS_CD6                     = "Claim Diagnosis Code VI"
     ICD_DGNS_CD7                     = "Claim Diagnosis Code VII"
     ICD_DGNS_CD8                     = "Claim Diagnosis Code VIII"
     ICD_DGNS_CD9                     = "Claim Diagnosis Code IX"
     ICD_DGNS_CD10                    = "Claim Diagnosis Code X"
     ICD_DGNS_CD11                    = "Claim Diagnosis Code XI"
     ICD_DGNS_CD12                    = "Claim Diagnosis Code XII"
     ICD_DGNS_CD13                    = "Claim Diagnosis Code XIII"
     ICD_DGNS_CD14                    = "Claim Diagnosis Code XIV"
     ICD_DGNS_CD15                    = "Claim Diagnosis Code XV"
     ICD_DGNS_CD16                    = "Claim Diagnosis Code XVI"
     ICD_DGNS_CD17                    = "Claim Diagnosis Code XVII"
     ICD_DGNS_CD18                    = "Claim Diagnosis Code XVIII"
     ICD_DGNS_CD19                    = "Claim Diagnosis Code XIX"
     ICD_DGNS_CD20                    = "Claim Diagnosis Code XX"
     ICD_DGNS_CD21                    = "Claim Diagnosis Code XXI"
     ICD_DGNS_CD22                    = "Claim Diagnosis Code XXII"
     ICD_DGNS_CD23                    = "Claim Diagnosis Code XXIII"
     ICD_DGNS_CD24                    = "Claim Diagnosis Code XXIV"
     ICD_DGNS_CD25                    = "Claim Diagnosis Code XXV"
     FST_DGNS_E_CD                    = "First Claim Diagnosis E Code"
     ICD_DGNS_E_CD1                   = "Claim Diagnosis E Code I"
     ICD_DGNS_E_CD2                   = "Claim Diagnosis E Code II"
     ICD_DGNS_E_CD3                   = "Claim Diagnosis E Code III"
     ICD_DGNS_E_CD4                   = "Claim Diagnosis E Code IV"
     ICD_DGNS_E_CD5                   = "Claim Diagnosis E Code V"
     ICD_DGNS_E_CD6                   = "Claim Diagnosis E Code VI"
     ICD_DGNS_E_CD7                   = "Claim Diagnosis E Code VII"
     ICD_DGNS_E_CD8                   = "Claim Diagnosis E Code VIII"
     ICD_DGNS_E_CD9                   = "Claim Diagnosis E Code IX"
     ICD_DGNS_E_CD10                  = "Claim Diagnosis E Code X"
     ICD_DGNS_E_CD11                  = "Claim Diagnosis E Code XI"
     ICD_DGNS_E_CD12                  = "Claim Diagnosis E Code XII"
     CLM_HHA_LUPA_IND_CD              = "Claim HHA Low Utilization Payment Adjustment (LUPA) Indicator Code"
     CLM_HHA_RFRL_CD                  = "Claim HHA Referral Code"
     CLM_HHA_TOT_VISIT_CNT            = "Claim HHA Total Visit Count"
     CLM_ADMSN_DT                     = "Claim HHA Care Start Date"
     DOB_YEAR                         = "Year of Birth from Claim (Date)"
     GNDR_CD                          = "Gender Code from Claim"
     BENE_RACE_CD                     = "Race Code from Claim"
     BENE_CNTY_CD                     = "County Code from Claim (SSA)"
     BENE_STATE_CD                    = "State Code from Claim (SSA)"
     BENE_MLG_CNTCT_ZIP_CD            = "Zip Code of Residence from Claim"
     CLM_MDCL_REC                     = "Claim Medical Record Number"
     CLAIM_QUERY_CODE                 = "Claim Query Code"
     FI_CLM_ACTN_CD                   = "FI Claim Action Code"
     CLM_MCO_PD_SW                    = "Claim MCO Paid Switch"
     NCH_BENE_DSCHRG_DT               = "NCH Beneficiary Discharge Date"
     CLM_TRTMT_AUTHRZTN_NUM           = "Claim Treatment Authorization Number"
     CLM_PRCR_RTRN_CD                 = "Claim Pricer Return Code"
     CLM_SRVC_FAC_ZIP_CD              = "Claim Service Facility ZIP Code"
     CLM_NEXT_GNRTN_ACO_IND_CD1       = "Claim Next Generation Accountable Care Organization Indicator Code 1"
     CLM_NEXT_GNRTN_ACO_IND_CD2       = "Claim Next Generation Accountable Care Organization Indicator Code 2"
     CLM_NEXT_GNRTN_ACO_IND_CD3       = "Claim Next Generation Accountable Care Organization Indicator Code 3"
     CLM_NEXT_GNRTN_ACO_IND_CD4       = "Claim Next Generation Accountable Care Organization Indicator Code 4"
     CLM_NEXT_GNRTN_ACO_IND_CD5       = "Claim Next Generation Accountable Care Organization Indicator Code 5"
     ACO_ID_NUM                       = "Claim Accountable Care Organization (ACO) Identification Number"
     FINL_STD_AMT                     = "Claim Final Standard Amount"
     CLM_BENE_ID_TYPE_CD              = "For CMS Internal Use Only"
     CLM_RSDL_PYMT_IND_CD             = "Claim Residual Payment Indicator Code"
     PRVDR_VLDTN_TYPE_CD              = "Provider Validation Type Code"
     RR_BRD_EXCLSN_IND_SW             = "Railroad Board Exclusion Indicator Switch"
     PPS_STD_VAL_PYMT_AMT             = "Claim PPS Standard Value Payment Amount"
     CLM_MODEL_REIMBRSMT_AMT          = "Claim Model Reimbursement Amount"
    ;
run;
proc contents data=hhabase position;
Title 'proc contents, HHA Base file';
run;

*filename hhareven '/directory/hha2019.revenue.txt';                    /* reading in an un-zipped file* /
*filename hhareven pipe 'gunzip -c /directory/hha2019.revenue.txt.gz';  /* reading in a zipped file */
*filename hhareven pipe 'gunzip -c /directory/hha*.revenue.txt.gz';   /* using wildcard to match multiple files */

options nocenter validvarname=upcase;

data hharevenue;
  infile hhareven lrecl=273 missover pad;
  input
       @001 patient_id                    $char15.  /*  Patient ID (for either Cancer or Non-Cancer Patients) */
       @016 CLM_ID                        $char15.  /*  Encrypted  */
       @031 CLM_THRU_DT                   $char8.  /*  YYMMDD8  */
       @039 CLM_LINE_NUM                  $char13.
       @052 NCH_CLM_TYPE_CD               $char2.
       @054 REV_CNTR                      $char4.
       @058 REV_CNTR_DT                   $char8.  /*  YYMMDD8  */
       @066 REV_CNTR_1ST_ANSI_CD          $char5.
       @071 REV_CNTR_APC_HIPPS_CD         $char5.
       @076 HCPCS_CD                      $char5.
       @081 HCPCS_1ST_MDFR_CD             $char5.
       @086 HCPCS_2ND_MDFR_CD             $char5.
       @091 HCPCS_3RD_MDFR_CD             $char5.
       @096 REV_CNTR_PMT_MTHD_IND_CD      $char2.
       @098 REV_CNTR_UNIT_CNT             8.
       @106 REV_CNTR_RATE_AMT             12.2
       @118 REV_CNTR_PMT_AMT_AMT          12.2
       @130 REV_CNTR_TOT_CHRG_AMT         12.2
       @142 REV_CNTR_NCVRD_CHRG_AMT       12.2
       @154 REV_CNTR_DDCTBL_COINSRNC_CD   $char1.
       @155 REV_CNTR_STUS_IND_CD          $char2.
       @157 REV_CNTR_NDC_QTY              10.3
       @167 REV_CNTR_NDC_QTY_QLFR_CD      $char2.
       @169 RNDRNG_PHYSN_UPIN             $char6.   /*  Encrypted  */
       @181 RNDRNG_PHYSN_NPI              $char10.  /*  Encrypted  */
       @193 RNDRNG_PHYSN_SPCLTY_CD        $char2.
       @195 REV_CNTR_DSCNT_IND_CD         $char1.
       @196 REV_CNTR_IDE_NDC_UPC_NUM      $char24.
       @220 REV_CNTR_PRVDR_PMT_AMT        12.2
       @232 REV_CNTR_PTNT_RSPNSBLTY_PMT   12.2
       @244 REV_CNTR_PRCNG_IND_CD         $char2.
       @246 THRPY_CAP_IND_CD1             $char1.
       @247 THRPY_CAP_IND_CD2             $char1.
       @248 REV_CNTR_RP_IND_CD            $char1.
       @249 RC_MODEL_REIMBRSMT_AMT        12.2
       @261 RC_VLNTRY_SRVC_IND_CD         $char1.
       @262 ORDRNG_PHYSN_NPI              $char12.
     ;

  label
     patient_id                       = "Patient ID"
     CLM_ID                           = "Encrypted Claim ID"
     CLM_THRU_DT                      = "Claim Through Date (Determines Year of Claim)"
     CLM_LINE_NUM                     = "Claim Line Number"
     NCH_CLM_TYPE_CD                  = "NCH Claim Type Code"
     REV_CNTR                         = "Revenue Center Code"
     REV_CNTR_DT                      = "Revenue Center Date"
     REV_CNTR_1ST_ANSI_CD             = "Revenue Center 1st ANSI Code"
     REV_CNTR_APC_HIPPS_CD            = "Revenue Center APC/HIPPS"
     HCPCS_CD                         = "Revenue Center Healthcare Common Procedure Coding System"
     HCPCS_1ST_MDFR_CD                = "Revenue Center HCPCS Initial Modifier Code"
     HCPCS_2ND_MDFR_CD                = "Revenue Center HCPCS Second Modifier Code"
     HCPCS_3RD_MDFR_CD                = "Revenue Center HCPCS Third Modifier Code"
     REV_CNTR_PMT_MTHD_IND_CD         = "Revenue Center Payment Method Indicator Code"
     REV_CNTR_UNIT_CNT                = "Revenue Center Unit Count"
     REV_CNTR_RATE_AMT                = "Revenue Center Rate Amount"
     REV_CNTR_PMT_AMT_AMT             = "Revenue Center Payment Amount Amount"
     REV_CNTR_TOT_CHRG_AMT            = "Revenue Center Total Charge Amount"
     REV_CNTR_NCVRD_CHRG_AMT          = "Revenue Center Non-Covered Charge Amount"
     REV_CNTR_DDCTBL_COINSRNC_CD      = "Revenue Center Deductible Coinsurance Code"
     REV_CNTR_STUS_IND_CD             = "Revenue Center Status Indicator Code"
     REV_CNTR_NDC_QTY                 = "Revenue Center NDC Quantity"
     REV_CNTR_NDC_QTY_QLFR_CD         = "Revenue Center NDC Quantity Qualifier Code"
     RNDRNG_PHYSN_UPIN                = "Revenue Center Rendering Physician UPIN"
     RNDRNG_PHYSN_NPI                 = "Revenue Center Rendering Physician NPI"
     RNDRNG_PHYSN_SPCLTY_CD           = "Revenue Center Rendering Physician Specialty Code"
     REV_CNTR_DSCNT_IND_CD            = "Revenue Center Discount Indicator Code"
     REV_CNTR_IDE_NDC_UPC_NUM         = "Revenue Center IDE, NDC, UPC Number"
     REV_CNTR_PRVDR_PMT_AMT           = "Revenue Center Provider Payment Amount"
     REV_CNTR_PTNT_RSPNSBLTY_PMT      = "Revenue Center Patient Responsibility Payment"
     REV_CNTR_PRCNG_IND_CD            = "Revenue Center Pricing Indicator Code"
     THRPY_CAP_IND_CD1                = "Revenue Center Therapy Cap Indicator Code 1"
     THRPY_CAP_IND_CD2                = "Revenue Center Therapy Cap Indicator Code 2"
     REV_CNTR_RP_IND_CD               = "Revenue Center Representative Payee (RP) Indicator Code"
     RC_MODEL_REIMBRSMT_AMT           = "Revenue Center Model Reimbursement Amount"
     RC_VLNTRY_SRVC_IND_CD            = "Revenue Center Voluntary Serice Indicator Code"
     ORDRNG_PHYSN_NPI                 = "Revenue Center Ordering Physician NPI"
    ;
run;
proc contents data=hharevenue position;
Title 'proc contents, HHA Revenue file';
run;

*filename hhacond '/directory/hha2019.condition.txt';                    /* reading in an un-zipped file* /
*filename hhacond pipe 'gunzip -c /directory/hha2019.condition.txt.gz';  /* reading in a zipped file */
*filename hhacond pipe 'gunzip -c /directory/hha*.condition.txt.gz';   /* using wildcard to match multiple files */

options nocenter validvarname=upcase;

data hhacondition;
  infile hhacond lrecl=36 missover pad;
  input
       @01  patient_id               $char15.  /*  Patient ID (for either Cancer or Non-Cancer Patients) */
       @16  CLM_ID                   $char15.  /*  Encrypted  */
       @31  NCH_CLM_TYPE_CD          $char2.
       @33  RLT_COND_CD_SEQ          $char2.
       @35  CLM_RLT_COND_CD          $char2.
     ;

  label
     patient_id             = "Patient ID"
     CLM_ID                 = "Encrypted Claim ID"
     NCH_CLM_TYPE_CD        = "NCH Claim Type Code"
     RLT_COND_CD_SEQ        = "Claim Related Condition Code Sequence"
     CLM_RLT_COND_CD        = "Claim Related Condition Code"
    ;
run;
proc contents data=hhacondition position;
Title 'proc contents, HHA Condition file';
run;

*filename hhaoccur '/directory/hha2019.occurrence.txt';                    /* reading in an un-zipped file* /
*filename hhaoccur pipe 'gunzip -c /directory/hha2019.occurrence.txt.gz';  /* reading in a zipped file */
*filename hhaoccur pipe 'gunzip -c /directory/hha*.occurrence.txt.gz';   /* using wildcard to match multiple files */

options nocenter validvarname=upcase;

data hhaoccurrence;
  infile hhaoccur lrecl=44 missover pad;
  input
      @001 patient_id               $char15.  /* Patient ID (for either Cancer or Non-Cancer Patients) */
      @16  CLM_ID                   $char15.  /*  Encrypted  */
      @31  NCH_CLM_TYPE_CD          $char2.
      @33  RLT_OCRNC_CD_SEQ         $char2.
      @35  CLM_RLT_OCRNC_CD         $char2.
      @37  CLM_RLT_OCRNC_DT         $char8.  /*  YYMMDD8  */
     ;

  label
     patient_id           = "Patient ID"
     CLM_ID               = "Encrypted Claim ID"
     NCH_CLM_TYPE_CD      = "NCH 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=hhaoccurrence position;
Title 'proc contents, HHA Occurrence file';
run;

*filename hhaspan '/directory/hha2019.span.txt';                    /* reading in an un-zipped file* /
*filename hhaspan pipe 'gunzip -c /directory/hha2019.span.txt.gz';  /* reading in a zipped file */
*filename hhaspan pipe 'gunzip -c /directory/hha*.span.txt.gz';   /* using wildcard to match multiple files */

options nocenter validvarname=upcase;

data hhaspan;
  infile hhaspan lrecl=52 missover pad;
  input
      @01  patient_id            $char15.  /*  Patient ID (for either Cancer or Non-Cancer Patients) */
      @16  CLM_ID                $char15.  /*  Encrypted  */
      @31  NCH_CLM_TYPE_CD       $char2.
      @33  RLT_SPAN_CD_SEQ       $char2.
      @35  CLM_SPAN_CD           $char2.
      @37  CLM_SPAN_FROM_DT      $char8.  /*  YYMMDD8  */
      @45  CLM_SPAN_THRU_DT      $char8.  /*  YYMMDD8  */
     ;

  label
     patient_id          = "Patient ID"
     CLM_ID              = "Encrypted Claim ID"
     NCH_CLM_TYPE_CD     = "NCH 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=hhaspan position;
Title 'proc contents, HHA SPAN file';
run;

*filename hhavalue '/directory/hha2019.value.txt';                    /* reading in an un-zipped file* /
*filename hhavalue pipe 'gunzip -c /directory/hha2019.value.txt.gz';  /* reading in a zipped file */
*filename hhavalue pipe 'gunzip -c /directory/hha*.value.txt.gz';   /* using wildcard to match multiple files */

options nocenter validvarname=upcase;

data hhavalue;
  infile hhavalue lrecl=48 missover pad;
  input
       @01  patient_id               $char15.  /*  Patient ID (for either Cancer or Non-Cancer Patients) */
       @16  CLM_ID                   $char15.  /*  Encrypted  */
       @31  NCH_CLM_TYPE_CD          $char2.
       @33  RLT_VAL_CD_SEQ           $char2.
       @35  CLM_VAL_CD               $char2.
       @37  CLM_VAL_AMT              12.2
     ;

  label
     patient_id        = "Patient ID"
     CLM_ID            = "Encrypted Claim ID"
     NCH_CLM_TYPE_CD   = "NCH Claim Type Code"
     RLT_VAL_CD_SEQ    = "Claim Related Value Code Sequence"
     CLM_VAL_CD        = "Claim Value Code"
     CLM_VAL_AMT       = "Claim Value Amount"
    ;
run;
proc contents data=hhavalue position;
Title 'proc contents, HHA Value file';
run;

*filename hhademo '/directory/hha2018.demo.txt';                    /* reading in an un-zipped file* /
*filename hhademo pipe 'gunzip -c /directory/hha2019.demo.txt.gz';  /* reading in a zipped file */
*filename hhademo pipe 'gunzip -c /directory/hha*.demo.txt.gz';   /* using wildcard to match multiple files */

options nocenter validvarname=upcase;

data hhademo;
  infile hhademo lrecl=52 missover pad;
  input
       @01  patient_id                       $char15.  /*  Patient ID (for either Cancer or Non-Cancer Patients) */
       @16  CLM_ID                           $char15.  /*  Encrypted  */
       @31  NCH_CLM_TYPE_CD                  $char2.
       @33  DEMO_ID_SQNC_NUM                 3.
       @36  DEMO_ID_NUM                      $char2.
       @38  DEMO_INFO_TXT                    $char15.
     ;

  label
     patient_id            = "Patient ID"
     CLM_ID                = "Encrypted Claim ID"
     NCH_CLM_TYPE_CD       = "NCH Claim Type Code"
     DEMO_ID_SQNC_NUM      = "Claim Demonstration Sequence"
     DEMO_ID_NUM           = "Claim Demonstration Identification Number"
     DEMO_INFO_TXT         = "Claim Demonstration Information Text";
    ;
run;
proc contents data=hhademo position;
Title 'proc contents, HHA Demonstration/Innovation file';
run;