topic Re: Time stored as numeric displayed as hhmmss or hmmss - convert to time format in SAS Programming https://communities.sas.com/t5/SAS-Programming/Time-stored-as-numeric-displayed-as-hhmmss-or-hmmss-convert-to/m-p/163762#M31692 <HTML><HEAD></HEAD><BODY><P>input(put(num_time_var,z6.),B8601TM.)</P></BODY></HTML> Wed, 05 Feb 2014 11:32:31 GMT LinusH 2014-02-05T11:32:31Z Time stored as numeric displayed as hhmmss or hmmss - convert to time format https://communities.sas.com/t5/SAS-Programming/Time-stored-as-numeric-displayed-as-hhmmss-or-hmmss-convert-to/m-p/163761#M31691 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Im a dataset there is a time field, however, it is in numeric format but shown as hhmmss or hmmss.</P><P></P><P>So for 09:03:04 it will show 90304, for 17:03:04 it will show 170304. I would like to create a variable that would convert this to actual time format, however, I am finding it difficult because of the varying lengths.</P><P></P><P>Does anyone have a solution that would convert the numeric value 90304 to time value 9:03:04 &amp; also the numeric value 170304 to time value 17:03:04</P><P></P><P>Kind Regards,</P><P></P><P>Kevan</P></BODY></HTML> Wed, 05 Feb 2014 10:52:53 GMT https://communities.sas.com/t5/SAS-Programming/Time-stored-as-numeric-displayed-as-hhmmss-or-hmmss-convert-to/m-p/163761#M31691 cxkev 2014-02-05T10:52:53Z Re: Time stored as numeric displayed as hhmmss or hmmss - convert to time format https://communities.sas.com/t5/SAS-Programming/Time-stored-as-numeric-displayed-as-hhmmss-or-hmmss-convert-to/m-p/163762#M31692 <HTML><HEAD></HEAD><BODY><P>input(put(num_time_var,z6.),B8601TM.)</P></BODY></HTML> Wed, 05 Feb 2014 11:32:31 GMT https://communities.sas.com/t5/SAS-Programming/Time-stored-as-numeric-displayed-as-hhmmss-or-hmmss-convert-to/m-p/163762#M31692 LinusH 2014-02-05T11:32:31Z Re: Time stored as numeric displayed as hhmmss or hmmss - convert to time format https://communities.sas.com/t5/SAS-Programming/Time-stored-as-numeric-displayed-as-hhmmss-or-hmmss-convert-to/m-p/163763#M31693 <HTML><HEAD></HEAD><BODY><P>Thank you LinusH</P></BODY></HTML> Wed, 05 Feb 2014 12:55:46 GMT https://communities.sas.com/t5/SAS-Programming/Time-stored-as-numeric-displayed-as-hhmmss-or-hmmss-convert-to/m-p/163763#M31693 cxkev 2014-02-05T12:55:46Z