Re: Valid email address:

SASPhile · Posted 02-12-2013 04:40 PM

As a first step towards data cleaning:

How to get the counts of following where there just hypens before @ in email addresses:

[email protected]

Haikuo · Posted 02-12-2013 05:24 PM

You will probably need some Regular expression:

data have;

input email :$char100.;

cards;

[email protected]

;

data want;

set have;

if prxmatch("/^-+@/",email) then ind=1;

run;

proc print;run;

Haikuo

Astounding · Posted 02-12-2013 05:27 PM

One way:

proc freq data=have;

tables email;

where index(email, '----');

run;

It will print a table based on any email addresses that contain four dashes in a row, anywhere within the address. If you want to cut it to less than 4, that's up to you. You know your data best.

Good luck.

Haikuo · Posted 02-12-2013 05:32 PM

I had to ask, what if you want to keep:

[email protected]

but to drop:

[email protected]?

I still think the Regular expression is the way to go, at least for the first step.

my 2 cents,

Haikuo

Astounding · Posted 02-12-2013 09:51 PM

I suppose I could switch from this:

index(email, '----')

to this:

index(email, '-@')

art297 · Posted 02-12-2013 05:34 PM

: Since you wanted strings that start with any number of hyphens, then followed with an @, I'll suggest adding one more character to Haikuo's code. The ^ at the beginning forces the match to have occurred at the start of the string:

data have;

informat email $50.;

input email;

cards;

[email protected]

;

data want;

set have;;

if prxmatch("/^-+@/",email) then ind=1;

run;

DBailey · Posted 02-12-2013 05:47 PM

DATA WANT;

SET HAVE;

if index(email,'@')-1 = countc(substr(email,1,index(email,'@')-1),'-');

run;

Valid email address: