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
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.