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
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;
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;
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.