BookmarkSubscribeRSS Feed
Sandhya55
Obsidian | Level 7

Im getting below error while extracting metadata from sas management console.

ERROR: Some character data was lost during transcoding in the dataset YYYY.PERSON. Either the data contains characters that are not representable in the new encoding or truncation occurred during transcoding.

3 REPLIES 3
gwootton
SAS Super FREQ
This means you are trying to write special characters to a dataset with encoding that doesn't support it. Since it has no way to represent that character it throws an error. For example if you have in a user's display name in Metadata a character that only exists in UTF-8 and you try to write that value to a LATIN1 dataset, this error would occur.
--
Greg Wootton | Principal Systems Technical Support Engineer
Sandhya55
Obsidian | Level 7

how to identify if the data extracted from metadata is latin1 or utf-8 or any other encoding ..currently we have set the current session to run in utf-8 

gwootton
SAS Super FREQ
If your session is running in UTF-8 then perhaps the dataset YYYY.PERSON already exists and is not a UTF-8 dataset? Perhaps you could create a new one? Depending on how you are pulling information from Metadata you could use the regular expression [^\x00-\x7F] to find characters outside the ASCII range.
--
Greg Wootton | Principal Systems Technical Support Engineer

suga badge.PNGThe SAS Users Group for Administrators (SUGA) is open to all SAS administrators and architects who install, update, manage or maintain a SAS deployment. 

Join SUGA 

Get Started with SAS Information Catalog in SAS Viya

SAS technical trainer Erin Winters shows you how to explore assets, create new data discovery agents, schedule data discovery agents, and much more.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 3 replies
  • 1041 views
  • 0 likes
  • 2 in conversation