topic data loss warning in SAS Programming

data loss warning

bharath86 — Mon, 23 Aug 2021 16:47:06 GMT

options validvarname=any;
libname xl XLSX "book1.xlsx";
data test;
set xl.xyz;
run;
libname xl clear;

@Kurt_Bremser

I get this error when I run the above program, how can I make sure it reads the complete string irrespective of length. I have a string upto 300 characters in a variable.

also attached a test file for the code.

WARNING: Some character data was lost during transcoding in column:......

Re: data loss warning

Tom — Mon, 23 Aug 2021 17:30:24 GMT

What encoding is your SAS session using?

Check the value of the automatic macro variable SYSENCODING.

Re: data loss warning

bharath86 — Mon, 23 Aug 2021 19:39:43 GMT

Hi Its,

UTF-8