topic Re: converting times from character to 24-hour in SAS Programming https://communities.sas.com/t5/SAS-Programming/converting-times-from-character-to-24-hour/m-p/150411#M29685 <HTML><HEAD></HEAD><BODY><P>Something along the lines of the following should work:</P><P></P><P>time_num=input(char_time, time12.);</P><P>format time_num time.;</P></BODY></HTML> Tue, 05 Aug 2014 22:12:35 GMT Reeza 2014-08-05T22:12:35Z converting times from character to 24-hour https://communities.sas.com/t5/SAS-Programming/converting-times-from-character-to-24-hour/m-p/150410#M29684 <HTML><HEAD></HEAD><BODY><P>I have times that are character fields in the format x:xx PM/AM, for example, 1:30 PM and 10:30 AM.</P><P>How can I convert these character fields into numeric fields that display 24-hour time? For example, change 1:00 PM to 13:00.</P></BODY></HTML> Tue, 05 Aug 2014 21:54:11 GMT https://communities.sas.com/t5/SAS-Programming/converting-times-from-character-to-24-hour/m-p/150410#M29684 gzr2mz39 2014-08-05T21:54:11Z Re: converting times from character to 24-hour https://communities.sas.com/t5/SAS-Programming/converting-times-from-character-to-24-hour/m-p/150411#M29685 <HTML><HEAD></HEAD><BODY><P>Something along the lines of the following should work:</P><P></P><P>time_num=input(char_time, time12.);</P><P>format time_num time.;</P></BODY></HTML> Tue, 05 Aug 2014 22:12:35 GMT https://communities.sas.com/t5/SAS-Programming/converting-times-from-character-to-24-hour/m-p/150411#M29685 Reeza 2014-08-05T22:12:35Z Re: converting times from character to 24-hour https://communities.sas.com/t5/SAS-Programming/converting-times-from-character-to-24-hour/m-p/150412#M29686 <HTML><HEAD></HEAD><BODY><P>You use a SAS INFORMAT to convert a character string to a SAS date or time or datetime value <A class="active_link" href="http://support.sas.com/documentation/cdl/en/leforinforref/63324/HTML/default/viewer.htm#n0verk17pchh4vn1akrrv0b5w3r0.htm" title="http://support.sas.com/documentation/cdl/en/leforinforref/63324/HTML/default/viewer.htm#n0verk17pchh4vn1akrrv0b5w3r0.htm">SAS(R) 9.3 Formats and Informats: Reference</A></P><P></P><P>You then apply a SAS FORMAT to this SAS date/time/datetime value so that it prints the way you want to.</P></BODY></HTML> Tue, 05 Aug 2014 22:53:41 GMT https://communities.sas.com/t5/SAS-Programming/converting-times-from-character-to-24-hour/m-p/150412#M29686 Patrick 2014-08-05T22:53:41Z Re: converting times from character to 24-hour https://communities.sas.com/t5/SAS-Programming/converting-times-from-character-to-24-hour/m-p/150413#M29687 <HTML><HEAD></HEAD><BODY><P>This works. Thank you.</P></BODY></HTML> Tue, 05 Aug 2014 22:58:26 GMT https://communities.sas.com/t5/SAS-Programming/converting-times-from-character-to-24-hour/m-p/150413#M29687 gzr2mz39 2014-08-05T22:58:26Z