topic Re: Convert a numeric value to time in hh:mm:ss:ms format in SAS Programming

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

cedre — Fri, 15 Feb 2019 17:58:45 GMT

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

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

ballardw — Fri, 15 Feb 2019 19:05:16 GMT

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

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

cedre — Fri, 15 Feb 2019 20:22:18 GMT

It works. Thanks.

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

Reeza — Fri, 15 Feb 2019 21:21:44 GMT

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

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

novinosrin — Fri, 15 Feb 2019 22:55:17 GMT

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