SAS连接MySQL数据库-经管之家官网！

考虑到日后要把运算任务转到linux平台下，把数据库改成了MySQL，发现Windows下SAS连接的时候并不像sqlserver那么方便，要先做些设置才能顺利连接到MySQL数据库，下面把步骤分享出来：未设置前出错，SAS版本9.3 TS1M2：

1. ERROR: The SAS/ACCESS Interface to MYSQL cannot be loaded. The libmysql code appendage could not be
   
2. loaded.
   
3. ERROR: Error in the LIBNAME statement.

复制代码ps：一开始还以为是没有安装的SAS没有mysql连接组件
1.下载安装MySQL. http://www.mysql.com/
2.修改环境变量path.增加路径C:\Program Files\MySQL\MySQL Server 5.6\lib，路径下面应该包含 libmysql.dll
3.重启电脑，测试

1. 1 libname mysqllib mysql user='mysql' password=XXXXX database=sas
   
2. 2 server='192.168.1.150' port=3306;
   
3. NOTE: Libref MYSQLLIB was successfully assigned as follows:
   
4. Engine: MYSQL
   
5. Physical Name: 192.168.1.150
   
6. 3 proc sql;
   
7. 4 connect to mysql as dbcon
   
8. 5 (user=mysql password=XXXXX server='192.168.1.150'
   
9. 6 database=sas port=3306);
   
10. 7 quit;
    
11. NOTE: PROCEDURE SQL used (Total process time):
    
12. real time 0.26 seconds
    
13. cpu time 0.01 seconds

复制代码参考：http://stackoverflow.com/questions/16913921/sas-mysql-libname-connection-issue
linux sas连接MySQL应该也需要设置环境变量。尚在测试中。。