Hide Connection String in Log

deleted_user — Fri, 10 Jul 2009 22:25:37 GMT

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

Re: Hide Connection String in Log

sbb — Sun, 12 Jul 2009 14:51:11 GMT

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.

topic Re: Hide Connection String in Log in Microsoft Integration with SAS

Hide Connection String in Log

Re: Hide Connection String in Log