🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
Calcite | Level 5

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

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

1 ACCEPTED SOLUTION

Accepted Solutions
Super User

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

@cedre please mark the question as solved by selection @ballardw solution.
4 REPLIES 4
Super User

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

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

Calcite | Level 5

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

It works. Thanks.

Super User

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

@cedre please mark the question as solved by selection @ballardw solution.
Tourmaline | Level 20