topic Re: setting period condition between a and b in SAS Programming

setting period condition between a and b

dr_101 — Thu, 21 Feb 2019 09:59:34 GMT

Re: setting period condition between a and b

PaigeMiller — Mon, 04 Feb 2019 17:39:37 GMT

In a SAS data step

if date2>date1 and not missing(date1);

Re: setting period condition between a and b

dr_101 — Thu, 21 Feb 2019 10:02:32 GMT

Re: setting period condition between a and b

PaigeMiller — Mon, 04 Feb 2019 17:55:29 GMT

@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.