where prxmatch('/^3[47][1236789].*/',put(cm13,13.))
What does the above prxmatch do?
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 ' '
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 ...........
The hat(^) means not to include right?
I am afraid not. ^ here is to match beginning of line; [^abc] is to match a character not in the brackets.
Haikuo
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.
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 ' '
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.