Looking a suggestion on this as I have tried about everything. I am trying to write a generic DB connection where the user passes their ID by macro variable the code posted verifies the visibility of the macro but when used in the connect string, it is not recognized. Code snippet %let USER_LDAP = %unquote(%bquote(')500000@LDAP%bquote(')); %let connect_str = CONNECT TO teradata (user= &USER_LDAP password="%bquote(&)server_dbpass" tdpid = edtdp.XX.com mode=teradata); %put &connect_str; /* print out the string to ensure macro USER_LDAP is valid */ PROC SQL; CONNECT TO teradata (user= &USER_LDAP password="&server_dbpass" tdpid = edtdp.XX.com mode=teradata); create table output as select * from connection to teradata ( &server_sql_statement ); ENDRSUBMIT; Corresponding Log output CONNECT TO teradata (user= '500000@LDAP' password="&server_dbpass" tdpid = edtdp.XX.com mode=teradata) 2 CONNECT TO teradata (user= &USER_LDAP password=XXXXXXXXXX tdpid = edtdp.XX.com mode=teradata); WARNING: Apparent symbolic reference USER_LDAP not resolved.
... View more