Your newness to SAS is not the main issue here. You need to specify what rule you want followed to collapse the nine obs you have shown to just one.
I'll guess it is: for all obs with same ID, create one rec with first rec's start_dt and last rec's end_dt.
Correct?
Before you answer, note I did not say "first rec" by date or by current order in the data - I did not say either. You must include this and every other imaginable detail in your specs.
... View more