DATA Step, Macro, Functions and more

Summarise SAS Log for Errors, Warnings and Notes

Reply
Contributor
Posts: 52

Summarise SAS Log for Errors, Warnings and Notes

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

Contributor
Posts: 56

Re: Summarise SAS Log for Errors, Warnings and Notes

[ Edited ]
Posted in reply to dkanand86

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.

Super User
Posts: 19,833

Re: Summarise SAS Log for Errors, Warnings and Notes

Posted in reply to dkanand86
GOOGLE SAS LOG PARSER to find several macro's that parse the log.
Contributor
Posts: 52

Re: Summarise SAS Log for Errors, Warnings and Notes

ok

Super User
Posts: 3,256

Re: Summarise SAS Log for Errors, Warnings and Notes

[ Edited ]
Posted in reply to dkanand86

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. 

Ask a Question
Discussion stats
  • 4 replies
  • 245 views
  • 0 likes
  • 4 in conversation