topic Re: time factors in SAS Programming

time factors

tobyfarms — Mon, 01 May 2017 14:29:33 GMT

I'm trying to capture the factor for each hour in the day, showing hours less than time should equal 0. so for the 1st line, hours 1-6 should equal 0, then hour 7 will take the minute/60.

*then completing this formula for every row in the dataset.

Date Time Minute

01JAN2017   07:38     38
01JAN2017   17:04     04
02JAN2017   07:38    38
02JAN2017   17:05    05

Re: time factors

thomp7050 — Mon, 01 May 2017 14:33:52 GMT

Sorry, could you put "have" and "want" datasets, so that we can see the desired outcome for each of your circumstances?

Re: time factors

ballardw — Mon, 01 May 2017 14:43:07 GMT

Before we go too far down suggestions are any of your date or time variables SAS date or time values or character?

Re: time factors

tobyfarms — Mon, 01 May 2017 14:58:01 GMT

Thanks! time fields are of character settings.

Re: time factors

mkeintz — Mon, 01 May 2017 15:06:26 GMT

@tobyfarms wrote:

I'm trying to capture the factor for each hour in the day, showing hours less than time should equal 0. so for the 1st line, hours 1-6 should equal 0, then hour 7 will take the minute/60.

*then completing this formula for every row in the dataset.

Date            Time   Minute

01JAN2017   07:38     38
01JAN2017   17:04     04
02JAN2017   07:38    38
02JAN2017   17:05    05

I guess what you want is to create multiple output records for each input record, with one record for each hour from 0 (or maybe from 1) through the hour component of your time variable. And new var factor=0 for all hours except the last, when factor equals the fraction of minutes into that hour. If so ...

data want;

set have;

hmax=input(scan(time,1,':'),2.);

factor=0;

if hmax>0 then do hour=0 to hmax-1;

output;

end;

hour=hmax;

factor = input(minute,2.)/60; /*Assuming MINUTE is a character variable */

output;

run;

Re: time factors

tobyfarms — Tue, 02 May 2017 12:57:53 GMT

Thank you! I get slightly closer with that. What I am trying to do is take time (this time is an imported field and not date/time format) and hit it compared across a 24hr timeline.

The equation should be similar to :

If ('TIME' > 'Hour',then 0,else 'Minute')

TIME	minute	HOUR	1	2	3	4	5	6	7	8	9	10	11	12
07:38	38		0	0	0	0	0	0	0	38	38	38	38	38

The next step would be to divide the minute by 60 to create a factor.

Thanks again for all of your help thus far!!