topic Re: Password contains invalid option name ":" in SAS Procedures

Password contains invalid option name ":"

LAtwood — Fri, 11 Sep 2009 12:03:20 GMT

Hi,
While using the proc sql statement to connect the sas to oracle,it is needed to enter the user id and password.My question is the password contains the symbol ":" and I get the error "Invalid option name :" Is there any way to work around this?

eg: proc sql;
connect to oracle (user= password= path=);
quit;

Re: Password contains invalid option name ":"

Patrick — Sat, 12 Sep 2009 14:17:51 GMT

Isn't the password in quotes? So why should a column cause problems?

What you always can do is encoding your password.

proc pwencode in='mypw';
run;

And then copy from the log the encoded pw, i.e:

connect to oracle (user= password='{sas001}bXlwdw==' path=);

Re: Password contains invalid option name ":"

sbb — Sat, 12 Sep 2009 14:53:30 GMT

From your post, it is unclear whether you attempted entering the password in single-quotes? Also, it's always best to post the exact SAS log output (COPY/PASTE) with the error message and also the command syntax echoed in the log, rather than attempting some other example which may not be exact. With the specific log output and associated SAS messages (as generated), the feedback you receive from the forum subscribers may be more accurate, rather than making any presumption.

Scott Barry
SBBWorks, Inc.