Display additional information in the SAS® log from summary procedures


The Base SAS® procedures that use the summary object are MEANS, REPORT, SUMMARY, and TABULATE. To display additional information about these procedures in the SAS log, you can use the MSGLEVEL system option and the undocumented option SYSSUMTRACE.

Without these options, the basic information in the SAS log is shown below:

1    proc means data=sashelp.class;
2    run;

NOTE: There were 19 observations read from the data set SASHELP.CLASS.
NOTE: PROCEDURE MEANS used (Total process time):
      real time           0.09 seconds
      cpu time            0.04 seconds


The MSGLEVEL=I option includes additional information about threading in the SAS log:

4    options msglevel=i;
5    proc means data=sashelp.class;
6    run;

NOTE: Multiple concurrent threads will be used to summarize data.
NOTE: There were 19 observations read from the data set SASHELP.CLASS.
NOTE: PROCEDURE MEANS used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds


With the SYSSUMTRACE=5 option, details about the type of memory that the summary object is using are displayed in the SAS log:

8    %let syssumtrace=5;
9    proc means data=sashelp.class;
10   run;

NOTE: The internal buffer size was 512K bytes. The number of internal buffers allocated was 10.
NOTE: Multiple concurrent threads will be used to summarize data.
NOTE: Input data read is now complete.
NOTE: Start reordering the primary types.
NOTE: Reordering the primary types is now complete.
NOTE: Start building subtypes.
NOTE: Subtypes are now complete.
NOTE: The initial memory limit for classification tables was 1668978K bytes. Actual memory
      acquired was 0K bytes.
NOTE: There were 19 observations read from the data set SASHELP.CLASS.
NOTE: PROCEDURE MEANS used (Total process time):
      real time           0.01 seconds
      cpu time            0.01 seconds

 

The PROC MEANS statement supports the undocumented option TRACELEVEL. Including the TRACELEVEL=5 option displays the same information that the SYSSUMTRACE option provides. The TRACELEVEL option applies only to PROC MEANS, but the SYSSUMTRACE option applies to all procedures that use the summary object.