Desktop productivity for business analysts and programmers

Importing Less than equal and greater than equal into SAS EG

Reply
New User
Posts: 1

Importing Less than equal and greater than equal into SAS EG

[ Edited ]

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%

SAS Super FREQ
Posts: 305

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

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

Super User
Super User
Posts: 7,076

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

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.

 

 

Ask a Question
Discussion stats
  • 2 replies
  • 139 views
  • 0 likes
  • 3 in conversation