I have three time variables in the time8 format, like this:
id mod1 mod2 mod3
232791 0:50:29 0:34:49 0:36:41
234068 0:40:50 2:28:09 0:36:08
I need to get means and standard deviations on the number of minutes. What time format should I be using?
Thanks!
If you want to do calculations on minutes then you will need to convert your values from seconds into minutes by dividing by 60.
How do you want to do this? With PROC SUMMARY?
Also, do you want do do get the statistics by id, variables or overall?
I want to get the overall mean and standard deviation for the mod1, mod2, and mod3 variables.
I was hoping to create new time variables with a format so that when I do the summary statistics the results come out in minutes, something like 37.2 (minutes) mean +- 5.3 (minutes), standard deviation
thanks!
If you want to do calculations on minutes then you will need to convert your values from seconds into minutes by dividing by 60.
Yup that did the trick. Thanks!!
April 27 – 30 | Gaylord Texan | Grapevine, Texas
Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!
SAS' Charu Shankar shares her PROC SQL expertise by showing you how to master the WHERE clause using real winter weather data.
Find more tutorials on the SAS Users YouTube channel.