Solved
Contributor
Posts: 29

# How to convert time8. to numeric value

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

Please write if you need more clarification

Accepted Solutions
Solution
‎09-23-2016 11:01 AM
Regular Contributor
Posts: 215

## Re: How to convert time8. to numeric value

Posted in reply to nikunjgattani

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

All Replies
Solution
‎09-23-2016 11:01 AM
Regular Contributor
Posts: 215

## Re: How to convert time8. to numeric value

Posted in reply to nikunjgattani

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

Super User
Posts: 13,523

## Re: How to convert time8. to numeric value

Posted in reply to nikunjgattani

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.

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
• 2 replies
• 1886 views
• 2 likes
• 3 in conversation