- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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.
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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;
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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;
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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;
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Oh wow, duh thanks. I guess I have been working too much in Stata...