topic Re: time formats in New SAS User

time formats

hein68 — Tue, 03 Dec 2019 15:19:55 GMT

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!

Re: time formats

PeterClemmensen — Tue, 03 Dec 2019 15:31:58 GMT

How do you want to do this? With PROC SUMMARY?

Also, do you want do do get the statistics by id, variables or overall?

Re: time formats

hein68 — Tue, 03 Dec 2019 15:37:49 GMT

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!

Re: time formats

Tom — Tue, 03 Dec 2019 15:39:29 GMT

If you want to do calculations on minutes then you will need to convert your values from seconds into minutes by dividing by 60.

Re: time formats

hein68 — Tue, 03 Dec 2019 15:47:07 GMT

Yup that did the trick. Thanks!!