Use the encoded password to access a DBMS. You must use double quotation marks (" ") so that the macro variable resolves properly.


libname x odbc dsn=SQLServer user=testuser password="&dbpass";