Using SAS® to access remote database servers, such as Oracle®, DB2®, Teradata®, etc., usually requires your database userid and password. Many folks simply add this information into their SAS program, in clear text. Obviously, this is a bit of a security concern. The two primary reasons why people use this method are (1) That's what they know will work, and (2) Having SAS prompt for the password each time it's required often is not an acceptable alternative. This paper addresses a "quick and easy" way to implement a better means of keeping your password secure from someone else casually seeing it in your SAS code.
Keep your database passwords out of the clear: Quick and easy tips to protect yourself