setting period condition between a and b

[PaigeMiller · Accepted solution]

In a SAS data step

if date2>date1 and not missing(date1);

[PaigeMiller]

---

@dr_101 wrote:

thank you very much for replying.  will it set the distance between the two events at least one year? some ids have as little as 2 months gap between event 2 and event 1. I want to select only those with atleast 1 year gap.

thanks.

---

Your original post did not specify you wanted 1 year intervals.

A 1 year gap can be found via:

if date2>(date1+365) and not missing(date1);

Might need an adjustment if you really are concerned about leap years.