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.
You can convert time values into number of hours by dividing time by the duration of an hour:
hours = time / '01:00:00't;
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
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.