topic Re: Stop FORMAT from printing values to LOG in SAS Procedures

Stop FORMAT from printing values to LOG

SusieQ324 — Wed, 16 Feb 2011 18:31:27 GMT

Anyone know how to shut this off? I'm using a %include for a proc format statement coming from a vendor and the output is quite large as it prints the value of the entire format statement to the log. Anyway to shut this off?

Re: Stop FORMAT from printing values to LOG

RickM — Wed, 16 Feb 2011 18:36:59 GMT

You could do

ods listing close;
%include...
ods listing;

ods exclude=ALL is another option.

*Never mind, I was thinking of the output window, not the log.

Message was edited by: RickM

Try using

proc printo log="file.log";run
%include
proc printto;run; Message was edited by: RickM

Re: Stop FORMAT from printing values to LOG

Tim_SAS — Wed, 16 Feb 2011 18:49:21 GMT

Try the NOSOURCE2 option.

[pre]
SOURCE2 | NOSOURCE2
specifies whether SAS writes secondary source statements from files included by %INCLUDE statements to the SAS log.
[/pre]

Re: Stop FORMAT from printing values to LOG

SusieQ324 — Wed, 16 Feb 2011 18:52:19 GMT

Thanks Tim. How is this handled if it's embedded within a Macro. Looks like when I have MPRINT turned on, it'll still print. Anyway around that as well?

Re: Stop FORMAT from printing values to LOG

sbb — Wed, 16 Feb 2011 19:13:18 GMT

What's unclear here is whether there is a SOURCE2 coded explicitly on the %INCLUDE within your "vendor-supplied macro" - I suspect that it is?

You can use a SAS macro "statement" (old-style, some call SAS 79 style), as shown below:

MACRO SOURCE2 NOSOURCE2 %

This will cause SAS to change the code string SOURCE2 to NOSOURCE2.

Scott Barry
SBBWorks, Inc.

Re: Stop FORMAT from printing values to LOG

SusieQ324 — Wed, 16 Feb 2011 19:26:09 GMT

Thanks Scott. I checked the macro and it's strictly VALUE statements...no options set, so it must be a default of my system. The code you suggest didn't work for me so I'll just have to live with it in the debug process and then make sure it's turned off for other usage.

If anyone has other suggestions, I'd appreciate it.

Re: Stop FORMAT from printing values to LOG

sbb — Wed, 16 Feb 2011 19:48:14 GMT

The code statement is the %INCLUDE, not the specific PROC FORMAT. If you have access to the actual PROC or DATA step code-piece, you can always insert this statement:

OPTIONS NOSOURCE NOSOURCE2;

More information is needed to explain the SAS programming technique used, such as whether a MACRO is defined or open SAS code? Try the OPTIONS above - you will want to verify that there is no other OPTIONS statement being invoked within the vendor code.

Scott Barry
SBBWorks, Inc.