BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
clairep
Calcite | Level 5
Completing SAS ENTERPRISE GUIDE: 1 querying and reporting (8.2) lessons on getting started. demo: Navigating the SAS Enterprise Guide Environment. When i try to characterize the data from the lesson i am getting this error message: “FAILED TO TRANSCODE DATA FROM U_UTF8_CE TO U_LATIN9_CE ENCODING BECAUSE IT CONTAINED CHARACTERS WHICH ARE NOT SUPPORTED BY YOUR SAS SESSION ENCODING”
What does this mean and how can i fix?? Thanks
1 ACCEPTED SOLUTION

Accepted Solutions
Tom
Super User Tom
Super User

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.

View solution in original post

2 REPLIES 2
Tom
Super User Tom
Super User

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.

clairep
Calcite | Level 5
Hi Tom, thanks for responding. How do I do this? Thanks

SAS Innovate 2025: Save the Date

 SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!

Save the date!

SAS Enterprise Guide vs. SAS Studio

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 2 replies
  • 2649 views
  • 1 like
  • 2 in conversation