topic SQL: Some character data was lost during transcoding in SAS Programming

SQL: Some character data was lost during transcoding

gzr2mz39 — Fri, 01 Jun 2018 22:25:53 GMT

This code runs without an error:

proc sql;
create table TZATDR(rename=(_BIC_ZTDR=start txtmd=label)) as
select *
from Eng.'/BIC/TZATDR'n
order by _BIC_ZTADR;
quit;
data TZATDR;
set TZATDR;
fmtname="$TZATDR";
run;

However, I receive an error (shown below) when I run the code below. How do I correct this error?

proc sql;
create table TZATDR(rename=(_BIC_ZTDR=start txtmd=label)) as
select *, "$TZATDR" as fmtname
from Eng.'/BIC/TZATDR'n
order by _BIC_ZTADR
;
quit;

ERROR: Some character data was lost during transcoding in the dataset Eng.'/BIC/TZATDR'n. Either the data contains
characters that are not representable in the new encoding or truncation occurred during transcoding.

Re: SQL: Some character data was lost during transcoding

Patrick — Sat, 02 Jun 2018 09:31:33 GMT

Just to test a theory: Do you still get the error if running below code version?

proc sql;
create table TZATDR(rename=(_BIC_ZTDR=start txtmd=label)) as
select *, "$TZATDR" as fmtname length=28
from Eng.'/BIC/TZATDR'n
order by _BIC_ZTADR
;
quit

Re: SQL: Some character data was lost during transcoding

gzr2mz39 — Mon, 04 Jun 2018 19:09:49 GMT

Yes, I still get the same error with that code.