[Error] Failed to transcode data from U_UTF8_CE to U_LATIN2_CE encoding because it contained charact

Gieorgie — Tue, 05 Oct 2021 10:54:03 GMT

the problem is that I have this table with this date format, while in another table I have this date format. How to change to execute this command. Because then he gets such an error

	CASE 
		      WHEN ((DATA_ZAP)-(DATA_SPR))<90 THEN '1: 0 – 3 m'

Error: Integration Technologies nie przekazało kodu do wykonania. [Error] Failed to transcode data from U_UTF8_CE to U_LATIN2_CE 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 that they can accommodate the data that you want to process. A portion of the source string, in hex representation is:
[None] 7fd24403eda4: 3b 2a 27 3b 2a 22 3b 2a 2f 3b 71 75 69 74 3b 72 |;*';*";*/;quit;r|
[None] 7fd24403edb4: 75 6e 3b 0d 0a 4f 50 54 49 4f 4e 53 20 50 41 47 |un;..OPTIONS PAG|
[Error] Some code points did not transcode.

Re: [Error] Failed to transcode data from U_UTF8_CE to U_LATIN2_CE encoding because it contained cha

ChrisNZ — Wed, 06 Oct 2021 08:23:31 GMT

1) The message has nothing to do with dates. Some UTF8 characters cannot be represented in WLATIN encoding.

2) It looks like DATA_ZAP is a datetime. Use the function DATEPART() to extract the date.

when datepart(DATA_ZAP) - DATA_SPR < 90 then

topic [Error] Failed to transcode data from U_UTF8_CE to U_LATIN2_CE encoding because it contained charact in SAS Programming

[Error] Failed to transcode data from U_UTF8_CE to U_LATIN2_CE encoding because it contained charact

Re: [Error] Failed to transcode data from U_UTF8_CE to U_LATIN2_CE encoding because it contained cha