topic Re: How to show errors or warnings in Out screen but NOT only in log? in SAS Programming

How to show errors or warnings in Out screen but NOT only in log?

Irenech34 — Tue, 12 Sep 2017 16:54:32 GMT

Hello,

I would like to ask how to output the warning when data format is incorrect? The warning is to be printed in Out screen or Results Viewer Screen or a popped out window screen, not Log, because there are a lot of information shown in the Log.

My data(AA) looks like this:

ID birth Transfer

01 02/30/1997 .

02 05/23/1992 1992-05-23

I want to show the following information

_ERROR_=1 ; WARNING! INVALID DATE FOR SAS; data=AA, ID=01, birth=02/30/1997

Thanks for your help!

Re: How to show errors or warnings in Out screen but NOT only in log?

Reeza — Tue, 12 Sep 2017 16:56:33 GMT

Where exactly do you want this output?

In the Results Pane?

That'll be a manual process, whereas the log could be directed to a file instead?

Re: How to show errors or warnings in Out screen but NOT only in log?

Irenech34 — Wed, 13 Sep 2017 18:29:44 GMT

How about showing this in Results Viewer Screen?
I don't need the full log but just the error messege.
The warning information should be specific, and need to identify for which SAS dataset, for which record (row), for which variable (column), and the data with wrong date value.

Re: How to show errors or warnings in Out screen but NOT only in log?

error_prone — Wed, 13 Sep 2017 20:37:32 GMT

Afaik no automatism exists. The problem can be solved by maintainig a log-dataset and printing it at the end of the process/program. Have a look at log4sas - unfortunately the macros can only write to a file, but import + print are easy to code and you don't have to create the steps for appending to a log datasets yourself.

Re: How to show errors or warnings in Out screen but NOT only in log?

Reeza — Wed, 13 Sep 2017 21:08:49 GMT

The simplest approach - note the records via a flag and then use PROC PRINT to display the results to the log.

However, each check is manual so you will have to code this how you want it to look.

Re: How to show errors or warnings in Out screen but NOT only in log?

Irenech34 — Thu, 14 Sep 2017 13:41:34 GMT

Thank you all very much.

So you means to save the log then import again and using proc print to print what I want?

Re: How to show errors or warnings in Out screen but NOT only in log?

Reeza — Thu, 14 Sep 2017 14:41:55 GMT

@Irenech34 wrote:

Thank you all very much.

So you means to save the log then import again and using proc print to print what I want?

That's one approach.

Another is to save the errors in a data set themselves and then print that out.

The first approach only works if a SAS 'error' is the same as your error definition, which I don't think is true.