DATA Step, Macro, Functions and more

returning the first event date

Accepted Solution Solved
Reply
Frequent Contributor
Posts: 110
Accepted Solution

returning the first event date

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


Accepted Solutions
Solution
‎11-04-2016 06:28 PM
Super User
Posts: 17,829

Re: returning the first event date

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;

 

View solution in original post


All Replies
Solution
‎11-04-2016 06:28 PM
Super User
Posts: 17,829

Re: returning the first event date

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;

 

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 1 reply
  • 163 views
  • 0 likes
  • 2 in conversation