Proc Sort and nodupkey to keep dups based on another variable

[jacob_klimek]

Hello,

So I have a dataset like below:

id_var     year     measures

1             2014               20

1             2015               20

2             2015               23

3             2014               17

And I want get rid of duplicate id_vars but KEEP the one with the year 2015. I know nodupkey gets rid of duplicates based on the by variable in proc sort, but i don't know how to reference the specific year value. Any help would be great.

Thanks.

[Reeza]

Double sort. 

Sort first with descending year, then sort with nodupkey. 

Proc sort data=have;

by id descending year;

proc sort data=have nodupkey;

by id;

run;

[Reeza · Accepted solution]

Double sort. 

Sort first with descending year, then sort with nodupkey. 

Proc sort data=have;

by id descending year;

proc sort data=have nodupkey;

by id;

run;

[jacob_klimek]

Oh wow, duh thanks. I guess I have been working too much in Stata...