07-08-2017 12:59 PM
07-08-2017 01:13 PM
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;
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.
create table z as
select sum(time) as sum format=tod10.
Kindly help !
Need further help from the community? Please ask a new question.