read special characters from excel - SAS Support Communities

Calcite | Level 5

Calcite | Level 5

read special characters from excel

Posted 05-12-2021 08:35 AM (1020 views)

Dears,

I have a text variable in excel which contains the symbol "≥".

how can i read it in SAS?

thans and kind regrads,

Barbara

2 REPLIES 2

Super User

Super User

Re: read special characters from excel

Posted 05-12-2021 01:41 PM (978 views) | In reply to COMPAREMISSING

Make sure your SAS session uses UTF-8 encoding.

Maxims of Maximally Efficient SAS Programmers
How to convert datasets to data steps
The macro for direct download as ZIP
How to post code
Please vote for Provide Sequential Search Capability for Hash Objects
How to deal with locked files on UNIX

Rhodochrosite | Level 12

Rhodochrosite | Level 12

Re: read special characters from excel

Posted 05-13-2021 08:11 AM (939 views) | In reply to COMPAREMISSING

It's unclear to me if this was successful. But -- if you haven't read this thread. It certainly is related to this.

https://communities.sas.com/t5/SAS-Programming/Import-xls-file-using-encoding-UTF-8/td-p/598659

April 27 – 30 | Gaylord Texan | Grapevine, Texas

Registration is open

Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!

Call for Content EXTENDED

Still thinking about your presentation idea? The submission deadline has been extended to Friday, Nov. 14, at 11:59 p.m. ET.

Submit your proposal!