Hi all,
How can I convert the time_1, time_2 and time_3 into time8. format?
SUBJECT | time_1 | time_2 | time_3 |
117961 | 18:49 | 19:02 | 19:20 |
118036 | 15:03 | 15:35 | 15:50 |
118066 | 19:40 | 20:10 | 20:15 |
118118 | 0:04 | 0:25 | 0:49 |
118151 | 23:06 | 23:30 | 23:40 |
118377 | 9:18 | 9:39 | |
118682 | 14:39 | 15:06 | |
118730 | 12:45 | 13:04 | 13:22 |
118872 | 18:00 | 18:23 | 18:49 |
118874 | 16:11 | 16:18 | 16:56 |
118875 | 15:52 | 16:15 | 16:27 |
119054 | 23:51 | 0:06 | 0:18 |
119121 | 15:04 | 15:15 | 15:34 |
119495 | 11:42 | 12:13 | 12:25 |
119555 | 13:00 | 12:59 | 13:11 |
119621 | 18:32 | 18:48 | 19:05 |
119651 | 8:20 | 8:41 |
Time_num = input(time, hhmmss. );
fornat time_num time.;
Thank you, Reeza
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.