/*Published: 11/01/2018*/

/**************************   COMMENTS   *******************************/
/* THIS INPUT STATMENT IS FOR THE 2018 SEER-MEDICARE LINKAGE.          */
/* IF YOU RECEIVED HHA FILES BEFORE NOVEMBER 2018 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 */
/***********************************************************************/
/*                                                                     */
/* For cancer files, Patient Identifier is @01 REGCASE $char10.        */
/* For non-cancer files, Patient Identifier is @01 HICBIC $char11.     */
/*                                                                     */
/***********************************************************************/

/***************   IMPORTANT PROGRAMING NOTES   ************************/
/*               TO IDENTIFY CLAIMS PER PATIENT                        */
/*                                                                     */
/* The Patient ID and claim ID (column 648) should be used to          */
/* identify all the records for each claim per patient.  Both are      */
/* needed to identify a claim.                                         */
/***********************************************************************/

/***********************************************************************/
/*                   TO CALCULATE COSTS PER PATIENT                    */
/*                                                                     */
/* When calculating costs per patient you will need to use the claim   */
/* payment amount variable (column 93).  The value from the record     */
/* count (column 645) equal to 1 should be used.  This will eliminate  */
/* duplicate counting from other records.                              */
/***********************************************************************/

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

options nocenter validvarname=upcase;

