topic Datetime, adding time, minutes, ... in SAS Programming

Datetime, adding time, minutes, ...

Filipvdr — Tue, 30 Aug 2011 14:17:52 GMT

I got the following problem:

It works when varA = month, day, ... but the function intnx needs a datetime when varA is hour.

I got a date: 29AUG2011:17:15:00

I got a varA: HOUR

I got a varB: 10

What I want is new data = date + 10 HOUR

if Postunit eq 'HOUR' then do;

OD1 = put(intnx(varA,date,varB,'same'),datetime20.);

end;

else do;

OverDueTime = input(put(intnx(varA,datepart(date),varB,'same'),date9.)||':'||put(timepart(date),time8.),datetime20.);

end;

I hope my queston is clear..

Datetime, adding time, minutes, ...

art297 — Tue, 30 Aug 2011 14:35:46 GMT

From your post I'm not sure what problem you are confronting. Is the data you have in the field you call "date" a text field, as sas date, or a sas datetime?

If the field is already either a sas date or sas datetime field, then it is simply a number representing either the number of days since Jan 1, 1960 or the number of seconds since Jan 1, 1960.

If you are changing a date field to be a date time field, make sure that you also change the field's format accordingly.

Datetime, adding time, minutes, ...

Filipvdr — Tue, 30 Aug 2011 14:41:02 GMT

It is already a datetime.

When I calculate this, it adds the hours correctly but there are no minutes anymore.

got a date: 29AUG2011:17:15:00

I got a varA: HOUR

I got a varB: 10

OD1 = put(intnx(Postunit,PlannedSchedTime,postval,'same'),datetime20.);

Result = 30AUG2011:05:00:00

Datetime, adding time, minutes, ...

art297 — Tue, 30 Aug 2011 14:48:02 GMT

I can't test your code at the moment, thus will offer an alternative. Rather than using the intnx function, why don't you just add 36,000 (i.e., 60*60*10) to the field? That will increase the datetime by exactly 10 hours.

Datetime, adding time, minutes, ...

art297 — Tue, 30 Aug 2011 14:55:15 GMT

Alternatively, as I look at your code, don't you need to specify the time shift as dthour rather than just hour?

Datetime, adding time, minutes, ...

Howles — Wed, 31 Aug 2011 12:50:46 GMT

I get the expected result ...

475 data _null_ ;

476 PlannedSchedTime = '29AUG2011:17:15:00'dt ;

477 Postunit = 'HOUR' ;

478 postval = 10 ;

479 OD1 = put(intnx(Postunit,PlannedSchedTime,postval,'same'),datetime20.);

480 put od1= ;

481 run ;

OD1=30AUG2011:03:15:00

Filipvdr wrote:

It is already a datetime.

When I calculate this, it adds the hours correctly but there are no minutes anymore.

got a date: 29AUG2011:17:15:00

I got a varA: HOUR

I got a varB: 10

OD1 = put(intnx(Postunit,PlannedSchedTime,postval,'same'),datetime20.);

Result = 30AUG2011:05:00:00

Datetime, adding time, minutes, ...

art297 — Wed, 31 Aug 2011 13:13:45 GMT

Howard,

I get the correct result as well, but the documentation is quite clear that one is supposed to/must use the dt prefix for datetime values. It might work differently on different systems.

Datetime, adding time, minutes, ...

Howles — Wed, 31 Aug 2011 22:18:30 GMT

That would be the tidy way, but I think a Time hour and a DateTime hour both have 3600 seconds.

art297 wrote:

Howard,

I get the correct result as well, but the documentation is quite clear that one is supposed to/must use the dt prefix for datetime values. It might work differently on different systems.

Datetime, adding time, minutes, ...

art297 — Wed, 31 Aug 2011 23:11:47 GMT

Howard,

Of course I can't disagree with your logic. And, similarly, day, month and year don't increment the same with dates and datetimes, and will produce an error if used with datetime.

However, since the OP stated that he/she got an incorrect result using a non-DT indicator when using intnx on a datetime field, I simply wonder if the logic holds for all systems.

I think it would be safer to simply precede all indicators with DT if the field to be incremented is a datetime field, and that would be consistent with the documentation.