topic Re: expressing minutes as a fraction in SAS Programming

expressing minutes as a fraction

frisco — Wed, 28 Nov 2012 15:11:41 GMT

Is there an easy and straightforward way to express a datetime value as a fraction? For example 1:15PM would be 1.25

Re: expressing minutes as a fraction

art297 — Wed, 28 Nov 2012 15:28:48 GMT

Since time is just the number of seconds since midnight, you just have to divide by 60*60. Although, doing that would give you 13.25 rather than 1.25, but would allow you to differentiate between 1:15am and 1:15pm.

e.g.:

data have;

informat dt anydtdtm21.;

input dt;

fraction=timepart(dt)/(60*60);

cards;

28nov2012:01:15:00

28nov2012:13:30:00

;

Re: expressing minutes as a fraction

ballardw — Wed, 28 Nov 2012 20:27:47 GMT

or fractiontime = hour(datetimevariable) + minute(datetimevariable)/60;

if you don't want hour 13 to 23, ignoring AM/Pm

fractiontime = mod(hour(datetimevariable),12) + minute(datetimevariable)/60;

Re: expressing minutes as a fraction

data_null__ — Wed, 28 Nov 2012 20:53:08 GMT

Perhaps you want HOUR format http://support.sas.com/documentation/cdl/en/leforinforref/63324/HTML/default/viewer.htm#p1ajv0kbaa42vgn1ay7en84w8aev.htm

you will need to separate the time from the datetime.

Re: expressing minutes as a fraction

jsasusr — Wed, 18 Nov 2015 21:36:23 GMT

This worked closer to my problem without the formatting:

NOTE. My field "Hours" was formatted as time5.

So....

data crsefile;

set crsefile;

hoursdec=timepart(hours)/(60*60);

run;

So hours 1:55 became 1.9166666667