topic Re: Removing Unwanted Characters in SAS Programming

Removing Unwanted Characters

iSAS — Wed, 07 Aug 2019 10:50:07 GMT

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 š

Re: Removing Unwanted Characters

andreas_lds — Wed, 07 Aug 2019 11:03:43 GMT

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

Re: Removing Unwanted Characters

iSAS — Mon, 02 Sep 2019 14:37:55 GMT

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

Re: Removing Unwanted Characters

ChrisNZ — Tue, 03 Sep 2019 03:25:38 GMT

Try

%put &=SYSENCODING;

Re: Removing Unwanted Characters

ChrisNZ — Tue, 03 Sep 2019 03:27:23 GMT

> 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 ?