How to convert time8. to numeric value

[nikunjgattani]

How can i convert value in time8. format to numeric ?

Please write if you need more clarification

[paulkaefer · Accepted solution]

SAS time values are numeric, meaning you can do math on them.

That said, try something like this. You can change 8. to another numeric format.

data WORK.time_test;
    format time time8.;
    time = "14:04:46"t;
    put time;
    format time2 8.;
    time2 = time;
run;

Output data set:

time            time2

14:04:46    50686

[ballardw]

There are a number functions SAS provides to manipulate Time and date values such as INTNX (increment values); INTCK (return intervals); HOUR, MINUTE and SECOND to return the hour, minute or seconds value from a Time varialbe; M HMS to create a time value from hour, minute and second values.

There are also a number of different SAS supplied formats to display time values with different appearance and Proc Format can create custom formats to display the values in others.