Solved: Re: Convert the text time field into time8. - SAS Support Communities

🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.

Pyrite | Level 9

Pyrite | Level 9

Convert the text time field into time8.

Posted 07-18-2018 07:33 PM (1379 views)

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

1 ACCEPTED SOLUTION

Accepted Solutions

Super User

Super User

Re: Convert the text time field into time8.

Posted 07-18-2018 08:07 PM (1409 views) | In reply to zimcom

Time_num = input(time, hhmmss. );

fornat time_num time.;

View solution in original post

2 REPLIES 2

Super User

Super User

Re: Convert the text time field into time8.

Posted 07-18-2018 08:07 PM (1410 views) | In reply to zimcom

Time_num = input(time, hhmmss. );

fornat time_num time.;

Pyrite | Level 9

Pyrite | Level 9

Re: Convert the text time field into time8.

Posted 07-18-2018 08:28 PM (1362 views) | In reply to Reeza

Thank you, Reeza

April 27 – 30 | Gaylord Texan | Grapevine, Texas

Registration is open

Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!

Call for Content EXTENDED

Still thinking about your presentation idea? The submission deadline has been extended to Friday, Nov. 14, at 11:59 p.m. ET.

Submit your proposal!