deleting different elements from a text

[ilikesas]

hi,

suppose I have the following table:

text
The generalized general idea
Hon. member
some text

In every cell, whenever they are present, I would like to delete the following elements: 'The' , 'general' , 'Hon.' .

So the table becomes the following:

text
generalized idea
member
text

Thank you!

[ballardw]

https://communities.sas.com/thread/76418 is a similar thread, you may get some ideas.

[slchen · Accepted solution]

data have;

input text $50.;

cards;

The generalized general idea

Hon. member

some text

;

run;

data want;

   set have;

   _text=prxchange('s/Hon.|some|the|general\b//i',-1,text);

run;