topic Format to Time from Character in SAS Visual Analytics

Format to Time from Character

BlueBrazil — Tue, 22 Dec 2015 14:10:19 GMT

I have a field with a value nn:nn:nn.nnn where the 1st nn is Hours, the 2nd nn is Minutes and the 3rd nn is Seconds. I need to convert it to aTIME field.

Re: Format to Time from Character

mohamed_zaki — Tue, 22 Dec 2015 14:39:29 GMT

data new;
input x hhmmss.; /* or time.*/
cards;
16:24:46.321
16:24:43.331
16:24:43.111
16:24:43.345
;run;

proc print data=new;
run;