02-27-2016 08:51 PM
I have a dataset that has some duplicate observations as follows:
ID VAR1 VAR2 VAR3
1 a . .
1 a b c
2 d e f
3 g . .
var1, var2 and var3 are numeric.
I want to delete the first observation. I use the following code:
Proc sort data=have out=want nodupkey;
by ID VAR1;
However, this code delete the second observation, instead of the first one.
Any one knows what I should do to delete the first observations?? Thanks in advance!
02-28-2016 02:44 AM