PRX

[SASPhile]

where prxmatch('/^3[47][1236789].*/',put(cm13,13.))

What does the above prxmatch do?

[Ksharp]

It means the first digit(at the beginning of the string) should be 3 ,the second digit shoud be 4 or 7 . the third digit should be 1 or 2 ...........

[SASPhile]

The hat(^) means not to include right?

[Haikuo]

I am afraid not. ^ here is to match beginning of line; [^abc] is to match a character not in the brackets.

Haikuo

[SASPhile]

When I use prx match and substr I'm getting different results.

If I substituted with substr function where substr(put(cm13,13.),1,3)='347'; I'm getting zero records.

Where as with PRX I'm getting some records.

[ballardw · Accepted solution]

Try strip(put(...  adjusting parantheses to match

The format is putting out a string of 13 characters but the leading characters are blanks. So the substr is returning '   '