SAS Office Analytics, SAS Add-In for Microsoft Office, and other integrations

Hide Connection String in Log

Reply
N/A
Posts: 0

Hide Connection String in Log

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
Super Contributor
Super Contributor
Posts: 3,174

Re: Hide Connection String in Log

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.
Ask a Question
Discussion stats
  • 1 reply
  • 154 views
  • 0 likes
  • 2 in conversation