topic calculate average for time in different format in SAS Programming

calculate average for time in different format

EPANG1 — Sat, 13 Nov 2021 04:58:43 GMT

Good afternoon,

I would like to calculate the average time for all records for the columns of time_arrival and time_attend. However, one is display as character and one is display as time. How can I do this? Thanks

Re: calculate average for time in different format

Reeza — Sat, 13 Nov 2021 05:06:18 GMT

Do the conversion for the one that's a character and subtract them.

And results:

Here's a great, but longer and in depth, reference for dates and times in SAS
https://communities.sas.com/t5/SAS-Communities-Library/Working-with-Dates-and-Times-in-SAS-Tutorial/ta-p/424354

@EPANG1 wrote:

Good afternoon,

I would like to calculate the average time for all records for the columns of time_arrival and time_attend. However, one is display as character and one is display as time. How can I do this? Thanks

Re: calculate average for time in different format

Kurt_Bremser — Sat, 13 Nov 2021 05:56:44 GMT

The question is: why is a time stored as character? Check how this data arrived in SAS, and fix it there.