Similar to @Patrick's code, maybe a bit less cryptic :
proc sql;
create table want as
select
loc,
car,
dhms(date,hour(time),minute(time),0) as datetime format=datetime16.
from have
group by loc, car
having datetime = min(datetime);
quit;
... View more
