transcoding

Batman — Tue, 17 Mar 2026 19:47:54 GMT

I'm getting this error in SAS EG

27 proc sql;
28 create table Only_P as
29 select *
30 from DAT.UPDATED_DIRECTORY (obs=&obs)
31 where RecType='P';
NOTE: Data file DAT.UPDATED_DIRECTORY.DATA is in a format that is native to
another host, or the file encoding does not match the session encoding.
Cross Environment Data Access will be used, which might require
additional CPU resources and might reduce performance.
ERROR: Some character data was lost during transcoding in the dataset
DAT.UPDATED_DIRECTORY. Either the data contains characters that are not
representable in the new encoding or truncation occurred during
transcoding.

Re: transcoding

A_Kh — Tue, 17 Mar 2026 21:09:50 GMT

Did you try dataset option ENCODING= ANY?

Re: transcoding

Ksharp — Wed, 18 Mar 2026 06:31:05 GMT

That issue is due to the encoding of "DAT.UPDATED_DIRECTORY" is different with SAS encoding.
Make SAS encoding be same with your dataset.

You could use the following code to check your dataset encoding:
proc contents data=DAT.UPDATED_DIRECTORY;
run;

topic Re: transcoding in SAS Programming

transcoding

Re: transcoding

Re: transcoding