DATA Step, Macro, Functions and more

SQL: Some character data was lost during transcoding

Reply
Regular Contributor
Posts: 204

SQL: Some character data was lost during transcoding

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.

 

Respected Advisor
Posts: 4,668

Re: SQL: Some character data was lost during transcoding

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
Regular Contributor
Posts: 204

Re: SQL: Some character data was lost during transcoding

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

Ask a Question
Discussion stats
  • 2 replies
  • 109 views
  • 0 likes
  • 2 in conversation