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
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
The question is: why is a time stored as character? Check how this data arrived in SAS, and fix it there.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.