It is a difficult question to answer , I tried Soundex function .But for ten thousands different names you have to find a different approach , I try to find and post the answer in any.
data newdata; input Emailid$ 30.; Emailid1=soundex(Emailid); datalines; vladimr241@gmail.com vladimr231@gmail.com vladim1245@gmail.com vladimra100000@gmail.com Hello@gmail.com Val@1234567890 ; run; Proc Print data = newdata; run;
... View more