BookmarkSubscribeRSS Feed
gzr2mz39
Quartz | Level 8

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.

 

2 REPLIES 2
Patrick
Opal | Level 21

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
gzr2mz39
Quartz | Level 8

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

hackathon24-white-horiz.png

The 2025 SAS Hackathon has begun!

It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.

Latest Updates

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 2 replies
  • 1551 views
  • 0 likes
  • 2 in conversation