transcoding

[Batman]

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.

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.

[A_Kh]

Did you try dataset option ENCODING= ANY?

[Ksharp · Accepted solution]

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;