DATA Step, Macro, Functions and more

Time Format

Reply
Frequent Contributor
Posts: 97

Time Format

I have a dataset with character data in the format mm:ss.ss (i.e. 1:11.29). I am trying to get this converted to a time format. I have tried the Informat TIME11.2, which works for times of less than a minutes, but when minutes are present, it returns null. Any help appreciated.
Christopher Johnson
www.codeitmagazine.com
Super User
Posts: 5,257

Re: Time Format

I don't it works for your ss.ss values either. The TIME: informat will interpret them as hh.mm.

This is a bit annoying, I have hoped for the time informat (or any other informat) to more sophisticated. Maybe try to fix the time string so it will always contain hours and minutes, before converting them to SAS time values?

/Linus
Data never sleeps
Valued Guide
Posts: 2,175

Re: Time Format

try the informat STIMER.
documented at http://support.sas.com/documentation/cdl/en/lrdict/61724/HTML/default/a002295695.htm .

located by the format hunter ;-)

PeterC
Ask a Question
Discussion stats
  • 2 replies
  • 106 views
  • 0 likes
  • 3 in conversation