DATA Step, Macro, Functions and more

Unable to transcode data to/from UCS-2 encoding

Reply
Contributor
Posts: 28

Unable to transcode data to/from UCS-2 encoding

Hi All,

 

I am using proc append to insert records in a sql server table where the database collation is  "Latin1_General_Bin2"

and sas session encoding type is wlatin1 but I am getting the below error:

 

Error : Unable to transcode data to/from UCS-2 encoding.

 

However, I changed the sas session encoding to UTF-8 but still faced the same issue.

 

Seek guidance to solve the issue.

 

Thanks in advance.

Ask a Question
Discussion stats
  • 0 replies
  • 65 views
  • 0 likes
  • 1 in conversation