NOTE: PROCEDURE PRINTTO used (Total process time): real time 0.00 seconds cpu time 0.00 seconds 27 The SAS System 11:49 Monday, October 24, 2016 SYMBOLGEN: Macro variable YEAR resolves to 2006 MPRINT(LOOP): proc printto print="/homes/data/hcris/2540-96/read_snf_rpt_nmrc2006.lst" new; SYMBOLGEN: Macro variable YEAR resolves to 2006 MPRINT(LOOP): FILENAME datafile "/homes/data/hcris/2540-96/snf_2006_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 YEAR resolves to 2006 SYMBOLGEN: Macro variable DATASET resolves to snf_nmrc2540_96_2006_long NOTE: PROCEDURE PRINTTO used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(LOOP): data library.snf_nmrc2540_96_2006_long; MPRINT(LOOP): *snf_dm.* files report lengths; MPRINT(LOOP): LENGTH rpt_rec_num 5. wksht_cd $7. line_num $5. clmn_num $4. 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/2540-96/snf_2006_NMRC.CSV, Owner Name=jroth,Group Name=aging, Access Permission=-rw-r--r--, Last Modified=18Oct2016:00:41:56, File Size (bytes)=271253093 NOTE: 8275142 records were read from the infile DATAFILE. The minimum record length was 27. The maximum record length was 38. NOTE: The data set LIBRARY.SNF_NMRC2540_96_2006_LONG has 8275142 observations and 5 variables. NOTE: DATA statement used (Total process time): real time 2.94 seconds cpu time 2.24 seconds SYMBOLGEN: Macro variable DATASET resolves to snf_nmrc2540_96_2006_long MPRINT(LOOP): proc means data=library.snf_nmrc2540_96_2006_long n max; MPRINT(LOOP): title "Inspect maximums: Four bytes retain six significant digits" ; MPRINT(LOOP): run; NOTE: There were 8275142 observations read from the data set LIBRARY.SNF_NMRC2540_96_2006_LONG. NOTE: The PROCEDURE MEANS printed page 3008. NOTE: PROCEDURE MEANS used (Total process time): real time 0.36 seconds cpu time 0.34 seconds SYMBOLGEN: Macro variable DATASET resolves to snf_nmrc2540_96_2006_long MPRINT(LOOP): proc freq data=library.snf_nmrc2540_96_2006_long; MPRINT(LOOP): title "" ; MPRINT(LOOP): tables wksht_cd clmn_num ; NOTE: There were 8275142 observations read from the data set LIBRARY.SNF_NMRC2540_96_2006_LONG. NOTE: The PROCEDURE FREQ printed pages 3009-3014. NOTE: PROCEDURE FREQ used (Total process time): 28 The SAS System 11:49 Monday, October 24, 2016 real time 0.68 seconds cpu time 0.68 seconds SYMBOLGEN: Macro variable DATASET resolves to snf_nmrc2540_96_2006_long MPRINT(LOOP): proc freq order=freq data=library.snf_nmrc2540_96_2006_long; MPRINT(LOOP): title "Ordered by freq" ; MPRINT(LOOP): tables wksht_cd clmn_num ; NOTE: There were 8275142 observations read from the data set LIBRARY.SNF_NMRC2540_96_2006_LONG. NOTE: The PROCEDURE FREQ printed pages 3015-3020. NOTE: PROCEDURE FREQ used (Total process time): real time 0.67 seconds cpu time 0.68 seconds SYMBOLGEN: Macro variable DATASET resolves to snf_nmrc2540_96_2006_long MPRINT(LOOP): proc sort data=library.snf_nmrc2540_96_2006_long; MPRINT(LOOP): by wksht_cd; NOTE: There were 8275142 observations read from the data set LIBRARY.SNF_NMRC2540_96_2006_LONG. NOTE: The data set LIBRARY.SNF_NMRC2540_96_2006_LONG has 8275142 observations and 5 variables. NOTE: PROCEDURE SORT used (Total process time): real time 2.35 seconds cpu time 2.13 seconds SYMBOLGEN: Macro variable DATASET resolves to snf_nmrc2540_96_2006_long MPRINT(LOOP): proc freq data=library.snf_nmrc2540_96_2006_long; MPRINT(LOOP): title ""; MPRINT(LOOP): tables line_num; MPRINT(LOOP): by wksht_cd; NOTE: There were 8275142 observations read from the data set LIBRARY.SNF_NMRC2540_96_2006_LONG. NOTE: The PROCEDURE FREQ printed pages 3021-3156. NOTE: PROCEDURE FREQ used (Total process time): real time 0.60 seconds cpu time 0.60 seconds SYMBOLGEN: Macro variable DATASET resolves to snf_nmrc2540_96_2006_long MPRINT(LOOP): proc freq data=library.snf_nmrc2540_96_2006_long; MPRINT(LOOP): tables clmn_num; MPRINT(LOOP): by wksht_cd; NOTE: There were 8275142 observations read from the data set LIBRARY.SNF_NMRC2540_96_2006_LONG. NOTE: The PROCEDURE FREQ printed pages 3157-3278. NOTE: PROCEDURE FREQ used (Total process time): real time 0.47 seconds cpu time 0.46 seconds SYMBOLGEN: Macro variable DATASET resolves to snf_nmrc2540_96_2006_long SYMBOLGEN: Macro variable YEAR resolves to 2006 MPRINT(LOOP): proc sort data=library.snf_nmrc2540_96_2006_long nodupkey out=library.uniq_nmrc_2006; MPRINT(LOOP): by wksht_cd line_num clmn_num ; MLOGIC(LOOP): %DO loop index variable YEAR is now 2007; loop will iterate again. NOTE: There were 8275142 observations read from the data set LIBRARY.SNF_NMRC2540_96_2006_LONG. NOTE: 8263276 observations with duplicate key values were deleted. NOTE: The data set LIBRARY.UNIQ_NMRC_2006 has 11866 observations and 5 variables. NOTE: PROCEDURE SORT used (Total process time): 29 The SAS System 11:49 Monday, October 24, 2016 real time 2.33 seconds cpu time 2.56 seconds SYMBOLGEN: Macro variable YEAR resolves to 2007 MPRINT(LOOP): proc printto log ="/homes/data/hcris/2540-96/read_snf_rpt_nmrc2007.log" new;