MSSQL-ODBC-SAS

/* Assign the library named MSSQL to the ODBC data source               *
 * the library sample will contain the tables of the database           */

LIBNAME MSSQL ODBC DATASRC=MSSQL UID=XX PASSWORD='{sas002}XXXXXXXXXXXX';

LIBNAME MSSQL ODBC NOPROMPT="UID=XX;PWD=XXXXXX;DSN=MSSQL;SERVER=XXX.XX.XX.XX;DATABASE=XXXXX;";

/* Use a 32 bit key to encode 'yourpassword' */
PROC PWENCODE IN='yourpassword' METHOD=SAS002;
run;