https://communities.sas.com/t5/SAS-Programming/remove-unwanted-characters/m-p/754016#M237710 <P>Looks like an encoding problem, three options to solve it:</P> <OL> <LI>change the encoding of you sas session</LI> <LI>at the encoding-option to the infile-statement when reading the file</LI> <LI>change the encoding of the file before it is read</LI> </OL> Wed, 14 Jul 2021 09:40:08 GMT andreas_lds 2021-07-14T09:40:08Z https://communities.sas.com/t5/SAS-Programming/remove-unwanted-characters/m-p/754007#M237706 <P>Hi please can anybody suggest how to remove this unwanted character .</P> <P>&nbsp;</P> <P>Thanks .</P> <P>&nbsp;</P> <P>&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="dennis_oz_0-1626250318414.png" style="width: 400px;"><img src="https://communities.sas.com/t5/image/serverpage/image-id/61238iDFEC3C53B746B273/image-size/medium?v=v2&amp;px=400" role="button" title="dennis_oz_0-1626250318414.png" alt="dennis_oz_0-1626250318414.png" /></span></P> <P>&nbsp;</P> Wed, 14 Jul 2021 08:12:38 GMT https://communities.sas.com/t5/SAS-Programming/remove-unwanted-characters/m-p/754007#M237706 dennis_oz 2021-07-14T08:12:38Z https://communities.sas.com/t5/SAS-Programming/remove-unwanted-characters/m-p/754008#M237707 <P>Use the COMPRESS function with your unwanted character as second argument.</P> Wed, 14 Jul 2021 08:28:05 GMT https://communities.sas.com/t5/SAS-Programming/remove-unwanted-characters/m-p/754008#M237707 Kurt_Bremser 2021-07-14T08:28:05Z https://communities.sas.com/t5/SAS-Programming/remove-unwanted-characters/m-p/754011#M237708 <P>&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="dennis_oz_0-1626252426398.png" style="width: 400px;"><img src="https://communities.sas.com/t5/image/serverpage/image-id/61239i595C046EAC61326D/image-size/medium?v=v2&amp;px=400" role="button" title="dennis_oz_0-1626252426398.png" alt="dennis_oz_0-1626252426398.png" /></span></P> <P>&nbsp;</P> <P>Hi please see the attached data .</P> <P>&nbsp;</P> <P>there is a UTF-8&nbsp; code&nbsp; i.e x96 . tis needs to be replaced with&nbsp; "-"&nbsp;</P> <P>&nbsp;</P> <P>so o/p should be&nbsp; "Idameneo - Robina"</P> Wed, 14 Jul 2021 08:52:58 GMT https://communities.sas.com/t5/SAS-Programming/remove-unwanted-characters/m-p/754011#M237708 dennis_oz 2021-07-14T08:52:58Z https://communities.sas.com/t5/SAS-Programming/remove-unwanted-characters/m-p/754015#M237709 <P>Hi&nbsp;<a href="https://communities.sas.com/t5/user/viewprofilepage/user-id/19264">@dennis_oz</a>&nbsp;</P> <P>&nbsp;</P> <P>Try translate('-','96'x)</P> Wed, 14 Jul 2021 09:39:19 GMT https://communities.sas.com/t5/SAS-Programming/remove-unwanted-characters/m-p/754015#M237709 ErikLund_Jensen 2021-07-14T09:39:19Z https://communities.sas.com/t5/SAS-Programming/remove-unwanted-characters/m-p/754016#M237710 <P>Looks like an encoding problem, three options to solve it:</P> <OL> <LI>change the encoding of you sas session</LI> <LI>at the encoding-option to the infile-statement when reading the file</LI> <LI>change the encoding of the file before it is read</LI> </OL> Wed, 14 Jul 2021 09:40:08 GMT https://communities.sas.com/t5/SAS-Programming/remove-unwanted-characters/m-p/754016#M237710 andreas_lds 2021-07-14T09:40:08Z https://communities.sas.com/t5/SAS-Programming/remove-unwanted-characters/m-p/754030#M237720 <P>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.</P> Wed, 14 Jul 2021 10:32:00 GMT https://communities.sas.com/t5/SAS-Programming/remove-unwanted-characters/m-p/754030#M237720 Kurt_Bremser 2021-07-14T10:32:00Z https://communities.sas.com/t5/SAS-Programming/remove-unwanted-characters/m-p/754032#M237722 Thank you sooo much !!! Wed, 14 Jul 2021 10:55:33 GMT https://communities.sas.com/t5/SAS-Programming/remove-unwanted-characters/m-p/754032#M237722 dennis_oz 2021-07-14T10:55:33Z