topic Re: How to remove words in a column by another column values in SAS Studio

How to remove words in a column by another column values

fatihekici — Mon, 27 Sep 2021 10:21:47 GMT

let's assume the data should like:

Word contains

the best gift gift

SAS programming SAS

apt no: 12356 12356

The intended output is:

Word contains

the best gift

programming SAS

apt no: 12356

How can I do this? Thanks for every help

Re: How to remove words in a column by another column values

PeterClemmensen — Mon, 27 Sep 2021 10:23:38 GMT

What is the logic?

Re: How to remove words in a column by another column values

Ksharp — Mon, 27 Sep 2021 12:21:07 GMT

data have;
input Word    & $40.                                 contains $;
cards;
the best gift                           gift
SAS programming                SAS
apt no: 12356                       12356
;
data want;
 set have;
 want=prxchange('s/\b'||strip(contains)||'\b//i',-1,word);
run;