SAS and MySQL connection method

August 11, 2012 SAS 9.1.3 version with MySQL connection test, can connect with database
1 direct connectivity via ODBC pass through
Connect to ODBC
CREATE TABLE (or view)

2 through Access
Access connects to MySQL using the access connection ODBC,ODBC, even if you do not have permission to use MySQL directly. It also enables SAS to interact with MySQL.

Script examples
Libname mydblib ODBC noprompt= "UID=TESTUSER;PWD=TESTPASS;DSN=SQLSERVR;" Proc Print data=mydblib.customers; Run

Or
Libname mydblib ODBC dsn=as400 uid=testuser
Pwd=testpass;

Proc Print data=mydblib.customers;
where state= ' CA ';
Run

After the Mydblib is established, it can be performed in SAS and the actual modified data is in MySQL.

SAS and MySQL connection method