data loss warning

[bharath86]

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:......

[Tom]

What encoding is your SAS session using?

Check the value of the automatic macro variable SYSENCODING.

[bharath86]

Hi Its,

UTF-8