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.