data hha;
  infile hhafixed lrecl=658 missover pad;
  input
    @001  patient_id $char11. /* Patient ID (for either Cancer or Non-Cancer Patients) */
    /*@001  REGCASE    $char10.*/ /*ID for Cancer Patients*/
    /*@001  HICBIC     $char11.*/ /*ID for Non Cancer Patients*/
      @012  RIC_CD               $char1.
      @013  CLM_TYPE             $char2.
      @015  BIC                  $char2.
      @017  STATE_CD             $char2.
      @019  from_dtm             $char2.
      @021  from_dtd             $char2.
      @023  from_dty             $char4.
      @027  thru_dtm             $char2.
      @029  thru_dtd             $char2.
      @031  thru_dty             $char4.
      @035  QUERY_CD             $char1.
      @036  provider             $char6.
      @060  SGMT_CNT             $char2.
      @062  SGMT_NUM             $char2.
      @064  LINECNT              $char3.
      @067  SGMTLINE             $char2.
      @069  FAC_TYPE             $char1.
      @070  TYPESRVC             $char1.
      @071  FREQ_CD              $char1.
      @072  CNTY_CD              $char3.
      @075  FI_NUM               $char5.
      @080  BENE_ZIP             $char9.
      @089  MS_CD                $char2.
      @091  NOPAY_CD             $char2.
      @093  PMT_AMT              15.2
      @108  PRPAYAMT             15.2
      @123  PRPAY_CD             $char1.
      @124  ACTIONCD             $char1.
      @125  PRSTATE              $char2.
      @127  orgnpinm             $char10.
      @137  at_upin              $char6.
      @143  at_npi               $char10.
      @153  op_upin              $char6.
      @159  op_npi               $char10.
      @169  ot_upin              $char6.
      @175  ot_npi               $char10.
      @185  AUTHRZTN             $char18.
      @203  STUS_CD              $char2.
      @205  PPS_IND              $char1.
      @206  TOT_CHRG             15.2
      @221  PRCRRTRN             $char2.
      @223  SRVCFAC              $char9.
      @232  HHDGNCNT             $char2.
      @234  HHREVCNT             $char2.
      @236  LUPAIND              $char1.
      @237  HHA_RFRL             $char1.
      @238  VISITCNT             $char3.
      @241  DSCHRGDTM            $char2.
      @243  DSCHRGDTD            $char2.
      @245  DSCHRGDTY            $char4.
      @249  HHSTRTDTM            $char2.
      @251  HHSTRTDTD            $char2.
      @253  HHSTRTDTY            $char4.
      @257  srvcnpi              $char10.
      @267  (DVRSNCD1-DVRSNCD25) ($char1.)
      @292  (DGNS_CD1-DGNS_CD25) ($char7.)
      @467  (rlt_cond1-rlt_cond2) ($char2.)
      @471  OCRNCIND1            $char1.
      @472  OCRNCIND2            $char1.
      @473  OCRNC_CD1            $char2.
      @475  OCRNC_CD2            $char2.
      @477  OCRNCDTM1            $char2.
      @479  OCRNCDTD1            $char2.
      @481  OCRNCDTY1            $char4.
      @485  OCRNCDTM2            $char2.
      @487  OCRNCDTD2            $char2.
      @489  OCRNCDTY2            $char4.
      @493  rev_cntr             $char4.
      @497  REV_DTM              $char2.
      @499  REV_DTD              $char2.
      @501  REV_DTY              $char4.
      @505  REVANSI1             $char5.
      @510  APCHIPPS             $char5.
      @515  HCPCS_CD             $char5.
      @520  MDFR_CD1             $char2.
      @522  MDFR_CD2             $char2.
      @524  REV_UNIT             8.
      @532  REV_RATE             15.2
      @547  REV_MSP1             15.2
      @562  REV_MSP2             15.2
      @577  RPRVDPMT             15.2
      @592  REVPMT               15.2
      @607  REV_CHRG             15.2
      @622  REV_NCVR             15.2
      @637  REVDEDCD             $char1.
      @638  RSTUSIND             $char2.
      @640  DUP_CHK              $char1.
      @641  YEAR                 $char4.
      @645  REC_COUNT            $char3.
      @648  CLAIM_ID             10.
     ;

  label
    patient_id = 'Patient ID'
    /* regcase  = 'SEER Registry Case Number - Cancer Patients' */
    /* hicbic   = 'Patient ID for the Non Cancer Patients' */
    ric_cd     = '5 - NCH Near Line Record Identification Code'
    clm_type   = '7 - NCH Claim Type Code'
    bic        = '12 - Beneficiary Identification Code'
    state_cd   = '14 - SSA Standard State Code'
    from_dtm   = '15 - Month of Claim From Date'
    from_dtd   = '15 - Day of Claim From Date'
    from_dty   = '15 - Year of Claim From Date'
    thru_dtm   = '16 - Month of Claim Through Date'
    thru_dtd   = '16 - Day of Claim Through Date'
    thru_dty   = '16 - Year of Claim Through Date'
    query_cd   = '22 - Claim Query Code'
    provider   = '23 - Provider Number'
    sgmt_cnt   = '26 - Claim Total Segment Count'
    sgmt_num   = '27 - Claim Segment Number'
    linecnt    = '28 - Claim Total Line Count'
    sgmtline   = '29 - Claim Segment Line Count'
    fac_type   = '34 - Claim facility Type Code'
    typesrvc   = '35 - Claim Service Classification Type Code'
    freq_cd    = '36 - Claim Frequency Code'
    cnty_cd    = '42 - Beneficiary Residence SSA Standard County Code'
    fi_num     = '46 - FI Number'
    bene_zip   = '49 - Beneficiary Mailing Contact Zip code (Encrypted)'
    ms_cd      = '53 - CWF Beneficiary Medicare Status'
    nopay_cd   = '62 - Claim Medicare Non Payment Reason Code'
    pmt_amt    = '64 - Claim Payment Amount'
    prpayamt   = '65 - NCH Primary Payer Claim Paid Amount'
    prpay_cd   = '66 - NCH Primary Payer Code'
    actioncd   = '68 - FI Claim Action Code'
    prstate    = '70 - NCH Provider State Code'
    orgnpinm   = '71 - Organization NPI Number'
    at_upin    = '73 - Claim Attending Physician UPIN Number'
    at_npi     = '74 - Claim Attending Physician NPI Number'
    op_upin    = '79 - Claim Operating Physician UPIN Number'
    op_npi     = '80 - Claim Operating Physician NPI Number'
    ot_upin    = '85 - Claim Other Physician UPIN Number'
    ot_npi     = '86 - Claim Other Physician NPI Number'
    authrztn   = '93 - Claim Treatment Authorization Number'
    stus_cd    = '98 - Patient discharge status code'
    pps_ind    = '102 - Claim PPS Indicator Code'
    tot_chrg   = '103 - Claim total charge amount'
    prcrrtrn   = '104 - Claim Pricer Return Code'
    srvcfac    = '108 - Claim Service Facility Zip Code (Encrypted)'
    hhdgncnt   = '144 - HHA Claim diagnosis code count'
    hhrevcnt   = '151 - Claim Total Line count' /* Revenue Center Code Count */
    lupaind    = '154 - HHA low utilization payment adjustment'
    hha_rfrl   = '155 - Claim HHA referral code'
    visitcnt   = '156 - Claim HHA Total Visit Count'
    dschrgdtm  = '159 - NCH Beneficiary discharge month'
    dschrgdtd  = '159 - NCH Beneficiary discharge day'
    dschrgdty  = '159 - NCH Beneficiary discharge year'
    hhstrtdtm  = '160 - Claim HHA Care Start Month'
    hhstrtdtd  = '160 - Claim HHA Care Start Day'
    hhstrtdty  = '160 - Claim HHA Care Start Year'
    srvcnpi    = '171 - Claim Service Location NPI Number'
    dvrsncd1   = '194 - Claim Diagnosis Version Code #1'
    dvrsncd2   = '194 - Claim Diagnosis Version Code #2'
    dvrsncd3   = '194 - Claim Diagnosis Version Code #3'
    dvrsncd4   = '194 - Claim Diagnosis Version Code #4'
    dvrsncd5   = '194 - Claim Diagnosis Version Code #5'
    dvrsncd6   = '194 - Claim Diagnosis Version Code #6'
    dvrsncd7   = '194 - Claim Diagnosis Version Code #7'
    dvrsncd8   = '194 - Claim Diagnosis Version Code #8'
    dvrsncd9   = '194 - Claim Diagnosis Version Code #9'
    dvrsncd10  = '194 - Claim Diagnosis Version Code #10'
    dvrsncd11  = '194 - Claim Diagnosis Version Code #11'
    dvrsncd12  = '194 - Claim Diagnosis Version Code #12'
    dvrsncd13  = '194 - Claim Diagnosis Version Code #13'
    dvrsncd14  = '194 - Claim Diagnosis Version Code #14'
    dvrsncd15  = '194 - Claim Diagnosis Version Code #15'
    dvrsncd16  = '194 - Claim Diagnosis Version Code #16'
    dvrsncd17  = '194 - Claim Diagnosis Version Code #17'
    dvrsncd18  = '194 - Claim Diagnosis Version Code #18'
    dvrsncd19  = '194 - Claim Diagnosis Version Code #19'
    dvrsncd20  = '194 - Claim Diagnosis Version Code #20'
    dvrsncd21  = '194 - Claim Diagnosis Version Code #21'
    dvrsncd22  = '194 - Claim Diagnosis Version Code #22'
    dvrsncd23  = '194 - Claim Diagnosis Version Code #23'
    dvrsncd24  = '194 - Claim Diagnosis Version Code #24'
    dvrsncd25  = '194 - Claim Diagnosis Version Code #25'
    dgns_cd1   = '195 - Claim Diagnosis Code #1'
    dgns_cd2   = '195 - Claim Diagnosis Code #2'
    dgns_cd3   = '195 - Claim Diagnosis Code #3'
    dgns_cd4   = '195 - Claim Diagnosis Code #4'
    dgns_cd5   = '195 - Claim Diagnosis Code #5'
    dgns_cd6   = '195 - Claim Diagnosis Code #6'
    dgns_cd7   = '195 - Claim Diagnosis Code #7'
    dgns_cd8   = '195 - Claim Diagnosis Code #8'
    dgns_cd9   = '195 - Claim Diagnosis Code #9'
    dgns_cd10  = '195 - Claim Diagnosis Code #10'
    dgns_cd11  = '195 - Claim Diagnosis Code #11'
    dgns_cd12  = '195 - Claim Diagnosis Code #12'
    dgns_cd13  = '195 - Claim Diagnosis Code #13'
    dgns_cd14  = '195 - Claim Diagnosis Code #14'
    dgns_cd15  = '195 - Claim Diagnosis Code #15'
    dgns_cd16  = '195 - Claim Diagnosis Code #16'
    dgns_cd17  = '195 - Claim Diagnosis Code #17'
    dgns_cd18  = '195 - Claim Diagnosis Code #18'
    dgns_cd19  = '195 - Claim Diagnosis Code #19'
    dgns_cd20  = '195 - Claim Diagnosis Code #20'
    dgns_cd21  = '195 - Claim Diagnosis Code #21'
    dgns_cd22  = '195 - Claim Diagnosis Code #22'
    dgns_cd23  = '195 - Claim Diagnosis Code #23'
    dgns_cd24  = '195 - Claim Diagnosis Code #24'
    dgns_cd25  = '195 - Claim Diagnosis Code #25'
    rlt_cond1  = '202 - Claim related condition code 1'
    rlt_cond2  = '202 - Claim related condition code 2'
    ocrncind1  = '204 - NCH occurrence trailer indicator code 1'
    ocrncind2  = '204 - NCH occurrence trailer indicator code 2'
    ocrnc_cd1  = '205 - Claim related occurrence code 1'
    ocrnc_cd2  = '205 - Claim related occurrence code 2'
    ocrncdtm1  = '206 - Claim related occurrence month 1'
    ocrncdtd1  = '206 - Claim related occurrence day 1'
    ocrncdty1  = '206 - Claim related occurrence year 1'
    ocrncdtm2  = '206 - Claim related occurrence month 2'
    ocrncdtd2  = '206 - Claim related occurrence day 2'
    ocrncdty2  = '206 - Claim related occurrence year 2'
    rev_cntr   = '218 - Revenue Center Code'
    rev_dtm    = '219 - Revenue Center Month'
    rev_dtd    = '219 - Revenue Center Day'
    rev_dty    = '219 - Revenue Center Year'
    revansi1   = '220 - Revenue Center 1st ANSI Code'
    apchipps   = '224 - Revenue Center APC/HIPPS'
    hcpcs_cd   = '225 - Revenue Center HCPCS Code (Healthcare Common Procedure Coding System)'
    mdfr_cd1   = '226 - Revenue Center HCPCS Initial modifier code'
    mdfr_cd2   = '227 - HCPCS Second modifier code'
    rev_unit   = '239 - Revenue Center unit count'
    rev_rate   = '240 - Revenue Center rate amount'
    rev_msp1   = '245 - Revenue Center 1st Medicare Secondary Payer Paid Amount'
    rev_msp2   = '246 - Revenue Center 2nd Medicare Secondary Payer Paid Amount'
    rprvdpmt   = '247 - Revenue Center Provider Payment Amount'
    revpmt     = '250 - Revenue Center Payment Amount'
    rev_chrg   = '251 - Revenue Center Total Charge Amount'
    rev_ncvr   = '252 - Revenue Center Non-Covered Charge Amount'
    revdedcd   = '253 - Revenue Center Deductible coinsurance code'
    rstusind   = '255 - Revenue Center Status Indicator Code'
    dup_chk    = '256 - Revenue Center Duplicate Claim Check Indicator Code'
    year       = 'Year of Claims file'
    rec_count  = 'Claim record number'
    claim_id   = 'Claim ID'
    ;

run;

proc contents data=hha position;
run;