topic Re: Find And Replace within a string in SAS Programming

Find And Replace within a string

deleted_user — Thu, 11 Sep 2008 10:02:11 GMT

Hi

I am trying to find a character within a string and replace it with something else, within the data step.
For eg.
My&Name&Is&Simon
Hello&World
Simon

I want to replace the & with a space.

I have tried a few of the macros available on here but they only seem to replace the first instance only.
Any ideas?

thanks
Simon

Re: Find And Replace within a string

yonib — Thu, 16 Mar 2017 12:33:59 GMT

You can use translate function.

For example:

data a;
 input x $40.;
 y=translate(x,' ','&');
cards;
My&Name&Is&Simon
Hello&World
Simon
;
run;

Result:

x                   y

My&Name&Is&Simon    My Name Is Simon
Hello&World         Hello World     
Simon               Simon

From @sbb: For more than one character in a sequence, use the TRANWRD function.

From @Patrick: And since it looks like you might be trying to decode URL strings, check out the URLDECODE function which handles your specific task.

data _null_;
 infile datalines truncover;
 input text $40.;
 text=translate(text,' ','&');
 text=urldecode(text);
 put text;
datalines;
My&Name&Is&Simon
Simon%27s&World
%27 - '
%28 - (
%29 - )
;

Output:

My Name Is Simon
Simon's World
' - '
( - (
) - )

Re: Find And Replace within a string

LinusH — Thu, 11 Sep 2008 10:23:19 GMT

textVar2=translate(textVar,' ','&');

/Linus

Re: Find And Replace within a string

deleted_user — Fri, 12 Sep 2008 11:25:46 GMT

Hi

Thanks for that...it works, but now have another problem....
My string also contains other things i wanted to replace, like
'%27' i want to replace with an apostrophe
so my original string is
Simon%27s&World

translate works at replacing the & but i tried
translate(translate(title,' ','&'),"%27","'")
but it still only replces the &
Help would be much appreciated.

Thanks

Re: Find And Replace within a string

deleted_user — Fri, 12 Sep 2008 11:27:09 GMT

in fact i have half a dozen replacements to do:
%27 - '
%28 - (
%29 - )
and a few others... any ideas?

thanks

Re: Find And Replace within a string

sbb — Fri, 12 Sep 2008 12:13:51 GMT

Use the TRANWRD function - similar to TRANSLATE.

Refer to SAS Language DOC at the link below:

Scott Barry
SBBWorks, Inc.

SAS 9.2 TRANWRD DOC:

http://support.sas.com/documentation/cdl/en/lrdict/59540/HTML/default/a000215027.htm

SAS 9.1 DOC:

http://support.sas.com/documentation/onlinedoc/91pdf/index.html

SAS DOC main page (choose your SAS component and version):

http://support.sas.com/documentation/index.html

Re: Find And Replace within a string

deleted_user — Fri, 12 Sep 2008 14:08:42 GMT

Perfect thanks!!

Re: Find And Replace within a string:

Patrick — Sat, 13 Sep 2008 08:08:28 GMT

Hi Simon

Looks like URL escape syntax.
Try this - it should also cover cases which might not yet be in your current data:

data _null_;
infile datalines truncover;
input text $40.;
text=translate(text,' ','&');
text=urldecode(text);
put text;
datalines;
My&Name&Is&Simon
Simon%27s&World
%27 - '
%28 - (
%29 - )
;

http://support.sas.com/onlinedoc/913/getDoc/en/lrdict.hlp/a001191534.htm

HTH
Patrick