iRoss2007 发表于 2014-12-26 17:22
只需在connect语句的最后加一句“ DBCONINIT=”即可。具体理由可以看help
proc sql;
connect to mysq ...
您好,我用SAS9.3连接Linux上的Mysql,用ODBC和mysql引擎的方式都是乱码呢,请问是怎么回事啊,跪求帮忙解决下,万分感谢!
方法1:libname cqt_sas odbc datasrc=CQT_DB user=root password=root;
方法2:
libname cqt_db mysql user='root' password=:123 database=BusiManage
server='105.24.0.224' port=3306 inencoding=utf8;
方法3:
proc sql;
connect to mysql as msnews
(user=root password=123 server='105.24.0.224'
database=BusiManage port=3306
DBCONINIT='set names utf8');
create table test as
select * from connection to msnews
(select * from D_CLB_HD limit 100);
quit;