topic Re: How to convert time8. to numeric value in SAS Programming

How to convert time8. to numeric value

nikunjgattani — Fri, 23 Sep 2016 13:58:42 GMT

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

Please write if you need more clarification

Re: How to convert time8. to numeric value

paulkaefer — Fri, 23 Sep 2016 14:09:36 GMT

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

Re: How to convert time8. to numeric value

ballardw — Fri, 23 Sep 2016 14:46:35 GMT

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.