topic Re: SAS version of find and replace ? in SAS Procedures

SAS version of find and replace ?

GreggB — Thu, 15 Dec 2016 17:57:09 GMT

I'm helping a coworker combine and clean 84 csv files. I have imported them and combined them into one SAS data set. For some reason, her csv files have some odd-looking characters in place of apostrophes, quotes and in a few cases, the letter 'e'.

Here's a list of what I have vs what I want. The var in question is desc.

â€™ should become '

Ã© should be e

Ã¨ should be e

â€œ should be "

â€ should also be "

â€¢ I want to delete (suppress?) it

â€“ and â€” delete (suppress?) them.

Re: SAS version of find and replace ?

Reeza — Thu, 15 Dec 2016 18:52:46 GMT

TRANSLATE -> Find/Replace

COMPRESS() -> Remove entirely

Re: SAS version of find and replace ?

GreggB — Thu, 15 Dec 2016 20:20:31 GMT

Can you show me the difference between TRANSLATE and TRANWRD? I read about it but can't see the distinction.

Re: SAS version of find and replace ?

Reeza — Thu, 15 Dec 2016 20:23:16 GMT

TRANSLATE is for single characters

TRANWRD is for words or sets of characters