Hi everybody! I'm using EG 6.1
I have the following problem with csv import: In CSV file some columns contain russian text. When I choose english language in EG properties, the import process is OK but the output looks like in the picture:
When I choose russian language in EG properties, the import is not processed and i get the following error:
How can I get the correct data? I've tried lots of ways that I've found in google and on this Forum but nothing was helpful(
Thanks in advance!!!
You're get this error when the text in the file contains characters that cannot be mapped to the SAS session encoding. Your SAS session might be running in wlatin or latin1 -- or some other encoding that cannot handle the mix of characters.
The best approach is to run SAS with ENCODING of UTF8. To do that, the SAS command would need to change to reference the ../nls/u8/sasv9.cfg file as the configuration. In a centralized SAS environment, you'll have to coordinate that with a SAS administrator and potentially any colleagues who use the same SAS environment. But if national characters are a common requirement, that's the proper thing to do.
Another way is changing encoding of CSV file before importing it : filename x 'c:\temp\x.csv' encoding='utf-8'; proc import ..............
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.