find out Duplicate Emails

[ccnky123]

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 |
+---------+

[VDD · Accepted solution]

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;

[Jagadishkatam]

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