topic Re: Encoded password in SAS Programming

Encoded password

JuanBedoya — Tue, 27 Oct 2009 14:16:54 GMT

Hi everyone.

I have a table protected with a password. Created with this sentence:

data sasuser.passtab (password=prueba);
format MACHINE PORT USER PWD $15.;
MACHINE='arriero'; PORT='8561'; USER='sasadm'; PWD='sasdesa'; output; run;

I need to access this table with the password encrypted. Then I encrypted this password with the next sentence:

proc pwencode in=prueba out=pwfile;
run;

And that returns me the value: {sas001}cHJ1ZWJh

But when I try to match the table's password and the encrypted password, it doesn't work. Send to me this message:

ERROR: The value specified for the PASSWORD option is too long.

What can I do? We need to solve this issue as soon as possible.

Thank you for your help.

Juan Bedoya
Consultor SAS Colombia

Re: Encoded password

deleted_user — Tue, 27 Oct 2009 16:30:54 GMT

Juan -
In the same way you had to quote the password in the pwencode submission:
proc pwencode in="prueba"...
You must also quote the password when used.

This works for 9.2 and later versions. It was not in place for 9.1 (or anything
pre-9.2).

Doing this:
proc print data=sasuser.passtab(password="{sas001}cHJ1ZWJh"); run;

will work at 9.2.
best wishes,
Nancy

Re: Encoded password

darrylovia — Tue, 27 Oct 2009 16:32:11 GMT

Make sure that the {sas001}cHJ1ZWJh is wrapped in quotes

data one;
set sasuser.passtab(password='{sas001}cHJ1ZWJh');
run;

D