11-27-2014 08:17 AM
I have a data as attached in Data.jpg:
I wanted to identify overlapping periods.
Suppose the start first date column will check between start and end date columns. If yes, it will make that Min(Start Date) as Start date and Max(end date) as end date.
If it's not overlapping then it will take those periods directly.
Output as it, output.jpg.
11-27-2014 08:34 AM
I commented on a similar issue earlier today: https://communities.sas.com/thread/63309
Note that its easier for people trying to solve your issue if you put the data in the text so we can copy/paste it.