topic Re: Read french accents in Excel using utf-8 encoding in SAS Programming

Read french accents in Excel using utf-8 encoding

jonasc — Mon, 12 Feb 2018 14:09:22 GMT

Hello

When I try to import an Excel file with French accents I'm always getting the following: D�c�s result as output. This problem is caused on a linux server with UTF-8 encoding. I'm using SAS 9.4.

proc import datafile=temp
out=work.test
dbms=xls replace ;
sheet="sheetname";
getnames=yes ;
run;

Can someone help me?

Thank you in advance.

Re: Read french accents in Excel using utf-8 encoding

ChrisNZ — Tue, 13 Feb 2018 02:09:01 GMT

Show us the FILENAME statement.

Did you try using the ENCODING= option in the FILENAME statement?

Show us the result of
proc options group=languagecontrol; run;

Re: Read french accents in Excel using utf-8 encoding

jonasc — Tue, 13 Feb 2018 06:42:51 GMT

Issue found: we currently use utf-8 single byte which doesn't allow us to use special characters. In order to display the special charters we have to use double byte utf-8.

Thank you for your response.

Re: Read french accents in Excel using utf-8 encoding

Satish_Parida — Tue, 13 Feb 2018 07:54:06 GMT

We had this issue of not resolving Swedish Special Characters while reading it from a Oracle Database.

We changed the value of nsl_lang parameter in windows and it worked like a charm.