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.
Bruno......... BANG. YOU NAILED IT. Man you're good. Do you want to fly to Pennsylvania ? :smileylaugh:
THANKS ALL.... I LUV THIS BOARD
Try:
%let preday=%sysfunc(date()-1, date9.);
OS2, that generates the following error..... cut from the log.
11 %let prevday=%sysfunc(date()-1, date9.);
ERROR: Expected close parenthesis after macro function invocation not found.
Thanks so much for looking.
My Bad:
use:
CALL SYMPUT('predte',put(date()-1.date9.));
Fleroo
Bruno......... BANG. YOU NAILED IT. Man you're good. Do you want to fly to Pennsylvania ? :smileylaugh:
THANKS ALL.... I LUV THIS BOARD
You can also use INTNX:
%let curday=%sysfunc(intnx(day,%sysfunc(date()), -1),date9.);
%put NOTE: &=curday;
Haikuo
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.
Select SAS Training centers are offering in-person courses. View upcoming courses for: