How to remove words in a column by another column values

[fatihekici]

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

[PeterClemmensen]

What is the logic?

[Ksharp · Accepted solution]

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;