Learning SAS? Welcome to the exclusive online community for all SAS learners.

Period Overlap

Reply
N/A
Posts: 1

Period Overlap


Hi,

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.

Thanks,

RD


Output.jpgData.jpg
Super User
Super User
Posts: 7,401

Re: Period Overlap

Hi,

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.

Ask a Question
Discussion stats
  • 1 reply
  • 518 views
  • 0 likes
  • 2 in conversation