topic Re: Summarise SAS Log for Errors, Warnings and Notes in SAS Programming

Summarise SAS Log for Errors, Warnings and Notes

dkanand86 — Thu, 17 Dec 2015 19:45:26 GMT

Hi Everyone,

I would like to summarise the usual SAS LOG into more meaningful way, to identify quickly SAS log errors, warnings and notes.

Please suggest ways of achieving this output.

Regards

Re: Summarise SAS Log for Errors, Warnings and Notes

JoshB — Thu, 17 Dec 2015 19:58:46 GMT

1. Use PROC PRINTTO to route the log to a file.

2. Use data step to read in that log file keeping the lines you're interested in

Quick example

/* route the log */
PROC PRINTTO LOG="directory/file.log' NEW;
RUN;

/* run all your regular sas code to generate the log */

/* return log to default */
PROC PRINTTO LOG=LOG;
RUN;

/* read in the generated log file and keep what you want to see */
data processed_log;
  length line $1000;
  infile "directory/file.log";
  input;

  logfile = "directory/file.log";
  line_num = _n_;
  line = _infile_;
  issue = 0;
  
  if index(upcase(line),"ERROR") > 0 then do;
    issue = 1;
    output;
  end;
run;

I would treat that as pseudocode, but it should be flexible to fit your need. You can look for errors, warnings, notes, etc. with similar logic. Good luck.

Re: Summarise SAS Log for Errors, Warnings and Notes

Reeza — Thu, 17 Dec 2015 19:58:58 GMT

GOOGLE SAS LOG PARSER to find several macro's that parse the log.

Re: Summarise SAS Log for Errors, Warnings and Notes

dkanand86 — Thu, 17 Dec 2015 20:30:23 GMT

Re: Summarise SAS Log for Errors, Warnings and Notes

SASKiwi — Fri, 18 Dec 2015 23:55:22 GMT

Both SAS Enterprise Guide and SAS Studio do that without any extra coding.

These SAS clients work with either local PC SAS or remote SAS servers.