求助 如果转换时间

shiyiming

现有一列表示时间的变量格式如下
93859
142427
141917


如何将其转换为一般的时间格式，格式如下：
09：38：59
14：24：27
14：19：17

谢谢各位大大了

shiyiming

不确定原始的时间变量是字符的还是数值的,如果是数值的就不需要input()转换了
[code:2bb5gx1q]data raw;
        input time_chr $;
        time=hms(int(input(time_chr,best.)*.0001),
                        int(mod(input(time_chr,best.)*.01,100)),
                        mod(input(time_chr,best.),100));
        format time time8.;
datalines;
93859
142427
141917
;[/code:2bb5gx1q]

shiyiming

Unless you alread knew on the meaning and format of the numbers.
Like date values saved as numeric value that started from a specific date as 0, time values are also saved in  numeric started from the beginning of the day.

data test;
format time1 time8.;
time=time();
time1=time;
run;