0

How to hide the login credential in the SAS program to connect teradata database

user3762120
  • 256
  • 2
  • 12
  • How are you connecting? Using a libname, or ODBC passthrough? If ODBC then have you seen this: http://stackoverflow.com/questions/8157160/odbc-password-security-in-sas – Robert Penridge Aug 29 '14 at 17:31
  • 1
    THis is a nice overview: http://blogs.sas.com/content/sasdummy/2010/11/23/five-strategies-to-eliminate-passwords-from-your-sas-programs/ – Quentin Aug 31 '14 at 18:18

2 Answers2

1

If you are wanting to obscure your credentials in your code take a look at proc pwencode

Jay Corbett
  • 28,091
  • 21
  • 57
  • 74
0

You can use SAS wallets for this. Your credentials are then deployed on your Unix system and picked up as variables (UID & PWD) in SAS code. Check your SAS wallet generation utility.

whyhadtheworldturnedgrey
  • 1