As the first step in the decommissioning of sasCommunity.org the site has been converted to read-only mode.


Here are some tips for How to share your SAS knowledge with your professional network.


Tips:Protect your database connection passwords using PROC PWENCODE

From sasCommunity
Jump to: navigation, search

Instead of hard-coding passwords where others may be able to see them, encrypt your passwords with PROC PWENCODE. Run the following:

proc pwencode in="password";
run;

The log will output an encrypted string like {SAS002}DA9A0A5C20629B7F34D2C88A165E5530 which you can use in a LIBNAME statement instead of a password in plaintext.

For more information, and options for encryption methods, see Leonid Batkhan's SAS blog post, via the link below.

....see also

Submitted By paulkaefer (talk)