returning the first event date

lillymaginta — Fri, 04 Nov 2016 22:12:42 GMT

id event_beg_date event1_end  event2_end event3_end 
1    01/01/2005  04/05/2005  03/10/2005  06/01/2005

I have the above code. I want to calculate the number of days between the event_beg_Date and the first event that happen across the three event dates.

So for example above, the code should retain the number of days between 01/01/2005 and 03/10/2005

Re: returning the first event date

Reeza — Fri, 04 Nov 2016 22:22:36 GMT

Dates are numeric so you can use the MIN() function to find the earliest date.

duration = min(event1_end, event2_end, event3_end) - event_beg_date;

topic Re: returning the first event date in SAS Programming

returning the first event date

Re: returning the first event date