topic Re: Read SAS log in current program in SAS in SAS Programming

Read SAS log in current program in SAS

Zoe_Steven — Wed, 22 Jan 2020 03:06:02 GMT

Hi All,

I am working on checking the logs in SAS v9.4. There are many papers about check for issues from external files saved as *.log. But I'd like to read the SAS log of current program, and can't find any relevant papers.

What is the option or procedure to read the SAS log of my current program and check for the issues?

Thanks,

Zoe

Re: Read SAS log in current program in SAS

Reeza — Wed, 22 Jan 2020 04:12:39 GMT

Use PROC PRINTTO to push the log, current log, to a file and then you can read the log in as any other file.

Depending on what you're doing, PROC SCAPROC may be of use as well. You may also want to look into the automatic SAS macro variables that indicate different error types.

Re: Read SAS log in current program in SAS

SASKiwi — Wed, 22 Jan 2020 05:53:51 GMT

Your SAS log has to be written to a file stored on disk before it can be read by a SAS program. Whether you save it manually or use @Reeza 's suggestion to write it automatically using PROC PRINTO the end result is a file on disk.

Re: Read SAS log in current program in SAS

Zoe_Steven — Wed, 22 Jan 2020 06:28:24 GMT

Thank you so much, Reeza.

I just tried to use PROC PRINTTO, but it seems this statement would store the current logs in a external file, and the LOG tab of SAS would display nothing. what I expected is to keep the log message in the LOG tab of SAS, and read and check the log message and output the log summary in the LOG tab as well. For example, output the error and warning messages.

Re: Read SAS log in current program in SAS

SASKiwi — Wed, 22 Jan 2020 06:59:17 GMT

@Zoe_Steven - An alternative to PROC PRINTTO is the ALTLOG system option which creates a copy of the log in a file in addition to keeping the original log: https://documentation.sas.com/?docsetId=hostwin&docsetTarget=n02cl0iq0k1fmxn11p83yirplodk.htm&docsetVersion=9.4&locale=en

Re: Read SAS log in current program in SAS

Kurt_Bremser — Wed, 22 Jan 2020 08:34:33 GMT

@Zoe_Steven wrote:

. For example, output the error and warning messages.

But that is already done by EG in the log summary; you try to reinvent the wheel.

Re: Read SAS log in current program in SAS

Zoe_Steven — Wed, 22 Jan 2020 10:18:12 GMT

Many thanks, @SASKiwi .

I just found another way to output the current SAS log using DM statement.

dm 'log; file ".\xx.log" replace';

Re: Read SAS log in current program in SAS

Zoe_Steven — Wed, 22 Jan 2020 10:22:21 GMT

Thanks, @Kurt_Bremser , but I have to reinvent, since what we are using is not EG

Re: Read SAS log in current program in SAS

Kurt_Bremser — Wed, 22 Jan 2020 10:24:43 GMT

Yep, just saw that you use the Display Manager. That is rather rare nowadays 😉

Re: Read SAS log in current program in SAS

SASKiwi — Wed, 22 Jan 2020 18:59:18 GMT

@Zoe_Steven - Great, I was aware of that one too, although that only works in the SAS Windowing Environment. It won't work if you use SAS Enterprise Guide as your user interface.