NOTE: PROCEDURE PRINTTO used (Total process time): real time 0.00 seconds cpu time 0.00 seconds SYMBOLGEN: Macro variable DASH resolves to 222-92 SYMBOLGEN: Macro variable UNDERSCORE resolves to 222_92 SYMBOLGEN: Macro variable YEAR resolves to 2017 MPRINT(LOOP): proc printto print="/homes/data/hcris/hclinic/222-92/read_hclinic_rpt222_92_2017.lst" new; SYMBOLGEN: Macro variable FILEPATH resolves to /homes/data/hcris/222-92/hclinic_&year._RPT.CSV SYMBOLGEN: Macro variable YEAR resolves to 2017 MPRINT(LOOP): FILENAME datafile "/homes/data/hcris/222-92/hclinic_2017_RPT.CSV"; MPRINT(LOOP): * The following line should contain the name of the SAS dataset ; MLOGIC(LOOP): %LET (variable name is DATASET) SYMBOLGEN: Macro variable UNDERSCORE resolves to 222_92 SYMBOLGEN: Macro variable YEAR resolves to 2017 SYMBOLGEN: Macro variable DATASET resolves to library.hclinic_rpt222_92_2017 NOTE: PROCEDURE PRINTTO used (Total process time): real time 0.00 seconds 26 The SAS System 18:09 Monday, April 15, 2019 cpu time 0.00 seconds MPRINT(LOOP): data library.hclinic_rpt222_92_2017; MPRINT(LOOP): *hosp_dm.* files report lengths; MPRINT(LOOP): *Using a length of 4 bytes retains 6 significant digits; MPRINT(LOOP): *Largest integer represented exactly is 2,097,152; MPRINT(LOOP): *Maximum values apply to 2002-09-30 data file; MPRINT(LOOP): *max date is around 16000, do length of 4 should be fine for dates; MPRINT(LOOP): *Variable Maximum --------- ------- RPT_REC_NUM 64331 Primary Key / Unique ID PRVDR_CTRL_TYPE_CD "13" PRVDR_NUM "660001" RPT_STUS_CD "4" INITL_RPT_SW "Y" LAST_RPT_SW "Y" TRNSMTL_NUM "8" FI_NUM "77002" ADR_VNDR_CD "4" UTIL_CD "F" SPEC_IND "Y" ; MPRINT(LOOP): LENGTH rpt_rec_num 5 prvdr_ctrl_type_cd $2 prvdr_num $7 rpt_stus_cd 3 initl_rpt_sw $1 last_rpt_sw $1 trnsmtl_num $1 fi_num $5 adr_vndr_cd $1 util_cd $1 spec_ind $1 default = 4; MPRINT(LOOP): * '2C' is hexadecimal for decimal 44 which represents ',' ; MPRINT(LOOP): * '0D' is hexadecimal for decimal 13 which represents '\r', which is the carriage return character; MPRINT(LOOP): infile datafile dsd delimiter='2C0D'x ; MPRINT(LOOP): ** the ":" is a format modifier that reads data values that need additional instructions from an informat; MPRINT(LOOP): INPUT rpt_rec_num prvdr_ctrl_type_cd $ prvdr_num $ npi $ rpt_stus_cd fy_bgn_dt : mmddyy10. fy_end_dt : mmddyy10. proc_dt : mmddyy10. initl_rpt_sw $ last_rpt_sw $ trnsmtl_num $ fi_num $ adr_vndr_cd $ fi_creat_dt : mmddyy10. util_cd $ npr_dt : mmddyy10. spec_ind $ fi_rcpt_dt : mmddyy10. ; MPRINT(LOOP): LABEL rpt_rec_num= "Report Record Number" prvdr_ctrl_type_cd = "Provider Control Type Code" prvdr_num = "Provider Number" npi= "National Provider Identifier" rpt_stus_cd= "Report Status Code" fy_bgn_dt= "Fiscal Year Begin Date" fy_end_dt= "Fiscal Year End Date" proc_dt = "HCRIS Process Date" initl_rpt_sw= "Initial Report Switch" last_rpt_sw= "Last Report Switch" trnsmtl_num= "Transmittal Number" fi_num = "Fiscal Intermediary Number" adr_vndr_cd= "Automated Desk Review Vendor Code" fi_creat_dt= "Fiscal Intermediary Create Date" util_cd = "Utilization Code" npr_dt = "Notice of Program Reimbursement Date" spec_ind= "Special Indicator" fi_rcpt_dt= "Fiscal Intermediary Receipt Date" ; MPRINT(LOOP): FORMAT fy_bgn_dt MMDDYYS10. fy_end_dt MMDDYYS10. proc_dt MMDDYYS10. fi_creat_dt MMDDYYS10. npr_dt MMDDYYS10. fi_rcpt_dt MMDDYYS10. ; NOTE: The infile DATAFILE is: Filename=/homes/data/hcris/222-92/hclinic_2017_RPT.CSV, Owner Name=jroth,Group Name=web, Access Permission=-rw-r--r--, Last Modified=08Apr2019:08:50:24, File Size (bytes)=122608 NOTE: 1303 records were read from the infile DATAFILE. The minimum record length was 69. The maximum record length was 103. NOTE: The data set LIBRARY.HCLINIC_RPT222_92_2017 has 1303 observations and 18 variables. NOTE: DATA statement used (Total process time): real time 0.04 seconds cpu time 0.01 seconds SYMBOLGEN: Macro variable DATASET resolves to library.hclinic_rpt222_92_2017 MPRINT(LOOP): proc sort data=library.hclinic_rpt222_92_2017; MPRINT(LOOP): by rpt_rec_num; NOTE: There were 1303 observations read from the data set LIBRARY.HCLINIC_RPT222_92_2017. NOTE: The data set LIBRARY.HCLINIC_RPT222_92_2017 has 1303 observations and 18 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.00 seconds cpu time 0.00 seconds SYMBOLGEN: Macro variable DATASET resolves to library.hclinic_rpt222_92_2017 MPRINT(LOOP): proc means DATA=library.hclinic_rpt222_92_2017 max n; MPRINT(LOOP): title "Inspect maximums: Using a length of 4 bytes (default) retains 6 significant digits" ; 27 The SAS System 18:09 Monday, April 15, 2019 NOTE: There were 1303 observations read from the data set LIBRARY.HCLINIC_RPT222_92_2017. NOTE: The PROCEDURE MEANS printed page 60. NOTE: PROCEDURE MEANS used (Total process time): real time 0.00 seconds cpu time 0.01 seconds SYMBOLGEN: Macro variable DATASET resolves to library.hclinic_rpt222_92_2017 MPRINT(LOOP): proc freq DATA=library.hclinic_rpt222_92_2017 ; MPRINT(LOOP): title "" ; MPRINT(LOOP): tables prvdr_ctrl_type_cd rpt_stus_cd initl_rpt_sw last_rpt_sw trnsmtl_num fi_num adr_vndr_cd util_cd spec_ind ; MPRINT(LOOP): FORMAT prvdr_ctrl_type_cd $prvdr_ctrl_type_cd. rpt_stus_cd rpt_stus_cd. initl_rpt_sw $initl_rpt_sw. last_rpt_sw $last_rpt_sw. adr_vndr_cd $adr_vndr_cd. util_cd $util_cd. ; NOTE: There were 1303 observations read from the data set LIBRARY.HCLINIC_RPT222_92_2017. NOTE: The PROCEDURE FREQ printed pages 61-63. NOTE: PROCEDURE FREQ used (Total process time): real time 0.00 seconds cpu time 0.00 seconds SYMBOLGEN: Macro variable DATASET resolves to library.hclinic_rpt222_92_2017 MPRINT(LOOP): proc print DATA=library.hclinic_rpt222_92_2017 (obs=6); NOTE: There were 6 observations read from the data set LIBRARY.HCLINIC_RPT222_92_2017. NOTE: The PROCEDURE PRINT printed page 64. NOTE: PROCEDURE PRINT used (Total process time): real time 0.00 seconds cpu time 0.00 seconds SYMBOLGEN: Macro variable DATASET resolves to library.hclinic_rpt222_92_2017 MPRINT(LOOP): proc contents DATA=library.hclinic_rpt222_92_2017; MLOGIC(LOOP): %DO loop index variable YEAR is now 2018; loop will iterate again. NOTE: The PROCEDURE CONTENTS printed pages 65-66. NOTE: PROCEDURE CONTENTS used (Total process time): real time 0.00 seconds cpu time 0.00 seconds SYMBOLGEN: Macro variable DASH resolves to 222-92 SYMBOLGEN: Macro variable UNDERSCORE resolves to 222_92 SYMBOLGEN: Macro variable YEAR resolves to 2018 MPRINT(LOOP): proc printto log ="/homes/data/hcris/hclinic/222-92/read_hclinic_rpt222_92_2018.log" new;