/*Published: 11/01/2018*/

/**************************   COMMENTS   *******************************/
/* THIS INPUT STATMENT IS FOR THE 2018 SEER-MEDICARE LINKAGE.          */
/* IF YOU RECEIVED HOSPICE 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 677) 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 92).  The value from the record     */
/* count (column 674) 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 inhsp '/directory/hspsaf16.txt';                    /* reading in an un-zipped file */              /* Input file references were "inout" in LINK10, changed to inhsp */
filename inhsp pipe 'gunzip -c /directory/hspsaf16.txt.gz';  /* reading in a zipped file */                  /* Input file references were "inout" in LINK10, changed to inhsp */
*filename inhsp pipe 'gunzip -c /directory/hspsaf*.txt.gz';   /* using wildcard to match multiple files */    /* Input file references were "inout" in LINK10, changed to inhsp */

options nocenter validvarname=upcase;

data hospice;
  infile inhsp lrecl=687 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  CLM_TYPE             $char2.
     @014  BIC                  $char2.
     @016  STATE_CD             $char2.
     @018  from_dtm             $char2.
     @020  from_dtd             $char2.
     @022  from_dty             $char4.
     @026  thru_dtm             $char2.
     @028  thru_dtd             $char2.
     @030  thru_dty             $char4.
     @034  QUERY_CD             $char1.
     @035  provider             $char6.
     @059  SGMT_CNT             $char2.
     @061  SGMT_NUM             $char2.
     @063  LINECNT              $char3.
     @066  SGMTLINE             $char2.
     @068  FAC_TYPE             $char1.
     @069  TYPESRVC             $char1.
     @070  FREQ_CD              $char1.
     @071  CNTY_CD              $char3.
     @074  FI_NUM               $char5.
     @079  BENE_ZIP             $char9.
     @088  MS_CD                $char2.
     @090  NOPAY_CD             $char2.
     @092  PMT_AMT              15.2
     @107  PRPAYAMT             15.2
     @122  PRPAY_CD             $char1.
     @123  ACTIONCD             $char1.
     @124  PRSTATE              $char2.
     @126  orgnpinm             $char10.
     @136  at_upin              $char6.
     @142  at_npi               $char10.
     @152  op_upin              $char6.
     @158  op_npi               $char10.
     @168  ot_upin              $char6.
     @174  ot_npi               $char10.
     @184  STUS_CD              $char2.
     @186  PPS_IND              $char1.
     @187  TOT_CHRG             15.2
     @202  SRVCFAC              $char9.
     @211  HSDGNCNT             $char2.
     @213  HSREVCNT             $char2.
     @215  PTNTSTUS             $char1.
     @216  HSPCSTRTM            $char2.
     @218  HSPCSTRTD            $char2.
     @220  HSPCSTRTY            $char4.
     @224  EXHST_DTM            $char2.
     @226  EXHST_DTD            $char2.
     @228  EXHST_DTY            $char4.
     @232  DSCHRGDTM            $char2.
     @234  DSCHRGDTD            $char2.
     @236  DSCHRGDTY            $char4.
     @240  UTIL_DAY             3.
     @243  HOSPCPRD             $char1.
     @244  srvcnpi              $char10.
     @254  (DVRSNCD1-DVRSNCD25) ($char1.)
     @279  (DGNS_CD1-DGNS_CD25) ($char7.)
     @454  (rlt_cond1-rlt_cond2) ($char2.)
     @458  OCRNCIND1            $char1.
     @459  OCRNCIND2            $char1.
     @460  OCRNC_CD1            $char2.
     @462  OCRNC_CD2            $char2.
     @464  OCRNCDTM1            $char2.
     @466  OCRNCDTD1            $char2.
     @468  OCRNCDTY1            $char4.
     @472  OCRNCDTM2            $char2.
     @474  OCRNCDTD2            $char2.
     @476  OCRNCDTY2            $char4.
     @480  rev_cntr             $char4.
     @484  REV_DTM              $char2.
     @486  REV_DTD              $char2.
     @488  REV_DTY              $char4.
     @492  REVANSI1             $char5.
     @497  hcpcs_cd             $char5.
     @502  MDFR_CD1             $char2.
     @504  MDFR_CD2             $char2.
     @506  PRICNG               $char2.
     @508  IDENDC               $char24.
     @532  QTYQLFR              $char2.
     @534  NDCQTY               12.3
     @546  rev_unit             8.
     @554  rev_rate             15.2
     @569  REV_MSP1             15.2
     @584  REV_MSP2             15.2
     @599  RPRVDPMT             15.2
     @614  REVPMT               15.2
     @629  rev_chrg             15.2
     @644  REV_NCVR             15.2
     @659  revdedcd             $char1.
     @660  revnpi               $char10.
     @670  YEAR                 $char4.
     @674  REC_COUNT            $char3.
     @677  CLAIM_ID             10.
     ;

  label
    patient_id = 'Patient ID'
    /*regcase  = 'SEER Registry Case Number - Cancer Patients'*/
    /*hicbic   = 'Patient ID for the Non Cancer Patients'*/
    clm_type   = '7 - NCH Claim Type Code'
    bic        = '12 - Beneficiary Identification Code'
    state_cd   = '14 - Beneficiary Residence 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 Code'
    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'
    stus_cd    = '98 - Patient Discharge Status Code'
    pps_ind    = '102 - Claim PPS Indicator Code'
    tot_chrg   = '103 - Claim Total Charge Amount'
    srvcfac    = '108 - Claim Service Facility Zip Code (Encrypted)'
    hsdgncnt   = '144 - Hospice Claim Diagnosis Code Count'
    hsrevcnt   = '124 - Hospice Claim Total Line Count' /* Revenue Center Code Count */
    ptntstus   = '127 - NCH Patient Status Indicator Code'
    hspcstrtm  = '128 - Claim Hospice Start Month'
    hspcstrtd  = '128 - Claim Hospice Start Day'
    hspcstrty  = '128 - Claim Hospice Start Year'
    exhst_dtm  = '129 - NCH Beneficiary Medicare Benefits Exhausted Month'
    exhst_dtd  = '129 - NCH Beneficiary Medicare Benefits Exhausted Day'
    exhst_dty  = '129 - NCH Beneficiary Medicare Benefits Exhausted Year'
    dschrgdtm  = '130 - NCH Beneficiary Discharge Month'
    dschrgdtd  = '130 - NCH Beneficiary Discharge Day'
    dschrgdty  = '130 - NCH Beneficiary Discharge Year'
    util_day   = '131 - Claim Utilization Days Count'
    hospcprd   = '132 - Beneficiary Hospice Period Count'
    srvcnpi    = '170 - Claim Service Location NPI Number (encrypted)'
    dvrsncd1   = '193 - Claim Diagnosis Version Code #1'
    dvrsncd2   = '193 - Claim Diagnosis Version Code #2'
    dvrsncd3   = '193 - Claim Diagnosis Version Code #3'
    dvrsncd4   = '193 - Claim Diagnosis Version Code #4'
    dvrsncd5   = '193 - Claim Diagnosis Version Code #5'
    dvrsncd6   = '193 - Claim Diagnosis Version Code #6'
    dvrsncd7   = '193 - Claim Diagnosis Version Code #7'
    dvrsncd8   = '193 - Claim Diagnosis Version Code #8'
    dvrsncd9   = '193 - Claim Diagnosis Version Code #9'
    dvrsncd10  = '193 - Claim Diagnosis Version Code #10'
    dvrsncd11  = '193 - Claim Diagnosis Version Code #11'
    dvrsncd12  = '193 - Claim Diagnosis Version Code #12'
    dvrsncd13  = '193 - Claim Diagnosis Version Code #13'
    dvrsncd14  = '193 - Claim Diagnosis Version Code #14'
    dvrsncd15  = '193 - Claim Diagnosis Version Code #15'
    dvrsncd16  = '193 - Claim Diagnosis Version Code #16'
    dvrsncd17  = '193 - Claim Diagnosis Version Code #17'
    dvrsncd18  = '193 - Claim Diagnosis Version Code #18'
    dvrsncd19  = '193 - Claim Diagnosis Version Code #19'
    dvrsncd20  = '193 - Claim Diagnosis Version Code #20'
    dvrsncd21  = '193 - Claim Diagnosis Version Code #21'
    dvrsncd22  = '193 - Claim Diagnosis Version Code #22'
    dvrsncd23  = '193 - Claim Diagnosis Version Code #23'
    dvrsncd24  = '193 - Claim Diagnosis Version Code #24'
    dvrsncd25  = '193 - Claim Diagnosis Version Code #25'
    dgns_cd1   = '194 - Claim Diagnosis Code #1'
    dgns_cd2   = '194 - Claim Diagnosis Code #2'
    dgns_cd3   = '194 - Claim Diagnosis Code #3'
    dgns_cd4   = '194 - Claim Diagnosis Code #4'
    dgns_cd5   = '194 - Claim Diagnosis Code #5'
    dgns_cd6   = '194 - Claim Diagnosis Code #6'
    dgns_cd7   = '194 - Claim Diagnosis Code #7'
    dgns_cd8   = '194 - Claim Diagnosis Code #8'
    dgns_cd9   = '194 - Claim Diagnosis Code #9'
    dgns_cd10  = '194 - Claim Diagnosis Code #10'
    dgns_cd11  = '194 - Claim Diagnosis Code #11'
    dgns_cd12  = '194 - Claim Diagnosis Code #12'
    dgns_cd13  = '194 - Claim Diagnosis Code #13'
    dgns_cd14  = '194 - Claim Diagnosis Code #14'
    dgns_cd15  = '194 - Claim Diagnosis Code #15'
    dgns_cd16  = '194 - Claim Diagnosis Code #16'
    dgns_cd17  = '194 - Claim Diagnosis Code #17'
    dgns_cd18  = '194 - Claim Diagnosis Code #18'
    dgns_cd19  = '194 - Claim Diagnosis Code #19'
    dgns_cd20  = '194 - Claim Diagnosis Code #20'
    dgns_cd21  = '194 - Claim Diagnosis Code #21'
    dgns_cd22  = '194 - Claim Diagnosis Code #22'
    dgns_cd23  = '194 - Claim Diagnosis Code #23'
    dgns_cd24  = '194 - Claim Diagnosis Code #24'
    dgns_cd25  = '194 - Claim Diagnosis Code #25'
    rlt_cond1  = '206 - Claim Related Condition Code 1'
    rlt_cond2  = '206 - Claim Related Condition Code 2'
    ocrncind1  = '208 - NCH Occurrence Trailer Indicator Code 1'
    ocrncind2  = '208 - NCH Occurrence Trailer Indicator Code 2'
    ocrnc_cd1  = '209 - Claim Related Occurrence Code 1'
    ocrnc_cd2  = '209 - Claim Related Occurrence Code 2'
    ocrncdtm1  = '210 - Claim Related Occurrence Month 1'
    ocrncdtd1  = '210 - Claim Related Occurrence Day 1'
    ocrncdty1  = '210 - Claim Related Occurrence Year 1'
    ocrncdtm2  = '210 - Claim Related Occurrence Month 2'
    ocrncdtd2  = '210 - Claim Related Occurrence Day 2'
    ocrncdty2  = '210 - Claim Related Occurrence Year 2'
    rev_cntr   = '222 - Revenue Center Code'
    rev_dtm    = '223 - Revenue Center Month'
    rev_dtd    = '223 - Revenue Center Day'
    rev_dty    = '223 - Revenue Center Year'
    revansi1   = '224 - Revenue Center 1st ANSI Code'
    hcpcs_cd   = '229 - Revenue Center HCPCS Code (Healthcare Common Procedure Coding System)'
    mdfr_cd1   = '230 - Revenue Center HCPCS Initial Modifier Code'
    mdfr_cd2   = '231 - Revenue Center HCPCS Second Modifier Code'
    pricng     = '238 - Revenue Center Pricing Indicator Code'
    idendc     = '240 - Revenue Center IDE, NDC, UPC Number'
    qtyqlfr    = '241 - Revenue Center NDC Quantity Qualifier Code'
    ndcqty     = '242 - Revenue Center NDC Quantity'
    rev_unit   = '243 - Revenue Center Unit Count'
    rev_rate   = '244 - Revenue Center Rate Amount'
    rev_msp1   = '249 - Revenue Center 1st Medicare Secondary Payer Paid Amount'
    rev_msp2   = '250 - Revenue Center 2nd Medicare Secondary Payer Paid Amount'
    rprvdpmt   = '251 - Revenue Center Provider Payment Amount'
    revpmt     = '254 - Revenue Center Payment Amount'
    rev_chrg   = '255 - Revenue Center Total Charge Amount'
    rev_ncvr   = '256 - Revenue Center Non-Covered Charge Amount'
    revdedcd   = '257 - Revenue Center Deductible Coinsurance Code'
    revnpi     = '262 - Revenue Center Rendering Physician NPI Number'
    year       = 'Year of Claim File'
    rec_count  = 'Record Count For Claim'
    claim_id   = 'Claim ID'
    ;

run;

proc contents data=hospice position;
run;