topic Re: Find a word with a dot in a variable in SAS Programming

Find a word with a dot in a variable

Selli5 — Wed, 10 Oct 2018 02:54:00 GMT

Hello,

How do I find ".OD." with the 2 dots either side within a character?

I have tried the prxmatch function but it is ignoring the dots either side and just finding the 'OD'.

eg:

OD2 = prxmatch("m/.OD./ois", productcode);

thanks

Sally

Reeza — Wed, 10 Oct 2018 03:33:02 GMT

Is OD what you want to find, or a period, two characters and another period?

If it's the first, have you tried FIND() or INDEX()?

OD2 = find(productcode, '.OD.', 'i');

PGStats — Wed, 10 Oct 2018 03:42:54 GMT

The period is a special character in regular expressions. It must be escaped to be interpreted as the period character.

OD2 = prxmatch("m/\.OD\./ois", productcode);