Removing Unwanted Characters

[iSAS]

I'm getting a special character when creating a dataset from SQL server. Instead of a multi-lined description, it's having an output of "š" symbol.

How to translate this appropriately from the source? I can use the compress function but by using it I am removing that character instead of translating it properly.

Hoping you could help me guys.

Example Data from Source:

First Paragraph

Second Paragraph

Output:

First Paragraph š

Second Paragraph š

[andreas_lds]

Could be a problem cause by mismatching encoding. Please verify that sas-session and database use the same encoding.

[iSAS]

Thank you for the response. How to check the encoding settings in SAS?

[ChrisNZ]

Try 

%put &=SYSENCODING;

[ChrisNZ]

> How to translate this appropriately from the source? I can use the compress function but by using it I am removing that character instead of translating it properly.

Maybe use translate function ?