Hi everyone, I'm a bit stumped as to how to approach this data manipulation problem, and I'm hoping the community can help. This is my first time posting, so my apologies if I'm doing this incorrectly. I currently have a dataset that looks like this: group date A 2/12/2018 A 7/18/2018 A 8/23/2018 A 10/4/2018 B 5/10/2018 B 9/4/2018 B 12/18/2018 C 3/19/2018 C 6/2/2018 D 3/12/2019 D 4/25/2019 D 5/23/2019 D 6/19/2019 My goal is to take each date within a group and the subsequent date that follows to create two new "start" and "end" variables that indicate a date range. Here is my desired output: group start end A 2/12/2018 7/18/2018 A 7/18/2018 8/23/2018 A 8/23/2018 10/4/2018 B 5/10/2018 9/4/2018 B 9/4/2018 12/18/2018 C 3/19/2018 6/2/2018 D 3/12/2019 4/25/2019 D 4/25/2019 5/23/2019 D 5/23/2019 6/19/2019 Unfortunately, I do not have SAS code that I've tried, as I do not even know how to start to go about doing this. 😞 Any help is much appreciated.
... View more