01-02-2012 12:08 AM
I am trying to use Dateadd function in PROC SQL function . Though it is not supported in SAS.
DATEADD( "h",-1 (min(CPTR_TM)))
I want to fetch the dates which has 1 hour differenc. Please suggest some solution.
01-02-2012 01:19 AM
Use the intnx function. You can find its documentation at: http://support.sas.com/documentation/cdl/en/lrdict/64316/HTML/default/viewer.htm#a003065889.htm#a003...
01-02-2012 08:49 AM
I assume you mean a datetime value instead of a date value as dates do not have hours.
SAS stores datetime values in seconds so you could just add 3600 (60 minutes * 60 seconds) to the datetime value.