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
In general, you'll find macros and examples most easily on LexJansen.com
https://lexjansen.com/search/searchresults.php?q=prx%20email%20addresses
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 |
1 |
1 |
0 |
There is a discussion on stackoverflow: https://stackoverflow.com/questions/201323/how-to-validate-an-email-address-using-a-regular-expressi... about validating e-mail addresses. If your code needs to be 100% RFC822 compliant, the expression is a bit more complex 😉
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.