find out Duplicate Emails

[ccnky123]

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

+----+---------+
| Id | Email   |
+----+---------+
| 1  | [email protected] |
| 2  | [email protected] |
| 3  | [email protected] |
+----+---------+

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

+---------+
| Email   |
+---------+
| [email protected] |
+---------+

[VDD · Accepted solution]

data have;
input
Id Email $;
cards;
1 [email protected]
2 [email protected]
3 [email protected]
;
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;