How to create a drug course using dates.

[Astounding]

I can give you a little guidance, but I can't solve it.  I'm having trouble seeing how the output you post matches your description of what you want to achieve.  Regardless of what is needed, however, this looks like a case where the problem would become easier if you were to transpose the data.  Picture one observation per ID, with variables StartDate1 through StartDate20 and Drug1 through Drug20.  (Of course, 20 is an arbitrary number ... you need to create enough variables to hold the data for the patient with the largest number of dates.)

While I rarely recommend transposing data into that form, this strikes me as a problem that would become easier if you were to do that.

Good luck.

[shasank]

@Reeza Can you help me with this question?

[shasank]

@Tom Can you help me with this question.??