Finding 4 words in a free form comment

[Gil_]

I tried using prxmatch would it be easier to use index? I am looking for word text4, text 7, and text9.
Sometimes they are misspell for example tex4
The index works if its one and spelled correctly
Data test;
Set test;
Text_position( varaible,"text4");
Run;
This works great i need to add the additional text7 and text9

[ChrisNZ]

INDEX is faster.

PRXMATCH is more flexible.

POS=prxmatch('/(TEXT?4|TEXT7|TEXT9)/',STRING);

[Reeza · Accepted solution]

Fuzzy matching words is hard. You’ll also make mistakes, so decide if it’s worth the effort first.

[Gil_]

The output is 0 even though the words is there. What is ? In text4

[ChrisNZ]

The output is 0 even though the words is there. What is ? In text4

Make the search case insensitive?

Add i after the second slash in the regular expression.