Importing Less than equal and greater than equal into SAS EG

[vdaher]

I have a report that is formatted wide with special charater, *, ≥ and  ≤.  The asterik imports fine but not the ≥ and  ≤, these symbols get imported as a ?.

I need to import this file so I can transform the data from wide to long format using Transpose.  I have to do this every year for three different large files, so the the long format can be published for app developers.

Each instance is unique in that if its ≥95%, there will never be a 95% or a ≤95% etc. A global replace of ?95% with ≥95% would work, but TRANWRD does not like the ≥.

I have been doing the replace in Excell, but would like to find a code solution, since this will be an ongoing task.

Here are the fields that are having an issue and what they should be:

?95% to ≥95%

?5% to ≤5%

?98% to ≥98%

?2% to ≤2%

?99% to ≥99%

?1% to ≤1%

[Vince_SAS]

Take a look at this message to see if the solution helps you:

Import data from MS access/Excel while retaining special characters

https://communities.sas.com/t5/Base-SAS-Programming/Import-data-from-MS-access-Excel-while-retaining...

The SAS server used by Enterprise Guide must be started with Unicode support.

Vince DelGobbo

SAS R&D

[Tom]

Normal LATIN1 encoding does not have a single byte mapping for those glyphs.

Change SAS servers to one that is  using UTF8 encoding so that SAS can store those special characters.