topic The prxmatch function in SAS Programming

The prxmatch function

frupaul — Wed, 11 Apr 2018 22:47:49 GMT

Hi All,

I have been struggling to use the prxmatch function to validate email addresses. Can anyone direct me to a resource to use please?

THanks

Re: The prxmatch function

Reeza — Wed, 11 Apr 2018 22:57:52 GMT

In general, you'll find macros and examples most easily on LexJansen.com

https://lexjansen.com/search/searchresults.php?q=prx%20email%20addresses

Re: The prxmatch function

ChrisNZ — Wed, 11 Apr 2018 23:55:51 GMT

prxmatch uses Perl regular expressions (except for the more arcane expressions), so most examples on the web can be used in prxmatch.

Here is a simple one.

data TEST;
  input EMAIL :$60.;  
  IS_VALID=prxmatch('/^[A-Z0-9._%+-]+@[A-Z0-9.-]+\.[A-Z]{2,64}$/i',strip(EMAIL));
cards;       
robot@sas.com            
james.taylor@sas.co.nz
james@taylor@sas.co.nz
run;

IS_VALID

Re: The prxmatch function

andreas_lds — Thu, 12 Apr 2018 06:13:24 GMT

There is a discussion on stackoverflow: https://stackoverflow.com/questions/201323/how-to-validate-an-email-address-using-a-regular-expression about validating e-mail addresses. If your code needs to be 100% RFC822 compliant, the expression is a bit more complex 😉