Regex and delete

[aaaaa34]

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!

[PeterClemmensen]

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?

[aaaaa34]

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

[PeterClemmensen]

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;

[aaaaa34]

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.

[PeterClemmensen]

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;