topic Re: Importing Less than equal and greater than equal into SAS EG in SAS Enterprise Guide

Importing Less than equal and greater than equal into SAS EG

vdaher — Fri, 04 Aug 2017 21:47:35 GMT

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%

Re: Importing Less than equal and greater than equal into SAS EG

Vince_SAS — Sun, 06 Aug 2017 00:22:38 GMT

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-special/m-p/352237/highlight/true#M82077

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

Vince DelGobbo

SAS R&D

Re: Importing Less than equal and greater than equal into SAS EG

Tom — Sun, 06 Aug 2017 14:49:33 GMT

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.