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.
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.