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 😉
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.