topic Re: how to get info(milliseond) after second?! in SAS Programming

how to get info(milliseond) after second?!

hellohere — Mon, 28 Feb 2022 10:30:29 GMT

Read in CSV format file with time information, with format TIME20.3.

The time column has millisecond, like 9:15:30:050 (050 is the millisecond).

Here are hour/minute/second functions to use. Any function to fetch the millisecond information ?!

hellohere — Mon, 28 Feb 2022 11:06:16 GMT

second() can do that, actually.

Ksharp — Mon, 28 Feb 2022 12:13:02 GMT

Try MOD() function:

millisecond=mod( time ,1);

Kurt_Bremser — Mon, 28 Feb 2022 14:04:57 GMT

Does your time string actually look like this:

9:15:30:050

The default TIME informat cannot read this, because of the semicolon between the seconds and the fractional part.

So I ask: is this a typo, or do we need to take care of this non-standard time format?

Sajid01 — Tue, 01 Mar 2022 00:28:07 GMT

The time values should have a decimal point and not semicolon before milliSeconds.
With that the following code will work

data test;
informat tm time20.3;
format tm time20.3;
input tm;
time_milliS=mod(tm,1);
datalines;
9:15:30.050
;;

hellohere — Tue, 01 Mar 2022 07:19:17 GMT

Yeah， you guys are right. it is . not :