07-30-2012 03:10 PM
I redeveloping some ETL job from DB2 to SAS and having a problem. The previous work used MIDNIGHT_SECONDS (Returns an integer value in the range 0 to 86 400, representing the number of seconds between midnight and the time value specified in the argument.) clause which only could be used in DB2 and I am wondering if there is any way the achieve the same function in SAS using proc sql.
INT(MIDNIGHT_SECONDS(process_time)/900) AS timeslice
Need further help from the community? Please ask a new question.