topic Time Format in SAS Programming

Time Format

cjohnson — Thu, 16 Apr 2009 20:26:13 GMT

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.

Re: Time Format

LinusH — Fri, 17 Apr 2009 06:48:45 GMT

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

Re: Time Format

Peter_C — Fri, 17 Apr 2009 09:22:01 GMT

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