topic Re: Date / Time Formatting Issue in SAS Programming

Date / Time Formatting Issue

AgentA — Sat, 08 Jul 2017 16:59:38 GMT

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 !

Re: Date / Time Formatting Issue

Reeza — Sat, 08 Jul 2017 17:13:14 GMT

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 !

Re: Date / Time Formatting Issue

AgentA — Sat, 08 Jul 2017 17:34:26 GMT

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

Re: Date / Time Formatting Issue

Reeza — Sat, 08 Jul 2017 17:43:55 GMT

Have you tried TIME.?

Re: Date / Time Formatting Issue

AgentA — Sat, 08 Jul 2017 18:11:28 GMT

TIME10. worked, Thank you