I have a dataset that I am trying to remove duplicates based on two variables, for example, name and date. The dataset looks something like this Name Date
John Doe 7/11/2020
John Doe 7/15/2020
John Doe 7/15/2020
Melissa Monday 7/5/2020
Melissa Monday 7/11/2020
Melissa Monday 7/11/2020
Sue Susan 7/1/2020
Sue Susan 7/5/2020
Sue Susan 7/5/2020 I am attempting to remove duplicates, but duplicate dates within each name. I have tried doing the following: data nodups; set data; by name date; if (first.name and first.date) then output; run; but that only gives me observations where it is the first name and also the first date in the entire dataset, not the first date within the individual dataset. Does anyone know how I can get to this?
... View more