/* Published: 09/01/2022 */ /************************** COMMENTS *******************************/ /* THIS INPUT STATMENT IS FOR THE 2022 SEER-MEDICARE LINKAGE. */ /* IF YOU RECEIVED Hospice 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 Hospice 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 hspbase '/directory/hsp2019.base.txt'; /* reading in an un-zipped file* / *filename hspbase pipe 'gunzip -c /directory/hsp2019.base.txt.gz'; /* reading in a zipped file */ *filename hspbase pipe 'gunzip -c /directory/hsp*.base.txt.gz'; /* using wildcard to match multiple files */ options nocenter validvarname=upcase; data hspbase; infile hspbase lrecl=639 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_TOT_CHRG_AMT 12.2 @241 NCH_PTNT_STATUS_IND_CD $char1. @242 CLM_UTLZTN_DAY_CNT $char3. @245 NCH_BENE_DSCHRG_DT $char8. /* YYMMDD8 */ @253 PRNCPAL_DGNS_CD $char7. @260 ICD_DGNS_CD1 $char7. @267 ICD_DGNS_CD2 $char7. @274 ICD_DGNS_CD3 $char7. @281 ICD_DGNS_CD4 $char7. @288 ICD_DGNS_CD5 $char7. @295 ICD_DGNS_CD6 $char7. @302 ICD_DGNS_CD7 $char7. @309 ICD_DGNS_CD8 $char7. @316 ICD_DGNS_CD9 $char7. @323 ICD_DGNS_CD10 $char7. @330 ICD_DGNS_CD11 $char7. @337 ICD_DGNS_CD12 $char7. @344 ICD_DGNS_CD13 $char7. @351 ICD_DGNS_CD14 $char7. @358 ICD_DGNS_CD15 $char7. @365 ICD_DGNS_CD16 $char7. @372 ICD_DGNS_CD17 $char7. @379 ICD_DGNS_CD18 $char7. @386 ICD_DGNS_CD19 $char7. @393 ICD_DGNS_CD20 $char7. @400 ICD_DGNS_CD21 $char7. @407 ICD_DGNS_CD22 $char7. @414 ICD_DGNS_CD23 $char7. @421 ICD_DGNS_CD24 $char7. @428 ICD_DGNS_CD25 $char7. @435 FST_DGNS_E_CD $char7. @442 ICD_DGNS_E_CD1 $char7. @449 ICD_DGNS_E_CD2 $char7. @456 ICD_DGNS_E_CD3 $char7. @463 ICD_DGNS_E_CD4 $char7. @470 ICD_DGNS_E_CD5 $char7. @477 ICD_DGNS_E_CD6 $char7. @484 ICD_DGNS_E_CD7 $char7. @491 ICD_DGNS_E_CD8 $char7. @498 ICD_DGNS_E_CD9 $char7. @505 ICD_DGNS_E_CD10 $char7. @512 ICD_DGNS_E_CD11 $char7. @519 ICD_DGNS_E_CD12 $char7. @526 CLM_HOSPC_START_DT_ID $char8. /* YYMMDD8 */ @534 BENE_HOSPC_PRD_CNT $char1. @535 DOB_YEAR $char4. @543 GNDR_CD $char1. @544 BENE_RACE_CD $char1. @545 BENE_CNTY_CD $char3. @548 BENE_STATE_CD $char2. @550 BENE_MLG_CNTCT_ZIP_CD $char9. /* Encrypted */ @559 CLM_MDCL_REC $char17. /* Encrypted */ @576 CLAIM_QUERY_CODE $char1. @577 FI_CLM_ACTN_CD $char1. @578 CLM_TRTMT_AUTHRZTN_NUM $char18. /* Encrypted */ @596 CLM_PRCR_RTRN_CD $char2. @598 CLM_SRVC_FAC_ZIP_CD $char9. /* Encrypted */ @607 CLM_NEXT_GNRTN_ACO_IND_CD1 $char1. @608 CLM_NEXT_GNRTN_ACO_IND_CD2 $char1. @609 CLM_NEXT_GNRTN_ACO_IND_CD3 $char1. @610 CLM_NEXT_GNRTN_ACO_IND_CD4 $char1. @611 CLM_NEXT_GNRTN_ACO_IND_CD5 $char1. @612 ACO_ID_NUM $char10. /* Encrypted */ @622 CLM_BENE_ID_TYPE_CD $char1. @623 CLM_RSDL_PYMT_IND_CD $char1. @624 PRVDR_VLDTN_TYPE_CD $char2. @626 RR_BRD_EXCLSN_IND_SW $char1. @627 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_TOT_CHRG_AMT = "Claim Total Charge Amount" NCH_PTNT_STATUS_IND_CD = "NCH Patient Status Indicator Code" CLM_UTLZTN_DAY_CNT = "Claim Utilization Day Count" NCH_BENE_DSCHRG_DT = "NCH Beneficiary Discharge Date" 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_HOSPC_START_DT_ID = "Claim Hospice Start Date" BENE_HOSPC_PRD_CNT = "Beneficiary's Hospice Period Count" 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_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" 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" CLM_MODEL_REIMBRSMT_AMT = "Claim Model Reimbursement Amount" ; run; proc contents data=hspbase position; run; *filename hsprev '/directory/hsp2019.revenue.txt'; /* reading in an un-zipped file* / *filename hsprev pipe 'gunzip -c /directory/hsp2019.revenue.txt.gz'; /* reading in a zipped file */ *filename hsprev pipe 'gunzip -c /directory/hsp*.revenue.txt.gz'; /* using wildcard to match multiple files */ options nocenter validvarname=upcase; data hsprevenue; infile hsprev lrecl=260 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 HCPCS_CD $char5. @071 HCPCS_1ST_MDFR_CD $char5. @076 HCPCS_2ND_MDFR_CD $char5. @081 HCPCS_3RD_MDFR_CD $char5. @086 REV_CNTR_UNIT_CNT $char8. @094 REV_CNTR_RATE_AMT 12.2 @106 REV_CNTR_PRVDR_PMT_AMT 12.2 @118 REV_CNTR_BENE_PMT_AMT 12.2 @130 REV_CNTR_PMT_AMT_AMT 12.2 @142 REV_CNTR_TOT_CHRG_AMT 12.2 @154 REV_CNTR_NCVRD_CHRG_AMT 12.2 @166 REV_CNTR_DDCTBL_COINSRNC_CD $char1. @167 REV_CNTR_NDC_QTY 10.3 @177 REV_CNTR_NDC_QTY_QLFR_CD $char2. @179 RNDRNG_PHYSN_UPIN $char6. /* Encrypted */ @191 RNDRNG_PHYSN_NPI $char10. /* Encrypted */ @203 RNDRNG_PHYSN_SPCLTY_CD $char2. @205 REV_CNTR_IDE_NDC_UPC_NUM $char24. @229 REV_CNTR_STUS_IND_CD $char2. @231 REV_CNTR_PRCNG_IND_CD $char2. @233 THRPY_CAP_IND_CD1 $char1. @234 THRPY_CAP_IND_CD2 $char1. @235 REV_CNTR_RP_IND_CD $char1. @236 RC_MODEL_REIMBRSMT_AMT 12.2 @248 RC_VLNTRY_SRVC_IND_CD $char1. @249 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" 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_UNIT_CNT = "Revenue Center Unit Count" REV_CNTR_RATE_AMT = "Revenue Center Rate Amount" REV_CNTR_PRVDR_PMT_AMT = "Revenue Center Provider Payment Amount" REV_CNTR_BENE_PMT_AMT = "Revenue Center Beneficiary Payment 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_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_IDE_NDC_UPC_NUM = "Revenue Center IDE, NDC, UPC Number" REV_CNTR_STUS_IND_CD = "Revenue Center Status Indicator Code" 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=hsprevenue position; run; *filename hspcond '/directory/hsp2019.condition.txt'; /* reading in an un-zipped file* / *filename hspcond pipe 'gunzip -c /directory/hsp2019.condition.txt.gz'; /* reading in a zipped file */ *filename hspcond pipe 'gunzip -c /directory/hsp*.condition.txt.gz'; /* using wildcard to match multiple files */ options nocenter validvarname=upcase; data hspcondition; infile hspcond 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=hspcondition position; run; *filename hspoccur '/directory/hsp2019.occurrence.txt'; /* reading in an un-zipped file* / *filename hspoccur pipe 'gunzip -c /directory/hsp2019.occurrence.txt.gz'; /* reading in a zipped file */ *filename hspoccur pipe 'gunzip -c /directory/hsp*.occurrence.txt.gz'; /* using wildcard to match multiple files */ options nocenter validvarname=upcase; data hspoccurrence; infile hspoccur lrecl=44 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_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=hspoccurrence position; run; *filename hspspan '/directory/hsp2019.span.txt'; /* reading in an un-zipped file* / *filename hspspan pipe 'gunzip -c /directory/hsp2019.span.txt.gz'; /* reading in a zipped file */ *filename hspspan pipe 'gunzip -c /directory/hsp*.span.txt.gz'; /* using wildcard to match multiple files */ options nocenter validvarname=upcase; data hspspan; infile hspspan 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=hspspan position; run; *filename hspvalue '/directory/hsp2019.value.txt'; /* reading in an un-zipped file* / *filename hspvalue pipe 'gunzip -c /directory/hsp2019.value.txt.gz'; /* reading in a zipped file */ *filename hspvalue pipe 'gunzip -c /directory/hsp*.value.txt.gz'; /* using wildcard to match multiple files */ options nocenter validvarname=upcase; data hspvalue; infile hspvalue 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=hspvalue position; run; *filename hspdemo '/directory/hsp2019.demo.txt'; /* reading in an un-zipped file* / *filename hspdemo pipe 'gunzip -c /directory/hsp2019.demo.txt.gz'; /* reading in a zipped file */ *filename hspdemo pipe 'gunzip -c /directory/hsp*.demo.txt.gz'; /* using wildcard to match multiple files */ options nocenter validvarname=upcase; data hspdemo; infile hspdemo 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=hspdemo position; Title 'proc contents, Hospice Demonstration/Innovation file'; run;