topic Re: PRX in SAS Programming

PRX

SASPhile — Fri, 21 Dec 2012 02:30:10 GMT

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

What does the above prxmatch do?

Ksharp — Fri, 21 Dec 2012 07:29:42 GMT

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 — Fri, 21 Dec 2012 14:24:29 GMT

The hat(^) means not to include right?

Haikuo — Fri, 21 Dec 2012 14:59:05 GMT

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

Haikuo

SASPhile — Fri, 21 Dec 2012 21:45:51 GMT

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 — Fri, 21 Dec 2012 22:41:54 GMT

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 ' '