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