topic Re: read hh:mm:ss.nnn in SAS Studio

read hh:mm:ss.nnn

gnrslasher37 — Fri, 10 Jun 2016 12:11:11 GMT

I have time data in format of hh:mm:ss:nnn. How can i read the data with interval of a minute from that data where nano seconds are inclusive.

Thanks,

Gobin

Re: read hh:mm:ss.nnn

Kurt_Bremser — Fri, 10 Jun 2016 12:32:57 GMT

Use the INTNX function to increment by 'minute'. Edit: with alignment 'same'!

If your value is still stored in a character variable, use the time12.3 informat for conversion before applying the intnx function.

Re: read hh:mm:ss.nnn

gnrslasher37 — Sat, 11 Jun 2016 09:14:06 GMT

Thanks for the previous one. Further, is it possible to get the millisecond
value from hh:mm:ss.nnn time format in SAS. Actually i have the data that
differs on that milliseconds.

##- Please type your reply above this line. Simple formatting, no
attachments. -##

Re: read hh:mm:ss.nnn

Kurt_Bremser — Sat, 11 Jun 2016 13:18:41 GMT

If you used the time12.3 as informat, your SAS time value will contain the milliseconds after the decimal point.

To extract only the milliseconds, do

milsecs = (timeval - int(timeval)) * 1000;

Re: read hh:mm:ss.nnn

Sousa — Mon, 08 Oct 2018 15:47:05 GMT

@Kurt_Bremser Thank you very much!! This helped. the key 'same'