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 (March 2006, week 5)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:         Wed, 29 Mar 2006 01:29:23 -0500
Reply-To:     Paul Pham <psquares@YAHOO.COM.AU>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Paul Pham <psquares@YAHOO.COM.AU>
Subject:      Re: First. & Last.

Hello Toby, I just want to clarify things a bit clearer here, all three data steps used the same data set (RESULTS) which have 42402 rows (already sorted but not de-duplicated) and the first two data steps used the if first. and last.byvariable to de-duplicate.

The third data step however is exactly the same as the first two but without the if first. or the last.byvariable condition line, the deduplication is done by the proc sort.

I'm just puzzled why the 3 de-duplication methods gives so different results, again thank you for your feedbacks and much appreciated if you can get back to me.

Cheers

Paul


Back to: Top of message | Previous page | Main SAS-L page