Convert a numeric value to time in hh:mm:ss:ms format

[cedre]

Hello

In the file attached, there is numeric value that I would like to convert into time in SAS. Please note that the time is to the milliseconds, hh:mm:ss:ms

thanks 

[ballardw]

---

@cedre wrote:

Hello

In the file attached, there is numeric value that I would like to convert into time in SAS. Please note that the time is to the milliseconds, hh:mm:ss:ms

thanks 

---

I think you need to provide some additional information.

For instance one of your example values is:

48600044

If that was collected as a number of milliseconds then dividing by 1000 would yield seconds. The result would be a duration in seconds, not an actual "time".

Maybe something along these lines:

data example;
   x=48600044;
   y=x/1000;
   format y time12.4;
run;

[cedre]

It works. Thanks. 

[Reeza · Accepted solution]

@cedre please mark the question as solved by selection @ballardw solution.

[novinosrin]

slick answer!!!!!!Kudos!!!!!!!