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.