topic Re: email addresses error in SAS Programming

email addresses error

Grandhi4 — Thu, 10 May 2012 14:21:25 GMT

Hi,

I have some two million records (email id's) in that some of wrong email addresses like ('@' missing, '.com' missing, '.net' missing,...) and each email address their own character length...so now my question is 1) How to identify the 'error' email id's ?

2) How to delete 'error' email id's ?

3) How to make a two different data sets for 'error ones' and 'non errors' ?

any one can please help the logic (code).

Thanks,

Suresh

Re: email addresses error

RickM — Thu, 10 May 2012 15:31:15 GMT

For finding valid adresses I think perl regular expressions functions would be a good way (prxparse, prxmatch).

You can output data to different datasets within the same data step.

data A B;

set C;

if condition then output A;

else output B;
run;

Good luck!

Re: email addresses error

FriedEgg — Thu, 10 May 2012 19:08:59 GMT

data eml;
input eml $20.;
cards;
valid@email.com
bad@email.sdglkjasd
b ad@space.net
notanemail.com
;
run;

data good bad;
set eml;
if ^prxmatch('/^\w[\w\.\-]*\w\@\w[\w\.\-]*\w(\.\w{2,4})$/',strip(eml)) then output bad;
  else output good;
run;