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.
