topic Re: Time format in SAS in SAS Programming

Time format in SAS

AY2 — Fri, 11 Dec 2015 00:25:08 GMT

Hi,

I have different values of time in the format MM:SS. I am trying to figure out how to convert the values for time I have to numeric decimal. So for example, a time of 6:30 should be converted to 6.5.

Thanks in advance.

Re: Time format in SAS

Reeza — Fri, 11 Dec 2015 01:59:10 GMT

Use the minute and second function to get the individual components and add them together. Time is stored as seconds so you can't straight apply a format.

Re: Time format in SAS

PGStats — Fri, 11 Dec 2015 04:34:22 GMT

You can convert time values into number of hours by dividing time by the duration of an hour:

hours = time / '01:00:00't;