DATA Step, Macro, Functions and more

How to convert time8. to numeric value

Accepted Solution Solved
Reply
Contributor
Posts: 22
Accepted Solution

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: 159

Re: How to convert time8. to numeric value

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

View solution in original post


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

Re: How to convert time8. to numeric value

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: 10,483

Re: How to convert time8. to numeric value

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
  • 1010 views
  • 2 likes
  • 3 in conversation