Hi, I have following dataset that I sorted by first Begindate and then Entrydate. If ID has same Begin Date in multiple rows, I want to keep only first row with that begin date. for e.g. for ID 1, I want to keep first and third row. For ID 2, keep both rows because Begin date is not same. For ID 3, keep first row because Begin date is same in both rows. For ID 4, keep the row, because its the only row. (EDIT: There are other variables besides these.) Dataset Have: ID BeginDate_1 EntryDate_2 1 4/8/2019 4/15/2019 1 4/8/2019 5/14/2019 1 4/30/2019 8/7/2019 2 5/20/2019 8/13/2019 2 6/3/2019 6/4/2019 3 4/15/2019 5/28/2019 3 4/15/2019 7/17/2019 4 5/20/2019 6/20/2019 So the resulting dataset will look like this: ID BeginDate_1 EntryDate_2 1 4/8/2019 4/15/2019 1 4/30/2019 8/7/2019 2 5/20/2019 8/13/2019 2 6/3/2019 6/4/2019 3 4/15/2019 5/28/2019 4 5/20/2019 6/20/2019 Can anyone help me with this? Thank you.
... View more