calculate time from datetime

[Ronein]

Hello

I have a data set with datetime column with format and informat datetimr22.3

I want to create a new column called time with time value and format time8.

I used the following code 

time(effectiveTimestamp) as time format=time8.

As I see the time values are not correct,

I see for example datetime 15MAY2024:03:02:08.977  and calculated time 14:17:42 but as I see it should be 03:02:08 

[PaigeMiller · Accepted solution]

Please read the description of the TIME function in the documentation.

On the left is an alphabetical list of all SAS functions; right below TIME is the function you want, TIMEPART.