BookmarkSubscribeRSS Feed
vicky07
Quartz | Level 8

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

3 REPLIES 3
vicky07
Quartz | Level 8

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!

ChrisNZ
Tourmaline | Level 20
Not too sure what else to tell you until you provide an example that we can reproduce.

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

Register Now

How to Concatenate Values

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 3 replies
  • 1552 views
  • 0 likes
  • 2 in conversation