topic Importing time in hh:mm format in SAS Procedures https://communities.sas.com/t5/SAS-Procedures/Importing-time-in-hh-mm-format/m-p/78254#M22595 <HTML><HEAD></HEAD><BODY><P>I have a dataset where time is recorded in hh:mm on a 24 hour clock.&nbsp; When I import this data I am importing as character due to the ":".</P><P></P><P>How can I convert this to time?</P><P>Once it is converted to time, how do I change it from a 24 hour clock to a 12 hour AM/PM format?</P><P></P><P>Thank in advance!</P><P></P><P>GST</P></BODY></HTML> Fri, 17 May 2013 13:45:12 GMT gstullo 2013-05-17T13:45:12Z Importing time in hh:mm format https://communities.sas.com/t5/SAS-Procedures/Importing-time-in-hh-mm-format/m-p/78254#M22595 <HTML><HEAD></HEAD><BODY><P>I have a dataset where time is recorded in hh:mm on a 24 hour clock.&nbsp; When I import this data I am importing as character due to the ":".</P><P></P><P>How can I convert this to time?</P><P>Once it is converted to time, how do I change it from a 24 hour clock to a 12 hour AM/PM format?</P><P></P><P>Thank in advance!</P><P></P><P>GST</P></BODY></HTML> Fri, 17 May 2013 13:45:12 GMT https://communities.sas.com/t5/SAS-Procedures/Importing-time-in-hh-mm-format/m-p/78254#M22595 gstullo 2013-05-17T13:45:12Z Re: Importing time in hh:mm format https://communities.sas.com/t5/SAS-Procedures/Importing-time-in-hh-mm-format/m-p/78255#M22596 <HTML><HEAD></HEAD><BODY><P>Use TIMEAMPM format.</P><P><A href="http://support.sas.com/documentation/cdl/en/lrdict/64316/HTML/default/viewer.htm#a000201272.htm" title="http://support.sas.com/documentation/cdl/en/lrdict/64316/HTML/default/viewer.htm#a000201272.htm">SAS(R) 9.2 Language Reference: Dictionary, Fourth Edition</A></P></BODY></HTML> Fri, 17 May 2013 14:50:55 GMT https://communities.sas.com/t5/SAS-Procedures/Importing-time-in-hh-mm-format/m-p/78255#M22596 Tom 2013-05-17T14:50:55Z Re: Importing time in hh:mm format https://communities.sas.com/t5/SAS-Procedures/Importing-time-in-hh-mm-format/m-p/78256#M22597 <HTML><HEAD></HEAD><BODY><P>Thanks.&nbsp; I just needed to convert the data from character to numeric first...</P></BODY></HTML> Mon, 20 May 2013 16:47:48 GMT https://communities.sas.com/t5/SAS-Procedures/Importing-time-in-hh-mm-format/m-p/78256#M22597 gstullo 2013-05-20T16:47:48Z