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

SYMBOLGEN:  Macro variable YEAR resolves to 2008
MPRINT(LOOP):   proc printto print="/homes/data/hcris/1984-99/read_hospc_rpt_rollup2008.lst" new;
SYMBOLGEN:  Macro variable YEAR resolves to 2008
MPRINT(LOOP):   FILENAME datafile "/homes/data/hcris/1984-99/HOSPC_2008_ROLLUP.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 2008
SYMBOLGEN:  Macro variable DATASET resolves to library.hospc_rollup1984_99_2008

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

MPRINT(LOOP):   data library.hospc_rollup1984_99_2008;
MPRINT(LOOP):   *Using a length of 4 bytes retains 6 significant digits;
MPRINT(LOOP):   *max date is around 16000, do length of 4 should be fine for dates;
MPRINT(LOOP):   LENGTH rpt_rec_num 5 label $30;
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 label $ item ;
MPRINT(LOOP):   LABEL rpt_rec_num= "Report Record Number" ;

NOTE: The infile DATAFILE is:
      Filename=/homes/data/hcris/1984-99/HOSPC_2008_ROLLUP.CSV,
      Owner Name=jroth,Group Name=web,
      Access Permission=-rw-r--r--,
      Last Modified=16Jan2016:09:16:06,
      File Size (bytes)=0

NOTE: 0 records were read from the infile DATAFILE.
NOTE: The data set LIBRARY.HOSPC_ROLLUP1984_99_2008 has 0 observations and 3 variables.
NOTE: DATA statement used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds
      

SYMBOLGEN:  Macro variable DATASET resolves to library.hospc_rollup1984_99_2008
MPRINT(LOOP):   proc sort data=library.hospc_rollup1984_99_2008;
MPRINT(LOOP):   by rpt_rec_num;
NOTE: Input data set is empty.
NOTE: The data set LIBRARY.HOSPC_ROLLUP1984_99_2008 has 0 observations and 3 variables.
NOTE: PROCEDURE SORT used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds
      

18 The SAS System                                                                                       11:27 Tuesday, April 5, 2016

SYMBOLGEN:  Macro variable DATASET resolves to library.hospc_rollup1984_99_2008
SYMBOLGEN:  Macro variable DATASET resolves to library.hospc_rollup1984_99_2008
MPRINT(LOOP):   proc transpose data=library.hospc_rollup1984_99_2008 out=library.hospc_rollup1984_99_2008 (drop=_NAME_ 
sortedby=rpt_rec_num);
MPRINT(LOOP):   by rpt_rec_num;
MPRINT(LOOP):   var item;
MPRINT(LOOP):   id label;
MPRINT(LOOP):   run;

NOTE: There were 0 observations read from the data set LIBRARY.HOSPC_ROLLUP1984_99_2008.
NOTE: The data set LIBRARY.HOSPC_ROLLUP1984_99_2008 has 1 observations and 1 variables.
NOTE: PROCEDURE TRANSPOSE used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds
      

SYMBOLGEN:  Macro variable DATASET resolves to library.hospc_rollup1984_99_2008
MPRINT(LOOP):   proc print DATA=library.hospc_rollup1984_99_2008 (obs=5);
NOTE: There were 1 observations read from the data set LIBRARY.HOSPC_ROLLUP1984_99_2008.
NOTE: The PROCEDURE PRINT printed page 19.
NOTE: PROCEDURE PRINT used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds
      

SYMBOLGEN:  Macro variable DATASET resolves to library.hospc_rollup1984_99_2008
MPRINT(LOOP):   proc contents DATA=library.hospc_rollup1984_99_2008;
MLOGIC(LOOP):  %DO loop index variable YEAR is now 2009; loop will iterate again.

NOTE: The PROCEDURE CONTENTS printed page 20.
NOTE: PROCEDURE CONTENTS used (Total process time):
      real time           0.00 seconds
      cpu time            0.01 seconds
      

SYMBOLGEN:  Macro variable YEAR resolves to 2009
MPRINT(LOOP):   proc printto log ="/homes/data/hcris/1984-99/read_hospc_rpt_rollup2009.log" new;