LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (November 2006, week 4)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:   Tue, 28 Nov 2006 09:57:47 -0500
Reply-To:   Peter Crawford <peter.crawford@BLUEYONDER.CO.UK>
Sender:   "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:   Peter Crawford <peter.crawford@BLUEYONDER.CO.UK>
Subject:   Re: Find duplicate information

On Tue, 28 Nov 2006 09:43:54 -0500, Ran S <raan67@YAHOO.COM> wrote:

>Hi, > >I have a dataset where I am looking for duplicates. In my dataset I would >like to keep and look at the IDS if it has same ID but slightly different >data values for atleast one or more variables.What's the best way of >comparing data values for all these variables for 2 or more same IDs? > >I would appreciate your help in this regard. > >Thanks!

how big is your data ( #rows and #columns) ?

Is it ordered by ID ?

What will you do with the information? For example : create a table of just duplicates or just reduce the data to unique values or distribute some value according to other distribution share

the interested await.

Peter

Back to: Top of message | Previous page | Main SAS-L page
listserv.uga.edu
Enterprise Information Technology Services
The University of Georgia
listhelp@uga.edu