topic deleting different elements from a text in SAS Data Management

deleting different elements from a text

ilikesas — Fri, 15 May 2015 22:21:15 GMT

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:

Thank you!

ballardw — Fri, 15 May 2015 22:38:44 GMT

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

slchen — Fri, 15 May 2015 22:42:51 GMT

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;