Hello,
I have the following issue. I have a data set that contains some Chinese text. The data set is encoded in latin1, on a Linux system
Encoding latin1 Western (ISO)
I am trying to print some of these text fields that have Chinese text to an excel file using ODS EXCEL.
ods excel file="/project/Chinese_text.xlsx" style=sansPrinter;
proc print data=project_data noobs label;
var id chinese_text other_text;
run;
ods excel close;
The Excel file has rubbish for the chinese_text column. The other columns are correct and the encoding of the excel file is 'utf8'.
I would appreciate any suggestions anyone has in resolving this issue.
Thanks,
That's an interesting question...I would suggest contacting tech support on this one since this forum may not have a lot of people who deal with this issue mainly because it's English based.
I think you would not get any problem, if your sas encoding is 'utf-8' or 'euc-cn' .
' .
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.