topic Re: Regex and delete in SAS Data Management

Regex and delete

aaaaa34 — Wed, 04 Dec 2019 16:01:01 GMT

Hi,

I would like to make an if condition like if PRXMATCH(..., var1)>0 then delete. I would like to remove all cases in which I have:

0,00dd
454dd
0,234dd

Thanks in advance!

Re: Regex and delete

PeterClemmensen — Wed, 04 Dec 2019 16:03:37 GMT

Do you want to delete the observations where any of those three strings occur or do you want to delete the 'dd' part of the posted strings?

Re: Regex and delete

aaaaa34 — Wed, 04 Dec 2019 16:05:29 GMT

I want to delete the observations where these three strings occur.

Re: Regex and delete

PeterClemmensen — Wed, 04 Dec 2019 16:08:57 GMT

Like this?

data have;
input string $20.;
datalines;
abc0,00ddabc
abcabc
defdef
abcdef454dd
0,234ddabcdef
;

data want;
   set have;
   if not prxmatch('/0,00dd|454dd|0,234dd/', string);
run;

Re: Regex and delete

aaaaa34 — Wed, 04 Dec 2019 16:12:06 GMT

What if I have different numbers before dd? I wrote these numbers with dd only like an example. I want remove all cases in which dd is after numbers.

Re: Regex and delete

PeterClemmensen — Wed, 04 Dec 2019 16:14:34 GMT

Ah ok. Do this. This looks for patterns where the string 'dd' is after at least 1 digit.

data have;
input string $20.;
datalines;
abc0,00ddabc
abcabc
defdef
abcdef454dd
0,234ddabcdef
;

data want;
   set have;
   if not prxmatch('/\d+dd/', string);
run;