how to get info(milliseond) after second?!

[hellohere]

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]

second() can do that, actually.

[Ksharp · Accepted solution]

Try MOD() function:

millisecond=mod( time ,1);

[Kurt_Bremser]

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?

[hellohere]

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

[Sajid01]

Hello @hellohere 

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
;;