Hide Connection String in Log

[deleted_user]

Is there anyway to hide just the connection string in the log?
PROC SQL;
connect to oracle (user=XXX password=XXX path=XXX);
etc....

Reason being is that I don't want the id or the password writing to anything.

I tried the proc printto;run; function but that seems to move the output to another file and does not allow me to place it before and after just the connection string, instead I have to put it around the entire code to create the dataset.

Any help would be greatly appreciated!
Thanks,
Michelle

[sbb]

I don't expect you will find a complete solution (only password info will be masked as can be expected), so as an alternative, consider using OPTIONS command NONOTES / NOTES to turn off / on SAS code/notes logging, and for effect, follow the "conection command / code" with a simple DATA step and a PUT / PUTLOG statement echoing to the SAS log that some code has been suppressed.

Scott Barry
SBBWorks, Inc.