topic Re: Proc Sort and nodupkey to keep dups based on another variable in SAS Procedures

Proc Sort and nodupkey to keep dups based on another variable

jacob_klimek — Thu, 14 Jul 2016 21:08:39 GMT

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.

Re: Proc Sort and nodupkey to keep dups based on another variable

Reeza — Thu, 14 Jul 2016 21:14:44 GMT

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;

Re: Proc Sort and nodupkey to keep dups based on another variable

Reeza — Thu, 14 Jul 2016 21:14:45 GMT

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;

Re: Proc Sort and nodupkey to keep dups based on another variable

jacob_klimek — Thu, 14 Jul 2016 21:16:34 GMT

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