topic Re: read the English character into SAS but shown as Chinese character in SAS Programming

read the English character into SAS but shown as Chinese character

Alexxxxxxx — Thu, 07 Oct 2021 14:45:59 GMT

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.

Re: read the English character into SAS but shown as Chinese character

Tom — Thu, 07 Oct 2021 14:48:30 GMT

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.

Re: read the English character into SAS but shown as Chinese character

Ksharp — Thu, 07 Oct 2021 15:11:21 GMT

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 .

Re: read the English character into SAS but shown as Chinese character

Alexxxxxxx — Fri, 08 Oct 2021 10:20:40 GMT

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-UTF-8-in-SAS-Enterprise/td-p/597234

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