Complex merging - Base SAS 9.4

[jomag]

Hello All,

I have two large datasets(a baseline file (approx 64,000 observations) and an endpoint file (approx 33,000 observations)) of repeated observations that I would like to merge based on a few conditions:

1. They should be of the same study id

2. They should have the same start year

3. The day when endpoint occurred must be the same as study start day or end day or within that period (for a row)

I am attaching an example of how these two files look like and how I would like them to look after merging.

Definitions of the variables are:

Begin day= Number of days from start year

End day = Number of days from start year

[LinusH]

1. Supply sample data in dorm of a data step w DATALINES.
2. Describe what you have tried so far.