topic Re: Eroor Code: Transcode data from utf16le to wlatin1 issue in SAS Enterprise Guide

Eroor Code: Transcode data from utf16le to wlatin1 issue

SASnewbie2 — Thu, 18 Feb 2021 02:58:08 GMT

Hi All,

I received following error on my SAS program after I executed my program. Does anyone encounter error below and how you solve it.

Error : Failed to transcode data from utf-16le to wlatin1 encoding because it contained characters which are not supported by your sas session encoding. Please review your encoding=and locale=SAS System options to ensure they can accomodate the data that you want to process.

Re: Eroor Code: Transcode data from utf16le to wlatin1 issue

SASnewbie2 — Thu, 18 Feb 2021 03:04:17 GMT

Re: Eroor Code: Transcode data from utf16le to wlatin1 issue

qoit — Thu, 18 Feb 2021 03:53:40 GMT

You could either:

1. Use the COMPRESS functions to take out all the abnormalities:

compress(Variable_Name," '0D'x'0A'x",'kw')

2. Try use the data statement encoding option:

data want (encoding = 'utf-8');

set have;

run;

Re: Error Code: Transcode data from utf16le to wlatin1 issue

SASnewbie2 — Thu, 18 Feb 2021 04:43:19 GMT

Hi Qoit,

Thanks for your advice

I encountered the error when i run the following coding, which I believe the causes was from the "where" function but there'are too many names and I have no idea what are the abnormalities that causes the error.

I'd like to filter more than 10,000 name from my dataset. below are part of the filter names

data work.table1
set WORK.QUERY_FOR_RESULTS_0000;
WHERE
(UPCASE(Name) LIKE '% HOLDING%' or
UPCASE(Name) LIKE '%ZUTALANT%' or
UPCASE(Name) LIKE '%ZURIAT W É%' or
UPCASE(Name) LIKE '%ZURAH VENTURES%' or
UPCASE(Name) LIKE '%ZURAH PREMIER%' or
UPCASE(Name) LIKE '%ZURAH PERMAI%' or
UPCASE(Name LIKE '%ZURAH IMPIAN%' or
UPCASE(Name) LIKE '%ZURAH ABADI%' );

run;

Re: Error Code: Transcode data from utf16le to wlatin1 issue

qoit — Thu, 18 Feb 2021 04:47:33 GMT

Are you able to use the compress function to filter out unnecessary characters and then use the WHERE clause?

data want;
set have;
format name_ $1000. (rename=(name = name_));
name = compress(name_," '0D'x'0A'x",'kw');
drop name_;
run;

And now run your DATA Step.

Re: Eroor Code: Transcode data from utf16le to wlatin1 issue

andreas_lds — Thu, 18 Feb 2021 06:45:10 GMT

Imho this is not a data-problem, but caused by chars in your program that are not compatible with the encoding of the sas session.

Re: Eroor Code: Transcode data from utf16le to wlatin1 issue

Ksharp — Thu, 18 Feb 2021 11:23:11 GMT

If it was a text file ,try option encoding=

filename x 'c:\tem\xx.csv' encoding='utf-16le';

Re: Eroor Code: Transcode data from utf16le to wlatin1 issue

Sajid01 — Thu, 04 Mar 2021 19:13:24 GMT

If possible copy your code to notepad and then copy back to SAS Eg in a new program window and try

Re: Eroor Code: Transcode data from utf16le to wlatin1 issue

Tom — Thu, 04 Mar 2021 19:23:37 GMT

@SASnewbie2 wrote:

Hi All,

I received following error on my SAS program after I executed my program. Does anyone encounter error below and how you solve it.

Error : Failed to transcode data from utf-16le to wlatin1 encoding because it contained characters which are not supported by your sas session encoding. Please review your encoding=and locale=SAS System options to ensure they can accomodate the data that you want to process.

If you want to work with that data you need to run SAS in a session that is using a non-single byte encodings. With only a single byte encoding WLATIN1 there are only 256 possible characters that can be represented and the one it is complaining about is not one of them.

How are you running the program now? Are you running from a command line? Clicking on something? Using SAS/Studio or Enterprise Guide or other user interface that allows you to run SAS code. Check with your local SAS support about how to run SAS with unicode support in your environment.