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

[LL5]

Hi Quentin, thanks for this alternative and creative solution. I have noncontiguous ranges but this approach would be helpful to other work situation. Thanks again. 

[Quentin]

I guess for noncontiguous you could try a hack like:

data inv_sept ; 
  set sale."sale_sept$A:C"n;  /*Read cols A-C*/
  set sale."sale_sept$E:F"n;  /*Read cols E-F*/ 
run;

[Tom]

Talk to whoever in your company is responsible for setting up SAS.  It is their job to enable you to be able to run SAS with the settings you need. 

• If you are running SAS from the command line then they can create a different command (or add an option to the existing command) to launch SAS with proper encoding. 
• If you are using SAS/Studio or Enterprise Guide or other method to connect to a SAS session running on an application server then they can create a separate connection for you to use to launch a SAS session using the encoding you need. 
• If you are using Windows and launching SAS from the desktop then they can make "icons" that appear in your Start menu to launch SAS using the encoding you need.

[LL5]

Thanks Tom. The SAS programs are ran in batch under Unix, so it may not help even I update my SAS E.G session. I informed the SAS administrator about the warning message, it just seems there might be no way to fix this issue by simply updating the SAS code. But all the information I collected here are helpful for me to understand the reason. 

[Tom]

---

@LL5 wrote:

Thanks Tom. The SAS programs are ran in batch under Unix, so it may not help even I update my SAS E.G session. I informed the SAS administrator about the warning message, it just seems there might be no way to fix this issue by simply updating the SAS code. But all the information I collected here are helpful for me to understand the reason. 

---

So currently you are running a command like this:

sas myprogram

So either have them make a new command you can use or add an option to the existing command so that you can instead using a command like one of these.

sas_u8 myprogram
sas -u8 myprogram

[LL5]

Thanks Tom again for all the advice.