topic Re: Prxmatch - excact/restriction? in SAS Programming

Prxmatch - excact/restriction?

ybz12003 — Fri, 13 Mar 2020 14:54:33 GMT

Hello,

The prxmatch program below is searching the created macro list as 'CAR|IL|VN|KK'. However, I would like the search be more restricted. Instead of containing the ''CAR|IL|VN|KK'' string in the text, I like to match 100% these two letters. Please advice how to change this prxmatch codes. Thank you.

if prxmatch ("/&Jurisdiction_list./i",id) then TempID=id;

The following sample data set is

data datain;
      infile datalines dsd;
  input ID : $300. ;
datalines;
	CAR ID  MA,
	ILH,
	PAUL  VN,
	KKK GGGG,
	Card ID BMA,
	Care ID FMA,
;

run;

The final result I am looking for is only at the 1st and 3rd row.

Re: Prxmatch - excact/restriction?

novinosrin — Fri, 13 Mar 2020 15:21:10 GMT

%let Jurisdiction_list=CAR|IL|VN|KK;
data datain;
      infile datalines dsd;
  input ID : $300. ;
datalines;
	CAR ID  MA,
	ILH,
	PAUL  VN,
	KKK GGGG,
	Card ID BMA,
	Care ID FMA,
;

run;
data want;
set datain;
if prxmatch ("/\b(&Jurisdiction_list)\b/i",id) then TempID=id;
run;

ID	TempID
CAR ID MA	CAR ID MA
ILH
PAUL VN	PAUL VN
KKK GGGG
Card ID BMA
Care ID FMA

Re: Prxmatch - excact/restriction?

ybz12003 — Fri, 13 Mar 2020 15:25:31 GMT

What is the '\b' for? Why need to one at the front and one at the end?

Re: Prxmatch - excact/restriction?

novinosrin — Fri, 13 Mar 2020 15:35:41 GMT

\b metacharacter is known as word boundary. When you mentioned "absolute" match of a word, my thought went straight to wrap the search string to make it a word boundary with \b

Re: Prxmatch - excact/restriction?

ybz12003 — Fri, 13 Mar 2020 15:37:04 GMT

Thank you.