Linking overlapping hospital stays

A common problem in health registry research is to collapse overlapping hospital stays to a single stay while retaining all information registered for the patient. Let’s start with looking at some example data:

pat_id