Date:         Thu, 15 Mar 2001 13:55:56 -0800
Reply-To:     RAHUL CHAHAL <rahulchahal@YAHOO.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         RAHUL CHAHAL <rahulchahal@YAHOO.COM>
Subject:      Re: dups
In-Reply-To:  <9D17D648E4EBD311AD45009027D0DF930117AF43@mcdc-atl-64.cdc.gov>
Content-Type: text/plain; charset=us-ascii

I do understand how nodupkey and noduprec work.

Specifically I want to know how can one find what is
different between the records.

Thanks all.

--- "Fehd, Ronald J." <rjf2@cdc.gov> wrote:
> > From: Rahul Chahal [mailto:rahulchahal@YAHOO.COM]
> > I have records which when I look at them look like
> they are
> > duplicate but
> > when I sort with "noduprec" option it does not
> delete them.
> > Is it possible
> > to easily find what is different among the
> records.
>
> you're going to have to RTFM on the sort options
>
> NoDupRec: checks for and eliminates duplicate
> observations
> ... compare(s) all variable values for each
> observations ...
>
> note specifically: _all_ variable values
>
> so if what you see as 'duplicates' are not being
> deleted
> then they aren't duplicates!
>
> now if you were to use the option:
> NoDupKey: checks for and eliminates observations
> with duplicate BY values
>
> then you can be sure that the observations with the
> duplicate _keys_ would
> be dropped.
>
> Ron Fehd  the macro maven  CDC Atlanta GA USA
> RJF2@cdc.gov
> OpSys: WinNT   Ver: 8.1
> ---> cheerful provider of SAS manual trivia !*! <---
> remember perspective: the error is not always where
> it seems to occur! --
> RJF2


=====
Shilpa R. Chahal.  MD, PhD.
Tulane University, Dept of Neurology.
504-588-5263 (W)
504-818-2235 (H)

__________________________________________________
Do You Yahoo!?
Get email at your own domain with Yahoo! Mail.
http://personal.mail.yahoo.com/