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

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

zhang_l — Wed, 25 Jun 2014 00:51:24 GMT

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 — Wed, 25 Jun 2014 01:19:05 GMT

Try this.

data want;

set have;

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

run;

Ksharp — Wed, 25 Jun 2014 13:04:28 GMT

OR perl regular expression :

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