Date:         Mon, 30 Nov 2009 05:43:14 -0800
Reply-To:     Mooooooooooooooo! <darrenhoggard@GOOGLEMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Mooooooooooooooo! <darrenhoggard@GOOGLEMAIL.COM>
Organization: http://groups.google.com
Subject:      Selecting Duplicated Accounts
Comments: To: sas-l@uga.edu
Content-Type: text/plain; charset=ISO-8859-1

Hi
I have a list of 2 references numbers from 2 different systems:

I want to select all the accounts where reference number 1 is the
same, but reference number 2 is not:

ref1       ref2
1234     abcdef
1234     ghijklm
5678     hfakdjhf

I would want the sas code to return the 2 ref1s 1234 and the
corresponding ref2 values.

Any ideas?

thanks
d