Hello,
I have password that contains percent sign in it and its been encrypted. I am trying to use the encrypted password in a sql pass through connection and my connection was getting rejected. If I hard code the password it works fine. I wonder if the '%' sign in my password is throwing it off. Is there way to hide the percent sign in the sql connect statement? I can create a password without percent sign but just wondering if it's easy to fix it. I use PC sas version 9.3.
filename passfile "c:\pwd.txt";
data _null_;
infile passfile truncover;
input str:$20.;
call symputx('orcpwd',str);
run;
Proc sql;
connect to oracle(dsn=orcsql user=&userid password="&orcpwd");
try password="%superq(orcpwd)"
Chris - Thanks for your response. I tried the %superq but i didnt work. I wonder if the password need to be masked before I encrypt it. I assume the %superq function is actually trying to mask the encrypted string and not the actual password. I may be wrong.
Appreciate your time!
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.