Hello Leonid! I hope this message finds you well.

I recently found this blog posting. I'm finding it very useful, but I'd like to ask you a technical question.

I have a list of housing transactions that I need to find the number of overlapping days between all pairs of transactions. Each transaction has a listing date and a sale date, but they are in one column each. So for example:

House Listing Date Selling Date
1 1/1/2024 6/1/2024
2 2/26/2024 8/20/2024
3 2/13/2024 4/1/2024
4 5/14/2024 6/16/2024
5 3/24/2024 8/24/2024

I need to find the number of overlapping days between House 1 and House 2, then House 1 and House 3, etc., subsequently with each House.

Your approach in SAS doesn't match what I have, so I was wondering how to implement it?

I would appreciate any help.

Thanks! Looking forward to hearing back from you.

AJ