Let's say I have four samples: id=1, 2, 3, and 4, with one or more measurements on each of those samples id value 1 1 1 2 2 3 2 -4 3 -5 4 6 I want to remove duplicates, keeping only one entry per ID - the one having the largest absolute value of the "value" column. I.e., this is what I want: id value 1 2 2 -4 3 -5 4 6 How might I do this on 8.3 eg?
... View more