NOTE: PROCEDURE PRINTTO used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds
      

SYMBOLGEN:  Macro variable YEAR resolves to 2004
MPRINT(LOOP):   proc printto print="/homes/data/hcris/2540-96/read_snf_rpt_nmrc2004.lst" new;
SYMBOLGEN:  Macro variable YEAR resolves to 2004
MPRINT(LOOP):   FILENAME datafile "/homes/data/hcris/2540-96/snf_2004_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 2004
SYMBOLGEN:  Macro variable DATASET resolves to snf_nmrc2540_96_2004_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_2004_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;
23 The SAS System                                                                                     11:49 Monday, October 24, 2016

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_2004_NMRC.CSV,
      Owner Name=jroth,Group Name=aging,
      Access Permission=-rw-r--r--,
      Last Modified=17Oct2016:23:40:10,
      File Size (bytes)=263646508

NOTE: 8045845 records were read from the infile DATAFILE.
      The minimum record length was 27.
      The maximum record length was 39.
NOTE: The data set LIBRARY.SNF_NMRC2540_96_2004_LONG has 8045845 observations and 5 variables.
NOTE: DATA statement used (Total process time):
      real time           2.83 seconds
      cpu time            2.21 seconds
      

SYMBOLGEN:  Macro variable DATASET resolves to snf_nmrc2540_96_2004_long
MPRINT(LOOP):   proc means data=library.snf_nmrc2540_96_2004_long n max;
MPRINT(LOOP):   title "Inspect maximums:  Four bytes retain six significant digits" ;
MPRINT(LOOP):   run;

NOTE: There were 8045845 observations read from the data set LIBRARY.SNF_NMRC2540_96_2004_LONG.
NOTE: The PROCEDURE MEANS printed page 2479.
NOTE: PROCEDURE MEANS used (Total process time):
      real time           0.34 seconds
      cpu time            0.32 seconds
      

SYMBOLGEN:  Macro variable DATASET resolves to snf_nmrc2540_96_2004_long
MPRINT(LOOP):   proc freq data=library.snf_nmrc2540_96_2004_long;
MPRINT(LOOP):   title "" ;
MPRINT(LOOP):   tables wksht_cd clmn_num ;
NOTE: There were 8045845 observations read from the data set LIBRARY.SNF_NMRC2540_96_2004_LONG.
NOTE: The PROCEDURE FREQ printed pages 2480-2485.
NOTE: PROCEDURE FREQ used (Total process time):
      real time           0.68 seconds
      cpu time            0.68 seconds
      

SYMBOLGEN:  Macro variable DATASET resolves to snf_nmrc2540_96_2004_long
MPRINT(LOOP):   proc freq order=freq data=library.snf_nmrc2540_96_2004_long;
MPRINT(LOOP):   title "Ordered by freq" ;
MPRINT(LOOP):   tables wksht_cd clmn_num ;
NOTE: There were 8045845 observations read from the data set LIBRARY.SNF_NMRC2540_96_2004_LONG.
NOTE: The PROCEDURE FREQ printed pages 2486-2491.
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_2004_long
MPRINT(LOOP):   proc sort data=library.snf_nmrc2540_96_2004_long;
MPRINT(LOOP):   by wksht_cd;
NOTE: There were 8045845 observations read from the data set LIBRARY.SNF_NMRC2540_96_2004_LONG.
NOTE: The data set LIBRARY.SNF_NMRC2540_96_2004_LONG has 8045845 observations and 5 variables.
24 The SAS System                                                                                     11:49 Monday, October 24, 2016

NOTE: PROCEDURE SORT used (Total process time):
      real time           2.43 seconds
      cpu time            2.06 seconds
      

SYMBOLGEN:  Macro variable DATASET resolves to snf_nmrc2540_96_2004_long
MPRINT(LOOP):   proc freq data=library.snf_nmrc2540_96_2004_long;
MPRINT(LOOP):   title "";
MPRINT(LOOP):   tables line_num;
MPRINT(LOOP):   by wksht_cd;
NOTE: There were 8045845 observations read from the data set LIBRARY.SNF_NMRC2540_96_2004_LONG.
NOTE: The PROCEDURE FREQ printed pages 2492-2623.
NOTE: PROCEDURE FREQ used (Total process time):
      real time           0.67 seconds
      cpu time            0.65 seconds
      

SYMBOLGEN:  Macro variable DATASET resolves to snf_nmrc2540_96_2004_long
MPRINT(LOOP):   proc freq data=library.snf_nmrc2540_96_2004_long;
MPRINT(LOOP):   tables clmn_num;
MPRINT(LOOP):   by wksht_cd;
NOTE: There were 8045845 observations read from the data set LIBRARY.SNF_NMRC2540_96_2004_LONG.
NOTE: The PROCEDURE FREQ printed pages 2624-2743.
NOTE: PROCEDURE FREQ used (Total process time):
      real time           0.46 seconds
      cpu time            0.46 seconds
      

SYMBOLGEN:  Macro variable DATASET resolves to snf_nmrc2540_96_2004_long
SYMBOLGEN:  Macro variable YEAR resolves to 2004
MPRINT(LOOP):   proc sort data=library.snf_nmrc2540_96_2004_long nodupkey out=library.uniq_nmrc_2004;
MPRINT(LOOP):   by wksht_cd line_num clmn_num ;
MLOGIC(LOOP):  %DO loop index variable YEAR is now 2005; loop will iterate again.

NOTE: There were 8045845 observations read from the data set LIBRARY.SNF_NMRC2540_96_2004_LONG.
NOTE: 8034172 observations with duplicate key values were deleted.
NOTE: The data set LIBRARY.UNIQ_NMRC_2004 has 11673 observations and 5 variables.
NOTE: PROCEDURE SORT used (Total process time):
      real time           2.04 seconds
      cpu time            2.47 seconds
      

SYMBOLGEN:  Macro variable YEAR resolves to 2005
MPRINT(LOOP):   proc printto log ="/homes/data/hcris/2540-96/read_snf_rpt_nmrc2005.log" new;