Hi,
I have a list of participant ID's and start and stop dates for when they have been on a medication. Some participants have multiple rows but I would like one row per participant.
Participant Start date Stop date
1 24.11.2011 01.01.2016
1 18.02.2010 24.11.2011
1 24.11.2011 01.01.2016
1 18.02.2010 24.11.2011
I would like to just take the earliest date for the start date and the latest date for this stop date.
Participant Start date Stop date
1 18.02.2010 01.01.2016
Any help would be greatly appreciated!
Thank you
I have a list of participant ID's and start and stop dates for when they have been on a medication. Some participants have multiple rows but I would like one row per participant.
Participant Start date Stop date
1 24.11.2011 01.01.2016
1 18.02.2010 24.11.2011
1 24.11.2011 01.01.2016
1 18.02.2010 24.11.2011
I would like to just take the earliest date for the start date and the latest date for this stop date.
Participant Start date Stop date
1 18.02.2010 01.01.2016
Any help would be greatly appreciated!
Thank you