BookmarkSubscribeRSS Feed
deleted_user
Not applicable
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
1 REPLY 1
sbb
Lapis Lazuli | Level 10 sbb
Lapis Lazuli | Level 10
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.

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

Discussion stats
  • 1 reply
  • 637 views
  • 0 likes
  • 2 in conversation