topic Re: Using dm statement to save log, how to replace old log automatically without dialog box? in SAS Programming

Using dm statement to save log, how to replace old log automatically without dialog box?

Wolverine — Mon, 06 Mar 2023 18:38:44 GMT

I'm using the following code to save the log after running my program. The problem is that, if the log file already exists from a previous run, a dialog box pops up and asked if I want to Replace, Append, or Cancel. I want it to replace by default. This code runs without error, but the 'replace' command doesn't seem to do anything.

dm log 'file "P:\logs\ReportPrint..log"' replace;run;

Also, I know that I can use proc printto to save the log, but I prefer the dm statement so I can watch the log update in SAS as it runs.

Re: Using dm statement to save log, how to replace old log automatically without dialog box?

Reeza — Mon, 06 Mar 2023 18:48:53 GMT

May not be a valid solution if running interactively, but ALTLOG is also a useful option to be aware of.

Re: Using dm statement to save log, how to replace old log automatically without dialog box?

Quentin — Mon, 06 Mar 2023 18:58:52 GMT

My code looks like:

 dm "log; file ""%sysfunc(pathname(work))/__mylog.log"" replace;";

So I quote the command, and there is a semicolon to separate the log command from the file command, and I also quote the path. So based on that, you could try:

dm 'log; file "P:\logs\ReportPrint.log" replace;' ;

It usually takes me some tinkering with the quotes etc, but should be doable.

Re: Using dm statement to save log, how to replace old log automatically without dialog box?

Wolverine — Mon, 06 Mar 2023 19:06:18 GMT

That works, thanks!