Community talk about communities.sas.com. Meta!

warning using libname to convert excel sheet to SAS dataset

Reply
New Contributor
Posts: 3

warning using libname to convert excel sheet to SAS dataset

I am trying to import an xlsx document with a cell containing a string that includes "greater than or equal to" ("") sign. I am getting the following note "WARNING: Some character data was lost during transcoding in column

Super User
Posts: 10,279

Re: warning using libname to convert excel sheet to SAS dataset

This is most probably caused by your SAS session not being configured for UTF encoding.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
How to convert datasets to data steps
How to post code
New Contributor
Posts: 3

Re: warning using libname to convert excel sheet to SAS dataset

Posted in reply to KurtBremser

what is UTF? how do I know it is configured for UTF encoding? do I need to add some options?

Super User
Posts: 10,279

Re: warning using libname to convert excel sheet to SAS dataset

For basic information about UTF, consult the relevant page on wikipedia.

For SAS and UTF, start here: http://www.sascommunity.org/planet/blog/category/encoding-system-option/

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
How to convert datasets to data steps
How to post code
Ask a Question
Discussion stats
  • 3 replies
  • 235 views
  • 0 likes
  • 2 in conversation