Time format in SAS

[AY2]

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.

[Reeza · Accepted solution]

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.

[PGStats]

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

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