remove unwanted characters

[dennis_oz]

Hi please can anybody suggest how to remove this unwanted character .

Thanks .

[Kurt_Bremser]

Use the COMPRESS function with your unwanted character as second argument.

[dennis_oz]

Hi please see the attached data .

there is a UTF-8  code  i.e x96 . tis needs to be replaced with  "-" 

so o/p should be  "Idameneo - Robina"

[ErikLund_Jensen · Accepted solution]

Hi @dennis_oz 

Try translate('-','96'x)

[dennis_oz]

Thank you sooo much !!!

[andreas_lds]

Looks like an encoding problem, three options to solve it:

1. change the encoding of you sas session
2. at the encoding-option to the infile-statement when reading the file
3. change the encoding of the file before it is read

[Kurt_Bremser]

Hex 96 is not UTF, it's a single-byte character in the Windows 1252 codepage, so a simple TRANSLATE should take care of it.