How can i convert value in time8. format to numeric ?
Please write if you need more clarification
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
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
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.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.