The SAS session your Enterprise Guide front end tool is connected to is using a single byte encoding (LATIN1). So there are only 2**8 = 256 possible characters that can be represented. The data you are reading is using a flexible-byte encoding (UTF-8) that can represent millions of characters. At least one of the characters in your data does not exist in set of 256 characters that the LATIN1 supports.
The solution is to change the SAS session that your Enterprise Guide project is using to one that is running "SAS with unicode support". Basically a SAS session that is using UTF-8 as the encoding. Now you can read data that is using UTF-8 encode or data that is using LATIN1 since any character that is in LATIN1 can be mapped to a character in UTF-8.
The SAS session your Enterprise Guide front end tool is connected to is using a single byte encoding (LATIN1). So there are only 2**8 = 256 possible characters that can be represented. The data you are reading is using a flexible-byte encoding (UTF-8) that can represent millions of characters. At least one of the characters in your data does not exist in set of 256 characters that the LATIN1 supports.
The solution is to change the SAS session that your Enterprise Guide project is using to one that is running "SAS with unicode support". Basically a SAS session that is using UTF-8 as the encoding. Now you can read data that is using UTF-8 encode or data that is using LATIN1 since any character that is in LATIN1 can be mapped to a character in UTF-8.
SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!
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.
Ready to level-up your skills? Choose your own adventure.