{'fraction_non_alphanumeric': 0.008350730688935281, 'fraction_numerical': 0.0, 'mean_word_length': 4.641176470588236, 'pattern_counts': {'":': 0, '<': 0, '<?xml version=': 0, '>': 0, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
Encoding the Password A low maintenance way to secure your data access

When users access data in a remote database through the SAS® application, the valid database user ID and password are required. One method for granting user access is to create a login ID for each user in each database. Doing so requires the maintenance of the login ID for each user on each remote database and is subject to the risk of exposing the user passwords in the SAS programs. This paper is going to present a simple solution to overcome the security concerns by using the Application Login ID for accessing databases. Then we encode the Application Password by using the PROC PWENCODE procedure. By implementing the Application Login ID on the database and encoding the Application Password in the SAS program we can eliminate the maintenance of individual user login accounts on the databases and disguise the passwords from to be revealed as clear text in the SAS programs.