Date:         Tue, 1 Jul 2008 05:36:20 -0700
Reply-To:     ravikumarpsas@GMAIL.COM
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         ravikumarpsas@GMAIL.COM
Organization: http://groups.google.com
Subject:      How to find out duplicates by using sql (Not using proc sort
              dupout)
Comments: To: sas-l@uga.edu
Content-Type: text/plain; charset=ISO-8859-1

Hi,

I am Ravi kumar.
I have a simple question.
data a;
input x;
cards;
2
6
2
9
6
;
run;
For the above question,How to findout the duplicates by using sql.
output:
2
6
Please help me on the same
Many Thanks
Ravi