Dear SAS Community I would like to be able to link accounts with unique e-mails which are similar to each other, for example: Account 1. vladimr241@gmail.com Accoun 2. vladimr231@gmail.com Account 3. vladim1245@gmail.com Account 4. vladimra3333@gmail.com The ultimate goal would be to create a summary table which would say that based on the example above, we are dealing withL - 1 account holder (1 person responsible for creating all accounts) linked with 4 similar emails. - Or we can summarise it as 4 accounts linked with 1 e-mail (so we are still assuming 1 person responsible for creating all accounts, but this time we are saying that four accounts were created using the same (as in almost identical) e-mail address. I came across SAS pdf titled "Using Edit-Distance Functions to Identify “Similar” E-Mail Addresses" which discusses SPEDIS, COMPLEV, COMPEGED procedures. Unfortunately, things discussed there are quite vague and I prorably need slightly more basic tutorial, so I was wondering whether there is any standard query that would meet my requirements (i.e. summarise it in the above-described way) if I applied it to tens of thousands of e-mails address.
... View more