Hi! I'm trying to subset some data to one row per id per week (currently is multiple rows/id/week). I want to keep the row associated with the latest date. Event date just corresponds to if the event occurred in 2021 (2) or before (1). Please help! Simple question but I'm super stuck! Thanks in advance! Have: week id  year event_date 1 1 2015 1 1 1 2016 1 1 1 2021 2 2 1 2015 1 2 1 2016 1 2 1 2021 2 3 1 2015 1 3 1 2016 1 3 1 2021 2 1 2 2015 1 1 2 2016 1 1 2 2017 1 2 2 2015 1 2 2 2016 1 2 2 2017 1 3 2 2015 1 3 2 2016 1 3 2 2017 1   Want: week id year event_date 1 1 2021 2 1 2 2017 1 2 1 2021 2 2 2 2017 1 3 1 2021 2 3 2 2017 1 ... View more