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.
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
Yes, I still get the same error with that code.
April 27 – 30 | Gaylord Texan | Grapevine, Texas
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!
Still thinking about your presentation idea? The submission deadline has been extended to Friday, Nov. 14, at 11:59 p.m. ET.
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.
Ready to level-up your skills? Choose your own adventure.