Date / Time Formatting Issue

[AgentA]

Hi Friends,

I want to sum the time. I am using the below query but not getting the accurate sum of Hours. Please see the attached CSV file.

proc sql;
create table z as
select sum(time) as sum format=tod10.
from totaltime;
quit;

 Kindly help !

[Reeza]

The issue is likely with the format, there's nothing else that could be modified in your code.

Have you tried other formats?  Looking at TOD it doesn't seem like it would have more than 24 hours and I suspect that's the issue you're having.

proc sql;
create table test as
select sum(time)/(60*60) as num_hours
from have;
quit;

---

@AgentA wrote:

Hi Friends,

I want to sum the time. I am using the below query but not getting the accurate sum of Hours. Please see the attached CSV file.

proc sql;
create table z as
select sum(time) as sum format=tod10.
from totaltime;
quit;

 Kindly help !

---

[AgentA]

which format to use to get results in hhh:mm:ss ?

[Reeza · Accepted solution]

Have you tried TIME.?

[AgentA]

TIME10. worked, Thank you