topic Suppress fluff in sas stored process log in Developers

Suppress fluff in sas stored process log

Criptic — Mon, 26 Feb 2018 10:20:44 GMT

Hello everybody,

so this isn't a problem just a question that would make the life easier.

When executing a STP in the log I get to so see a list of all the macro variables that are available to the STP via autoexecs etc. Is there a way to suppress that in the log? 99% of the time it is just fluff that the users scroll through to get to the actual log notes they are interessted in.

NOTE: SAS Initialization used (Total process time):
      real time           0.01 seconds
      cpu time            0.00 seconds
      
NOTE: The autoexec file, /path/SASMain/StoredProcessServer/autoexec.sas, was executed at server initialization.

>>> SAS Macro Variables:

... <- Long list of variables

Any help would be greatly appreciated

Thank you for your time and kind regards

Criptic

Re: Suppress fluff in sas stored process log

Vince_SAS — Tue, 06 Mar 2018 18:47:20 GMT

The list of macro variables cannot be suppressed, but we could consider adding this feature in a future release.

Would adding a _SUPPRESS_MVARS=true parameter to a stored process be sufficient? That allows you to handle stored processes on a case-by-case basis. Or do you need to suppress the list for all stored processes?

Vince DelGobbo

SAS R&D

Re: Suppress fluff in sas stored process log

Criptic — Wed, 07 Mar 2018 05:38:38 GMT

Thanks for the reply.

A parameter to handle it on a case by case basis would be completly sufficient.

Re: Suppress fluff in sas stored process log

Criptic — Thu, 15 Nov 2018 07:07:09 GMT

As a quick solution for anybody still needing a fix right now for this if you specifie a macro-variable with the prefix _nolog_ it will not be shown in the log - of course then you also have to call it with &_nolog_YOURNAME but it helps - see here for more in depth explanation: http://support.sas.com/rnd/itech/doc9/dev_guide/stprocess/input.html

Re: Suppress fluff in sas stored process log

Vince_SAS — Thu, 15 Nov 2018 13:09:27 GMT

I should have mentioned _NOLOG_, but I didn't think that it was a good, general purpose solution. That feature is often used to prevent displaying sensitive data in the log, but if it fits your needs, then use it.

As a result of this thread, we have added the _SUPPRESS_MVARS parameter to SAS 9.4M6.

Vince DelGobbo

SAS R&D

Re: Suppress fluff in sas stored process log

Criptic — Thu, 15 Nov 2018 13:14:09 GMT

That is great to hear.

Yeah I'm using it for one mv but I thought I should mention it.

Has there been a release date announced for M6?

Re: Suppress fluff in sas stored process log

Vince_SAS — Thu, 15 Nov 2018 14:30:43 GMT

SAS 9.4M6 should be available at the end of November 2018.

Vince DelGobbo

SAS R&D