topic Append data to MySQL with utf8 in SAS Programming

Append data to MySQL with utf8

SullivanC — Fri, 14 Sep 2018 16:56:00 GMT

I connect mysql(utf8 encoding) with libname

libname rdm mysql server=.....  dbconinit='set names gbk'

('set names utf8' fails but 'se names gbk' works when I appends data to MySQL)

I append data to MySQL tables(utf8)

There are errors about encoding when appending data.(There are other languages or '€' etc)

proc append base=rdm.wdj data=source.wdj force  force;
run;

he appending procedure stops whenever there is an error.

How do I skip the error data and keep appending the next data?

Re: Append data to MySQL with utf8

SuryaKiran — Fri, 14 Sep 2018 17:43:48 GMT

Check your SAS Session encoding.

proc options option=encoding;run;

Also check your dataset encoding,

/*Check your data set encoding*/
%let dsn=jliang1.group_info;
%let dsid=%sysfunc(open(&dsn,i));
%put &dsn ENCODING is:
%sysfunc(attrc(&dsid,encoding));
/*Or*/
proc contents data=jliang1.group_info;run;

What SAS Application are you using, EG or Base SAS? If Base SAS then open SAS UTF-8 application and run the code.

FYI.....http://support.sas.com/kb/51/586.html

Re: Append data to MySQL with utf8

SullivanC — Sat, 15 Sep 2018 10:51:01 GMT

Thanks.

I use EG to connect to MySQL(UTF8)

My dataset is euc-cn Simplified Chinese.

Can I change the dataset from euc-cn to UTF8?