How to filter for single non joined words like "PAY" but not joined words containing PAY such as "PAYPAL", "BPAY" "PAYED"

[zhang_l]

I am trying to filter out records with the word "PAY" in the description but I want to filter out words containing PAY.

So for example if the description says

JOHN SMITH WEEKLY PAY

Then I wish to include this record as the word PAY is by itself. However if the Description is in the form of

PAYPAL , BPAY, PAYED

or any characters or words that start, has pay in the middle or ends with pay, then I wish to exclude the record.

Is there anyway to be able to do this?

[stat_sas]

Try this.

data want;

set have;

if findw(name,'PAY')>0 then output;

run;

[Ksharp]

OR perl regular expression :

if prxmatch('/\bPAY\b /',name) ;