DATA Step, Macro, Functions and more


New Contributor
Posts: 3




I am looking for a code that will list errors, warnings, and notes at first page of the log. Here is an example I copied from sas training practice exercise.


Errors, Warnings, Notes

> Errors (2)

> Warnings (5)

> Notes (7)



I appreciate your help.



Posts: 1,460

Re: Programming

Posted in reply to Krishna123
I'm not quite sure what you mean? Do you mean you are looking for a log scanner (a program that will read in a log file and parse it, counting the number of errors/warnings/notes found)?
Valued Guide
Posts: 863

Re: Programming

Posted in reply to Krishna123

What you are describing sounds like the log summary in Enterprise Guide.  If you have the new version go to 'view' and select 'log summary'.  It is a new feature and will not be available with older versions.

Super User
Super User
Posts: 9,599

Re: Programming

Posted in reply to Steelers_In_DC

However, as this is posted in Base SAS section and not Enterprise Guide, its safe to assume she wants someone to provide the code for a logchecker.  Unfortunately this isn't a question, its is more a work order.  I have develope several of these in different languages and they boil down to a few simple steps:

- Read the text file in.

- Keep a variable which counts occurences of ERROR, WARNING, NOTE.  And the line number of each in the text file.

- Report the above out.


How you do that is really up to you.  I would also note that the those three sections may not capture everything you want to look at however, my logchecks pick out a number of other strings which I would want to look at, so I pick out errors and warnings, and then search for particulars, for instance uninitialised.

Super User
Posts: 23,724

Re: Programming

Posted in reply to Krishna123
That actually looks like SAS Studio/SAS UE. I think the OP should clarify the requirements.
SAS Employee
Posts: 24

Re: Programming

Posted in reply to Krishna123


If you are running BASE SAS you can use the logic in the code below to create a data set that will contain the message of all errors found in your SAS log. The proc printto creates a copy of the log in the file specified by log=, then the data step reads that log file. You will need to create counters for errors, warnings and notes that are found in the log file. I suggest you use the end= option on the set statement and output only during the last iteration of the data step. This way your data set will just have the final value of your counter variables.


If you want the counters at the beginning of the log file you will need to use a data _null_ step, read the log file and write out to the file when _n_=1, the final value of your counters.


I hope this will help you get started.



proc printto log='c:\1test\mylog.txt' new;
data test;
input x1 x2 x3;
cards /*no semicolon*/
1 2 3
4 5 6
proc print;
proc printto log=log;
data logtest;
infile 'c:\1test\mylog.txt' truncover;
input test $5. @;
if test='ERROR' then do;
input @6 msg $76.;
proc print data=logtest;

Ask a Question
Discussion stats
  • 5 replies
  • 6 in conversation