topic Re: how to mask percents in encrypted passwords in SAS Programming

how to mask percents in encrypted passwords

vicky07 — Fri, 24 Feb 2017 00:43:26 GMT

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");

Re: how to mask percents in encrypted passwords

ChrisNZ — Fri, 24 Feb 2017 01:54:57 GMT

try password="%superq(orcpwd)"

Re: how to mask percents in encrypted passwords

vicky07 — Sat, 25 Feb 2017 00:15:45 GMT

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!

Re: how to mask percents in encrypted passwords

ChrisNZ — Sat, 25 Feb 2017 05:44:33 GMT

Not too sure what else to tell you until you provide an example that we can reproduce.