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.

sas-innovate-2026-white.png



April 27 – 30 | Gaylord Texan | Grapevine, Texas

Registration is open

Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!

Register now

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
  • 1594 views
  • 0 likes
  • 2 in conversation