calculate average for time in different format

[EPANG1]

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

[Reeza]

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/...

---

@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

---

[Kurt_Bremser]

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