2 weeks ago - last edited 2 weeks ago
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%
2 weeks ago
Take a look at this message to see if the solution helps you:
Import data from MS access/Excel while retaining special characters
The SAS server used by Enterprise Guide must be started with Unicode support.
2 weeks ago
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.