topic Re: What are the functions to repalce words but not substrings in a character string? in SAS Data Science

What are the functions to repalce words but not substrings in a character string?

devarayalu — Tue, 03 Jul 2012 12:42:54 GMT

Examples please

Re: What are the functions to repalce words but not substrings in a character string?

Linlin — Tue, 03 Jul 2012 13:01:37 GMT

data have;
string='I love dog, i have a lovely dog';

data want;
set have;
s=tranwrd(string,' love ',' like ');
proc print;run;
obs string s

1 I love dog, i have a lovely dog I like dog, i have a lovely dog

Re: What are the functions to repalce words but not substrings in a character string?

devarayalu — Tue, 03 Jul 2012 13:08:09 GMT

Check with the following example it is repacing substrings not only words. I want only word replacement.

1 data _null_;

3 x= 'For the Format';

5 y= tranwrd(x, 'For', 'A');

7 Put y=;

9 run;

y=A the Amat

NOTE: DATA statement used (Total process time):

real time 0.25 seconds

cpu time 0.04 seconds

Re: What are the functions to repalce words but not substrings in a character string?

Linlin — Tue, 03 Jul 2012 13:15:56 GMT

94   data _null_;
95
96
97
98       x= 'For the Format';
99
100
101
102      y= tranwrd(x, ' For ', ' A ');
103      y= tranwrd(x, 'For ', 'A ');
104
105
106
107      Put y=;
108
109   run;

y=A the Format
NOTE: DATA statement used (Total process time):
real time 0.01 seconds
cpu time 0.01 seconds

Re: What are the functions to repalce words but not substrings in a character string?

Alpay — Tue, 03 Jul 2012 13:20:09 GMT

Your words may be at the beginning/end of a sentence, preceeded/followed by periods/commas/exclamation marks, etc.

\b: word boubdary

ABC: Search string

xyz: Replace string

data have;

string = 'ABC abcde dabc abc abc, abc.';

new_string = PRXCHANGE("s/\bABC\b/xyz/i",-1,string);

put (_all_)(=);

run;

string=ABC abcde dabc abc abc, abc. new_string=xyz abcde dabc xyz xyz, xyz.

Re: What are the functions to repalce words but not substrings in a character string?

PGStats — Tue, 03 Jul 2012 14:46:47 GMT

Yes, regular expressions do the job! You may improve efficiency by adding the suffix 'o' at the end of the pattern so that it is compiled only once. - PG

Re: What are the functions to repalce words but not substrings in a character string?

Linlin — Tue, 03 Jul 2012 15:08:07 GMT

Hi PG,

Would you please recommend some materials for me to learn about regular expressions?

Thanks - Linlin

Re: What are the functions to repalce words but not substrings in a character string?

PGStats — Tue, 03 Jul 2012 15:27:43 GMT

Hi Linlin. I'm no expert in regular expressions, I have to get back to the documentation every time I use them! They are omnipresent in the Unix world. Since regular expressions are now present in so many programming environments, there are tons of material out there, Try searching

"regular expressions" tutorial

in Google. Pick something that matches (no pun) your learning style.

Good luck.

Re: What are the functions to repalce words but not substrings in a character string?

Linlin — Tue, 03 Jul 2012 15:35:25 GMT

Thank you! I will do as you suggested. - Linlin

Re: What are the functions to repalce words but not substrings in a character string?

Alpay — Tue, 03 Jul 2012 16:51:06 GMT

Hi PG,

Thanks for the tip. I will keep that in mind from now on.

Alpay

Re: What are the functions to repalce words but not substrings in a character string?

PGStats — Tue, 03 Jul 2012 18:40:58 GMT

I got it from , pass it on! - PG

Re: What are the functions to repalce words but not substrings in a character string?

Haikuo — Tue, 03 Jul 2012 19:24:16 GMT

Thanks, PG , Ksharp and Linlin. I am in the same boat with Linlin.

Haikuo

Re: What are the functions to repalce words but not substrings in a character string?

Linlin — Tue, 03 Jul 2012 19:49:48 GMT

I am honored to be in the same boat with you. Happy July 4th! - Linlin