- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Posted 01-24-2018 05:51 AM
(7267 views)
Hi ,
Is there an easy way to convert time values in time5. format into nominal time values.?
Example: 8:30 as 8.5
16:30 as 16.5
17:45 as 17.75
2 REPLIES 2
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
One way:
data want; time="08:30"t; number=hour(time)+ ((10 / (60/minute(time)))/10); output; time="17:45"t; number=hour(time)+ ((10 / (60/minute(time)))/10); output; format time time5.; run;
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Since time values are just counts of seconds, a simple division and rounding will do it:
data test;
input time time5.;
time_nom = round(time/3600,.01);
format
time time5.
time_nom 5.2
;
cards;
08:30
16:30
17:45
;
run;