/* Published: 11/01/2018 */

/********************** COMMENTS ***************************************/
/* THIS INPUT STATMENT IS FOR THE 2018 SEER-MEDICARE LINKAGE.          */
/* IF YOU RECEIVED NCH 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 736) should be used to identify */
/* all the records for each claim per patient.  Both are needed to     */
/* identify a claim.                                                   */

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

options nocenter validvarname=upcase;

data nch;
  infile nchin lrecl=746 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 */
         @12  CLM_TYPE             $char2.
         @14  BIC                  $char2.
         @16  STATE_CD             $char2.
         @18  from_dtm             $char2.
         @20  from_dtd             $char2.
         @22  from_dty             $char4.
         @26  thru_dtm             $char2.
         @28  thru_dtd             $char2.
         @30  thru_dty             $char4.
         @34  ACRTN_DTM            $char2.
         @36  ACRTN_DTD            $char2.
         @38  ACRTN_DTY            $char4.
         @60  LINECNT              $char3.
         @63  ENTRY_CD             $char1.
         @64  CNTY_CD              $char3.
         @67  CARR_NUM             $char5.
         @72  BENE_ZIP             $char9.
         @81  MS_CD                $char2.
         @83  PDVRSNCD             $char1.
         @84  PDGNS_CD             $char7.
         @91  PMTDNLCD             $char2.
         @93  PMT_AMT              15.2
         @108 PRPAYAMT             15.2
         @123 RFR_UPIN             $char6.
         @129 RFR_NPI              $char10.
         @139 ASGMNTCD             $char1.
         @140 PROV_PMT             15.2
         @155 BENE_PMT             15.2
         @170 BENEPAID             15.2
         @185 SBMTCHRG             15.2
         @200 ALOWCHRG             15.2
         @215 DEDAPPLY             15.2
         @230 HCPCS_YR             $char1.
         @231 CTRILNUM             $char8.
         @239 RFR_PRFL             $char10.
         @249 CDGNCNT              $char2.
         @251 (DVRSNCD1-DVRSNCD12) ($char1.)
         @263 (DGNS_CD1-DGNS_CD12) ($char7.)
         @347 PRF_PRFL             $char10.
         @357 PRF_UPIN             $char6.
         @363 PRFNPI               $char10.
         @373 PRGRPNPI             $char10.
         @383 PRV_TYPE             $char1.
         @384 TAX_NUM              $char10.
         @394 PRVSTATE             $char2.
         @396 PROVZIP              $char9.
         @405 HCFASPCL             $char2.
         @407 PRTCPTG              $char1.
         @408 ASTNT_CD             $char1.
         @409 SRVC_CNT             12.3
         @421 TYPSRVCB             $char1.
         @422 PLCSRVC              $char2.
         @424 LCLTY_CD             $char2.
         @426 expnsdt1m            $char2.
         @428 expnsdt1d            $char2.
         @430 expnsdt1y            $char4.
         @434 expnsdt2m            $char2.
         @436 expnsdt2d            $char2.
         @438 expnsdt2y            $char4.
         @442 HCPCS_CD             $char5.
         @447 MDFR_CD1             $char2.
         @449 MDFR_CD2             $char2.
         @451 MDFR_CD3             $char2.
         @453 MDFR_CD4             $char2.
         @455 LINE_IDE             $char7.
         @462 LINEPMT              15.2
         @477 LBENPMT              15.2
         @492 LPRVPMT              15.2
         @507 LDEDAMT              15.2
         @522 LPRPAYCD             $char1.
         @523 LPRPDAMT             15.2
         @538 COINAMT              15.2
         @553 LLMTAMT              15.2
         @568 LINT_AMT             15.2
         @583 PRPYALOW             15.2
         @598 LSBMTCHG             15.2
         @613 LALOWCHG             15.2
         @628 LAB_NUM              $char10.
         @638 LAB_AMT              15.2
         @653 PRCNGIND             $char2.
         @655 PMTINDSW             $char1.
         @656 DED_SW               $char1.
         @657 PMTINDCD             $char1.
         @658 MTUS_CNT             12.3
         @670 MTUS_IND             $char1.
         @671 LDVRSNCD             $char1.
         @672 LINEDGNS             $char7.
         @679 ANSTHUNT             12.3
         @691 DUP_CHK              $char1.
         @692 HSCRCTY              $char1.
         @693 RX_NUM               $char30.
         @723 HTYPECD              $char2.
         @725 HRSLTNUM             4.1
         @729 YEAR                 $char4.
         @733 REC_COUNT            $char3.
         @736 CLAIM_ID             10.
    ;

  label
    patient_id = 'Patient ID'
 /* regcase    = 'SEER Registry Case Number' */
 /* HICBIC     = 'Non-Cancer Patient ID' */
    clm_type   = '7 - NCH Claim Type Code'
    bic        = '12 - Beneficiary Identification Code'
    state_cd   = '14 - Beneficiary Residence SSA Standard State Code'
    from_dtm   = '15 - Claim From Month'
    from_dtd   = '15 - Claim From Day'
    from_dty   = '15 - Claim From Year'
    thru_dtm   = '16 - Claim Through Month'
    thru_dtd   = '16 - Claim Through Day'
    thru_dty   = '16 - Claim Through Year'
    linecnt    = '26 - Claim Total Line Count'
    entry_cd   = '30 - Carrier Claim Entry Code'
    cnty_cd    = '35 - Beneficiary Residence SSA Standard County Code'
    carr_num   = '39 - Carrier Number'
    bene_zip   = '42 - Beneficiary Mailing Contact ZIP Code'  /*****Encrypted*****/
    ms_cd      = '46 - CWF Beneficiary Medicare Status Code'
    pdvrsncd   = '52 - Claim Principal Diagnosis Version Code'
    pdgns_cd   = '53 - Claim Principal Diagnosis Code'
    pmtdnlcd   = '55 - Carrier Claim Payment Denial Code'
    pmt_amt    = '57 - Claim Payment Amount'
    prpayamt   = '58 - Carrier Claim Primary Payer Paid Amount'
    rfr_upin   = '60 - Carrier Claim Referring UPIN Number'
    rfr_npi    = '61 - Carrier Claim Referring Physician NPI Number'
    asgmntcd   = '62 - Carrier Claim Provider Assignment Indicator Switch'
    prov_pmt   = '63 - NCH Claim Provider Payment Amount'
    bene_pmt   = '64 - NCH Claim Beneficiary Payment Amount'
    benepaid   = '65 - Carrier Claim Beneficiary Paid Amount'
    sbmtchrg   = '66 - NCH Carrier Claim Submitted Charge Amount'
    alowchrg   = '67 - NCH Claim Allowed Charge Amount'
    dedapply   = '68 - Carrier Claim Cash Deductible Applied Amount'
    hcpcs_yr   = '69 - Carrier Claim HCPCS Year Code'
    ctrilnum   = '73 - Claim Clinical Trial Number'
    rfr_prfl   = '93 - Carrier Referring PIN Number'
    cdgncnt    = '104 - Claim Diagnosis Code J Count'
    dvrsncd1   = '128 - Claim Diagnosis Version Code #1'
    dvrsncd2   = '128 - Claim Diagnosis Version Code #2'
    dvrsncd3   = '128 - Claim Diagnosis Version Code #3'
    dvrsncd4   = '128 - Claim Diagnosis Version Code #4'
    dvrsncd5   = '128 - Claim Diagnosis Version Code #5'
    dvrsncd6   = '128 - Claim Diagnosis Version Code #6'
    dvrsncd7   = '128 - Claim Diagnosis Version Code #7'
    dvrsncd8   = '128 - Claim Diagnosis Version Code #8'
    dvrsncd9   = '128 - Claim Diagnosis Version Code #9'
    dvrsncd10  = '128 - Claim Diagnosis Version Code #10'
    dvrsncd11  = '128 - Claim Diagnosis Version Code #11'
    dvrsncd12  = '128 - Claim Diagnosis Version Code #12'
    dgns_cd1   = '129 - Claim Diagnosis Code #1'
    dgns_cd2   = '129 - Claim Diagnosis Code #2'
    dgns_cd3   = '129 - Claim Diagnosis Code #3'
    dgns_cd4   = '129 - Claim Diagnosis Code #4'
    dgns_cd5   = '129 - Claim Diagnosis Code #5'
    dgns_cd6   = '129 - Claim Diagnosis Code #6'
    dgns_cd7   = '129 - Claim Diagnosis Code #7'
    dgns_cd8   = '129 - Claim Diagnosis Code #8'
    dgns_cd9   = '129 - Claim Diagnosis Code #9'
    dgns_cd10  = '129 - Claim Diagnosis Code #10'
    dgns_cd11  = '129 - Claim Diagnosis Code #11'
    dgns_cd12  = '129 - Claim Diagnosis Code #12'
    prf_prfl   = '132 - Performing Provider PIN Number'        /*******Encrypted********/
    prf_upin   = '133 - Carrier Line performing UPIN Number'
    prfnpi     = '134 - Carrier Line performing NPI Number'
    prgrpnpi   = '135 - Carrier Line performing group NPI Number'
    prv_type   = '136 - Carrier Line Provider Type Code'
    tax_num    = '137 - Line Provider Tax Number'
    prvstate   = '138 - Line NCH Provider State Code'
    provzip    = '139 - Carrier Line performing provider Zip Code'    /*******Encrypted********/
    hcfaspcl   = '140 - Line HCFA Provider Specialty Code'
    prtcptg    = '142 - Line Provider Participating Indicator Code'
    astnt_cd   = '143 - Carrier Line Reduced Payment Physician Assistant Code'
    srvc_cnt   = '144 - Line Service Count'
    typsrvcb   = '145 - Line HCFA Type Service Code'
    plcsrvc    = '147 - Line Place of Service Code'
    lclty_cd   = '148 - Carrier Line Pricing Locality Code'
    expnsdt1m  = '149 - Line First Expense Month'
    expnsdt1d  = '149 - Line First Expense Day'
    expnsdt1y  = '149 - Line First Expense Year'
    expnsdt2m  = '150 - Line Last Expense Month'
    expnsdt2d  = '150 - Line Last Expense Day'
    expnsdt2y  = '150 - Line Last Expense Year'
    hcpcs_cd   = '151 - Line HCPCS Code'
    mdfr_cd1   = '152 - Line HCPCS Initial Modifier Code'
    mdfr_cd2   = '153 - Line HCPCS Second Modifier Code'
    mdfr_cd3   = '154 - Line HCPCS Third Modifier Code'
    mdfr_cd4   = '155 - Line HCPCS Fourth Modifier Code'
    line_ide   = '157 - Line IDE Number'
    linepmt    = '159 - Line NCH Payment Amount'
    lbenpmt    = '160 - Line Beneficiary Payment Amount'
    lprvpmt    = '161 - Line Provider Payment Amount'
    ldedamt    = '162 - Line Beneficiary Part B Deductible Amount'
    lprpaycd   = '163 - Line Beneficiary Primary Payer Code'
    lprpdamt   = '164 - Line Beneficiary Primary Payer Paid Amount'
    coinamt    = '165 - Line Coinsurance Amount'
    llmtamt    = '166 - Carrier Line Psychiatric, Occupational Therapy, Physical Therapy Limit Amount'
    lint_amt   = '167 - Line Interest Amount'
    prpyalow   = '168 - Line Primary Payer Allowed Charge Amount'
    lsbmtchg   = '169 - Line Submitted Charge Amount'
    lalowchg   = '171 - Line Allowed Charge Amount'
    lab_num    = '172 - Carrier Line Clinical Lab Num'
    lab_amt    = '173 - Carrier Line Clinical Lab Charge amt.'
    prcngind   = '175 - Line Processing Indicator Code'
    pmtindsw   = '176 - Line Payment 80%/100% Code'
    ded_sw     = '177 - Line Service Deductible Indicator Switch'
    pmtindcd   = '178 - Line Payment Indicator Code'
    mtus_cnt   = '179 - Carrier Line Miles/Time/Units/Services Count'
    mtus_ind   = '180 - Carrier Line Miles/Time/Units/Services Indicator Code'
    ldvrsncd   = '182 - Line Diagnosis Version Code'
    linedgns   = '183 - Line Diagnosis Code'
    ansthunt   = '184 - Carrier Line Anesthesia Base Unit Count'
    dup_chk    = '191 - Line Duplicate Claim Check Indicator Code'
    hscrcty    = '194 - Carrier Line HPSA/Scarcity Indicator Code'
    rx_num     = '195 - Carrier Line RX Number'
    htypecd    = '196 - Line Hematocrit/Hemoglobin Test Type Code'
    hrsltnum   = '197 - Line Hematocrit/Hemoglobin Result Number'
    year       = 'Year of Claims File'
    rec_count  = 'Record Count for Claim'
    claim_id   = 'Claim ID'
    ;
run;

proc contents data=nch position;
run;