Can't read some uncommon/special Chinese word from excel

[Jack2012]

Dear All, 

Just facing a terrible issue when I try to reading from an simple external Excel file, and found there is Warning(figure1) and the problomatic result(figure2). 

The sas session is EUC-CN, I am hunting for the solution, please let me know if you have, and I would be highly appreciated. 

SAS CODE:

filename x "D:\sas code\encodingIssue\test.xlsx" encoding="utf-8";

proc import datafile=x out=test dbms=xlsx replace;getnames=yes;run;

[SASKiwi]

I suggest you try the XLSX and EXCEL LIBNAMEs and see what your spreadsheet looks like in VIEWTABLE:

libname x XLSX "D:\sas code\encodingIssue\test.xlsx" encoding="utf-8";

libname x EXCEL "D:\sas code\encodingIssue\test.xlsx" encoding="utf-8";

[Jack2012]

ERROR: Libref X is not assigned. ERROR: Error in the LIBNAME statement. ERROR 22-7: Invalid option name ENCODING. Thank you, but both snippet have above error.

[ballardw]

See if UTF-16 helps.

Note: search this forum for Excel and Import data problems.

If you are likely to have more than one file with the same data structure in the long run saving XLSX to a CSV format and reading that with a data step is much more consistent.

[SASKiwi]

Did you try without the ENCODING option? If not please try without that.

[RD2]

You need using SAS (Unicode Support) to run your code.