NOTE: PROCEDURE PRINTTO used (Total process time): real time 0.01 seconds cpu time 0.00 seconds SYMBOLGEN: Macro variable DASH resolves to 2552-10 SYMBOLGEN: Macro variable YEAR resolves to 2017 MPRINT(LOOP): proc printto print="/homes/data/hcris/2552-10/read_hosp_rpt_nmrc2017.lst" new; SYMBOLGEN: Macro variable FILEPATH resolves to /homes/data/hcris/2552-10/hosp10_2017_NMRC.CSV MPRINT(LOOP): FILENAME datafile "/homes/data/hcris/2552-10/hosp10_2017_NMRC.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 2552_10 SYMBOLGEN: Macro variable YEAR resolves to 2017 SYMBOLGEN: Macro variable DATASET resolves to hosp_nmrc2552_10_2017_long NOTE: PROCEDURE PRINTTO used (Total process time): real time 0.01 seconds cpu time 0.00 seconds MPRINT(LOOP): data library.hosp_nmrc2552_10_2017_long; MPRINT(LOOP): *hosp_dm.* files report lengths; MPRINT(LOOP): LENGTH rpt_rec_num 5. wksht_cd $7. line_num $5. clmn_num $5. itm_val_num 7. ; 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): INPUT rpt_rec_num wksht_cd $ line_num $ clmn_num $ itm_val_num ; NOTE: The infile DATAFILE is: Filename=/homes/data/hcris/2552-10/hosp10_2017_NMRC.CSV, Owner Name=jroth,Group Name=aging, Access Permission=-rw-r--r--, Last Modified=08Apr2019:17:03:36, File Size (bytes)=664125017 NOTE: 19264045 records were read from the infile DATAFILE. The minimum record length was 28. The maximum record length was 40. NOTE: The data set LIBRARY.HOSP_NMRC2552_10_2017_LONG has 19264045 observations and 5 variables. 24 The SAS System 17:22 Monday, April 15, 2019 NOTE: DATA statement used (Total process time): real time 10.49 seconds cpu time 7.54 seconds SYMBOLGEN: Macro variable DATASET resolves to hosp_nmrc2552_10_2017_long MPRINT(LOOP): proc means data=library.hosp_nmrc2552_10_2017_long n max; MPRINT(LOOP): title "Inspect maximums: Four bytes retain six significant digits" ; MPRINT(LOOP): run; NOTE: There were 19264045 observations read from the data set LIBRARY.HOSP_NMRC2552_10_2017_LONG. NOTE: The PROCEDURE MEANS printed page 13059. NOTE: PROCEDURE MEANS used (Total process time): real time 1.66 seconds cpu time 1.18 seconds SYMBOLGEN: Macro variable DATASET resolves to hosp_nmrc2552_10_2017_long MPRINT(LOOP): proc freq data=library.hosp_nmrc2552_10_2017_long; MPRINT(LOOP): title "" ; MPRINT(LOOP): tables wksht_cd clmn_num ; NOTE: There were 19264045 observations read from the data set LIBRARY.HOSP_NMRC2552_10_2017_LONG. NOTE: The PROCEDURE FREQ printed pages 13060-13084. NOTE: PROCEDURE FREQ used (Total process time): real time 1.86 seconds cpu time 1.87 seconds SYMBOLGEN: Macro variable DATASET resolves to hosp_nmrc2552_10_2017_long MPRINT(LOOP): proc freq order=freq data=library.hosp_nmrc2552_10_2017_long; MPRINT(LOOP): title "Ordered by freq" ; MPRINT(LOOP): tables wksht_cd clmn_num ; NOTE: There were 19264045 observations read from the data set LIBRARY.HOSP_NMRC2552_10_2017_LONG. NOTE: The PROCEDURE FREQ printed pages 13085-13109. NOTE: PROCEDURE FREQ used (Total process time): real time 1.98 seconds cpu time 1.86 seconds SYMBOLGEN: Macro variable DATASET resolves to hosp_nmrc2552_10_2017_long MPRINT(LOOP): proc sort data=library.hosp_nmrc2552_10_2017_long; MPRINT(LOOP): by wksht_cd; NOTE: There were 19264045 observations read from the data set LIBRARY.HOSP_NMRC2552_10_2017_LONG. NOTE: The data set LIBRARY.HOSP_NMRC2552_10_2017_LONG has 19264045 observations and 5 variables. NOTE: PROCEDURE SORT used (Total process time): real time 6.27 seconds cpu time 7.73 seconds SYMBOLGEN: Macro variable DATASET resolves to hosp_nmrc2552_10_2017_long MPRINT(LOOP): proc freq data=library.hosp_nmrc2552_10_2017_long; MPRINT(LOOP): title ""; MPRINT(LOOP): tables line_num; MPRINT(LOOP): by wksht_cd; NOTE: There were 19264045 observations read from the data set LIBRARY.HOSP_NMRC2552_10_2017_LONG. NOTE: The PROCEDURE FREQ printed pages 13110-14328. NOTE: PROCEDURE FREQ used (Total process time): real time 3.41 seconds 25 The SAS System 17:22 Monday, April 15, 2019 cpu time 1.89 seconds SYMBOLGEN: Macro variable DATASET resolves to hosp_nmrc2552_10_2017_long MPRINT(LOOP): proc freq data=library.hosp_nmrc2552_10_2017_long; MPRINT(LOOP): tables clmn_num; MPRINT(LOOP): by wksht_cd; NOTE: There were 19264045 observations read from the data set LIBRARY.HOSP_NMRC2552_10_2017_LONG. NOTE: The PROCEDURE FREQ printed pages 14329-15156. NOTE: PROCEDURE FREQ used (Total process time): real time 1.26 seconds cpu time 1.27 seconds SYMBOLGEN: Macro variable DATASET resolves to hosp_nmrc2552_10_2017_long SYMBOLGEN: Macro variable YEAR resolves to 2017 MPRINT(LOOP): proc sort data=library.hosp_nmrc2552_10_2017_long nodupkey out=library.uniq_nmrc_2017; MPRINT(LOOP): by wksht_cd line_num clmn_num ; MLOGIC(LOOP): %DO loop index variable YEAR is now 2018; loop will iterate again. MLOGIC(LOOP): %PUT year=&year. SYMBOLGEN: Macro variable YEAR resolves to 2018 year=2018 MLOGIC(LOOP): %LET (variable name is FILEPATH) SYMBOLGEN: Macro variable DASH resolves to 2552-10 SYMBOLGEN: Macro variable YEAR resolves to 2018 NOTE: There were 19264045 observations read from the data set LIBRARY.HOSP_NMRC2552_10_2017_LONG. NOTE: 19028635 observations with duplicate key values were deleted. NOTE: The data set LIBRARY.UNIQ_NMRC_2017 has 235410 observations and 5 variables. NOTE: PROCEDURE SORT used (Total process time): real time 3.50 seconds cpu time 6.33 seconds SYMBOLGEN: Macro variable DASH resolves to 2552-10 SYMBOLGEN: Macro variable YEAR resolves to 2018 MPRINT(LOOP): proc printto log ="/homes/data/hcris/2552-10/read_hosp_rpt_nmrc2018.log" new;