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 ..............
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!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.
Select SAS Training centers are offering in-person courses. View upcoming courses for: