Hello, you folks helped me out immensely with figuring out how to turn the date of 1/1/1960 into a real date to be stored in an Oracle table. I have another question on how to turn that date, which is the CURRENT date, into the PREVIOUS days date. The following is the code. * This gets the current Date. %let curday=%sysfunc(date(), date9.); %put &curday; * This loads the records into an Oracle table. the date portion hos_date is the date 7/25/2013 12:01:01 PM. I want it to be Yesterday's Date of 7/24/2013 12:01:01 PM proc sql; insert into safety.safety_hrs_svc select dhms("&curday"d,12,01,01) as hos_date, STATION, CONTR_ID, CONTR_NAME, PRIM_SVC_AREA_ID, DRIVER_NBR, DRIVER_NAME, PCK_DELV_HRS, SPOT_HRS, LINEHAUL_HRS from work.safety_hrs; quit; Thank you very much.
... View more