I have a column, TimePlayed, and its value is in second. How do I convert that to hours. I used the function HOUR but I don't it give me the correct value.
Furthermore ,I have two columns indicating the start time and end time if there is any way to get hours played.
If timeplayed is in seconds then code:
hoursplayed = timeplayed/ 3600;
Do you need whole hours or fractions?
The HOUR function returns the value of the hour portion of a datetime or time variable. For your first example of StartTime the hour function would return 16.
You can use the function INTCK with two datetime variables to return the number of hour intervals but may not provide what your are looking for if you want fractions of an hour.
Thank you, it helps.
Or if you just want to see the number of seconds as the number of hours, use the time8. format on the number of seconds.
And if both of your variables are datetime you can subtract them to get a duration of time played which would be in seconds.
duration=end_time-start_time;
format duration time8.;
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.
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.