read the English character into SAS but shown as Chinese character

[Alexxxxxxx]

hello all,

do you know why I read the English character into SAS but shown as Chinese character?

I use the following code,

proc import datafile = "G:\Raw_data\SIC_Code\SIC_CODE_LIST.xlsx"
OUT=SIC_CODE_LIST DBMS=XLSX replace;
Sheet='Sheet1';
RANGE='A1:A1421';
GETNAMES=YES;
RUN;

to read the following table,

des

Industry Group 011: Cash Grains

0111 Wheat

0112 Rice

0115 Corn

0116 Soybeans

0119 Cash Grains, Not Elsewhere Classified

Industry Group 013: Field Crops, Except Cash Grains

0131 Cotton

the result shows as below,

but when I click on the text, it is still English character.

Do you know why, and how could I fix it? I would appreciate it if you could give me some advice.

many thanks in advance.

[Tom · Accepted solution]

What encoding if your SAS session using?  Check the macro variable SYSENCODING.

What encoding is the XLSX file using?  I have no idea how to check that.

Can you save the XLSX file as a delimited text file instead?  Then you could set the encoding of the text file in the INFILE statement you use when reading the text into SAS.

[Ksharp]

As Tom pointed it out. It is encoding problem .
Try change your SAS encoding into UTF-8 .
Or Save it as a CSV file and import it with UTF-8 encoding in FILENAME .

[Alexxxxxxx]

just in case people face similar problems like me, please see the links below,
https://communities.sas.com/t5/Administration-and-Deployment/How-to-Change-Encoding-from-WLATIN1-to-...

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