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.
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;
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.
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.
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
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.