topic Re: find out Duplicate Emails in SAS Programming

find out Duplicate Emails

ccnky123 — Mon, 10 Sep 2018 23:53:02 GMT

to find all duplicate emails in a table with data step.

+----+---------+
| Id | Email   |
+----+---------+
| 1  | a@b.com |
| 2  | c@d.com |
| 3  | a@b.com |
+----+---------+

For example, your query should return the following for the above table:

+---------+
| Email   |
+---------+
| a@b.com |
+---------+

Re: find out Duplicate Emails

VDD — Tue, 11 Sep 2018 00:46:11 GMT

data have;
input
Id Email $;
cards;
1 a@b.com
2 c@d.com
3 a@b.com
;
run;
proc sort data=have;
by email;
run;
data want;
set have;
by email;
if not last.email;
run;

Re: find out Duplicate Emails

Jagadishkatam — Tue, 11 Sep 2018 00:51:16 GMT

proc sql;
create table want as select count(email) as cnt, email from have group by email having count(email)>1;
quit;