topic Re: Exclusion in PRXMATCH ? in SAS Programming

Exclusion in PRXMATCH ?

ybz12003 — Wed, 11 Mar 2020 20:04:54 GMT

Hello,

I would like to exclude the 'SUB' and 'NCV' in the PRXMATCH command. I have the code below. I found the texts are still in the result TEMPID. Please help. Thank you.

 if prxmatch ('/000|^SUB|^NCV/i',id) then TempID=id;

Re: Exclusion in PRXMATCH ?

PeterClemmensen — Wed, 11 Mar 2020 20:56:24 GMT

I'm not entirely sure what you want to do here. Your code matches string that contain '000' or starts with either 'sub' or 'ncv' (case insensitive).

Re: Exclusion in PRXMATCH ?

novinosrin — Wed, 11 Mar 2020 21:13:26 GMT

Hi @ybz12003 Not sure your objective,

Assuming you are saying something like below is what you want

 if id = '000' or id not in  ('SUB','NCV') then tempid=id;/*assuming you want this*/

is literally equivalent to

 if  id not in  ('SUB','NCV') then tempid=id;

which basically is equivalent to

if not prxmatch ('/SUB|NCV/i',id) then TempID=id;

Re: Exclusion in PRXMATCH ?

Patrick — Thu, 12 Mar 2020 01:16:26 GMT

@ybz12003 wrote:

Hello,

I would like to exclude the 'SUB' and 'NCV' in the PRXMATCH command. I have the code below. I found the texts are still in the result TEMPID. Please help. Thank you.
 if prxmatch ('/000|^SUB|^NCV/i',id) then TempID=id;

Please provide some sample data and then show us the desired result.

For your RegEx: Do you by any chance believe the ^ has a meaning of NOT?

^abc Here the ^ means beginning of string so strings starting with abc will match.

[^abc] Here the ^ has the meaning of NOT and string containing a, b, or c anywhere will not match

Re: Exclusion in PRXMATCH ?

ybz12003 — Thu, 12 Mar 2020 15:36:14 GMT

Below is my sample dataset.

data datain;
      infile datalines dsd;
  input Name : $300. ;
datalines;
	0001234,
	SUB0001031,
	NCV0001234,
	CARID0001070,
	;
run;

The final result I want is 0001234 and CARID0001070.

Re: Exclusion in PRXMATCH ?

novinosrin — Thu, 12 Mar 2020 15:40:51 GMT

Hi @ybz12003 Please check if this works



data datain;
      infile datalines dsd;
  input Name : $300. ;
datalines;
	0001234,
	SUB0001031,
	NCV0001234,
	CARID0001070,
	;
run;
data want;
 set datain;
 where not prxmatch ('/^(SUB|NCV)/i',name);
run;

Re: Exclusion in PRXMATCH ?

ChrisNZ — Thu, 12 Mar 2020 21:53:39 GMT

Like this?

where NAME not in: ('SUB','NCV') and index(NAME,'000');