And I ran into something similar a while back where we had proxy accounts set up and SAS folks couldn’t get the syntax right. What ended up working was exactly the format you wrote, but the trick was making sure the Oracle client on their machine was updated and using the right TNS. Once that was fixed, the proxy clause passed through fine. It felt a bit like setting up Infatica once for data pulls, looked a bit complicated at first but worked smoothly once the connection details were right.
... View more