DATA Step, Macro, Functions and more

Time stored as numeric displayed as hhmmss or hmmss - convert to time format

Accepted Solution Solved
Reply
Contributor
Posts: 28
Accepted Solution

Time stored as numeric displayed as hhmmss or hmmss - convert to time format

Hi,

Im a dataset there is a time field, however, it is in numeric format but shown as hhmmss or hmmss.

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.

Does anyone have a solution that would convert the numeric value 90304 to time value 9:03:04 & also the numeric value 170304 to time value 17:03:04

Kind Regards,

Kevan


Accepted Solutions
Solution
‎02-05-2014 06:32 AM
Super User
Posts: 5,260

Re: Time stored as numeric displayed as hhmmss or hmmss - convert to time format

input(put(num_time_var,z6.),B8601TM.)

Data never sleeps

View solution in original post


All Replies
Solution
‎02-05-2014 06:32 AM
Super User
Posts: 5,260

Re: Time stored as numeric displayed as hhmmss or hmmss - convert to time format

input(put(num_time_var,z6.),B8601TM.)

Data never sleeps
Contributor
Posts: 28

Re: Time stored as numeric displayed as hhmmss or hmmss - convert to time format

Thank you LinusH

🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 475 views
  • 0 likes
  • 2 in conversation