I would go back to the identify duplicates option and sort within matching
cases by the matchsequence variable you created. Have last case as primary.
Use the filter option to select primary cases. This would give you the last
case within each id. Is this what you want to do?
Lyndsay
-----Original Message-----
From: SPSSX(r) Discussion [mailto:
[hidden email]] On Behalf Of
Alina Sheyman
Sent: Wednesday, August 01, 2007 12:14 PM
To:
[hidden email]
Subject: comapring cases
I'm trying to compare several cases with the same id using spss. I've
identified duplicates and have them sorted and numbered in order, now I
need to do calculations on the last one in a sequence of identical id's. Is
there a code that will allow me to do an operation on the value if the next
value in the list is less than the current one? (Basically I just need to
grab the last record in a sequence)
thank you