topic Re: Read SAS log in current program in SAS studio in SAS Studio

Read SAS log in current program in SAS studio

Rushikeshvm — Fri, 30 Mar 2018 07:22:31 GMT

Hi All,

I am working on SAS Studio and I have an issue.

I wish to create a SAS macro that will read the SAS log of the current program and check it for any issues. I have gone through various papers but all of them refer to the external file saved as *.log.

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

Thanks,

Rhushikesh

Re: Read SAS log in current program in SAS studio

Kurt_Bremser — Fri, 30 Mar 2018 07:51:14 GMT

None. But you can check the automatic macro variables &syscc, &syserr and so on.

Alternatively, you could configure the workspace server logging so that a more expanded logfile is written on the server, and read that. But that requires write permissions for the SAS configuration and in-depth knowledge for the changes in logconfig.xml. Or the cooperation of your SAS admin.

Re: Read SAS log in current program in SAS studio

Shmuel — Fri, 30 Mar 2018 07:53:05 GMT

1) You can save the log of any part of your program or the whole log using PROC PRINTTO.

Start with proc printto log=<path and filename>; run;

Close the log with: rproc printto; run;

then read the file and check it using text functions like: scan, index, find etc.

2) You can check, instream the program or by special step, are there any errors by

checking system macro variables: &sysrc, &syserr - and some more (check in SAS documentation).

Re: Read SAS log in current program in SAS studio

Kurt_Bremser — Fri, 30 Mar 2018 08:49:17 GMT

The problem with the proc printto approach is that it redirects all log output, so you don't get it in the log window of SAS Studio.

Re: Read SAS log in current program in SAS studio

Rushikeshvm — Fri, 30 Mar 2018 11:51:11 GMT

Thank you very much for your inputs. So, we don't have a procedure to extract the log of the current program.

Re: Read SAS log in current program in SAS studio

Rushikeshvm — Fri, 30 Mar 2018 11:51:57 GMT

Thank You,

But I am looking for a way to read the log of the current program the time it executes.

Re: Read SAS log in current program in SAS studio

Kurt_Bremser — Fri, 30 Mar 2018 12:01:32 GMT

EG and SAS Studio check the log for ERRORs and WARNINGs by themselves, alerting you with a small red x or a yellow exclamation mark.

Inspecting the log and making sense of it (for all other NOTEs and messages) is still a job for us humans. Especially during development; once a job runs in production batch mode, checking the log automatically for certain phrases does make sense.

Re: Read SAS log in current program in SAS studio

VDD — Sat, 03 Nov 2018 11:34:39 GMT

@Rushikeshvmif you happen to find a nice way to read extremely long SAS log into SAS datasets let the rest of know. I have been working with the same request and mining for words is a real pain. I have ran into issue with memory overflow, and those tailored process that do seem to work at time don't always work on other log layouts,