topic datetime fields -1day is causing time to be 00:00.00 in SAS Procedures

datetime fields -1day is causing time to be 00:00.00

LeeJ — Thu, 06 Oct 2011 14:08:42 GMT

Hi ,

I would like a date one day away from the value in a datetime field. My new field is getting created with one day subtracted but all of the times are not preserved. They all get set to 00:00:00.

newdt2=intnx('dtday',datetime(),-1) ;

newdt1=intnx('dtday',mydatetimefield,-1) ;

What am I doing wrong?

Thanks

Lee

datetime fields -1day is causing time to be 00:00.00

art297 — Thu, 06 Oct 2011 14:13:22 GMT

You are leaving off one parameter, namely 's', to keep the time the same. i.e.,

newdt2=intnx('dtday',datetime(),-1,'s') ;

datetime fields -1day is causing time to be 00:00.00

Doc_Duke — Thu, 06 Oct 2011 14:16:14 GMT

You are doing nothing wrong. Check the "alignment" documentation for intnx.

http://support.sas.com/documentation/cdl/en/lefunctionsref/63354/HTML/default/viewer.htm#p10v3sa3i4kfxfn1sovhi5xzxh8n.htm

The "old fashioned" way to subtract one day from a datetime variable is to simply subtract 1 day's worth of seconds.

newdt = olddt - 24*60*60;

Doc Muhlbaier

Duke