Hi hope this is the solution you're looking for
proc sql;
select
case when
timepart(sourcetime) > '16:00:00't then
input(put(datepart(sourcetime)+1,date9.) || ' ' || '10:00:00',datetime.)
else
sourcetime
end
as adjustedtime format = datetime.
from table
quit;
There are probably other ways but this is the one that i came up with
Regards,
Milton
... View more
