Hi There, I managed to use the following code which gave me the outcome I was after. My data set consisted of a start_date column, a start_time column, and an end_time column. data mydata_set_2; set mydata_set; drop start_date enddate end_time start_time; START_DT=dhms(eventdate,0,0,modestart; format START_DT datetime.; if end_time<start_time then enddate=eventdate+1; else enddate=eventdate; format enddate date9.; END_DT=dhms(enddate,0,0,modeend); format END_DT datetime.; DURATION=END_DT-START_DT; run;
... View more
