Is there anyway to hide just the connection string in the log?
connect to oracle (user=XXX password=XXX path=XXX);
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!
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.