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.
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?