topic Re: Yesterdays Date in SAS Procedures

Yesterdays Date

Fleroo — Thu, 25 Jul 2013 11:39:16 GMT

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.

Re: Yesterdays Date

OS2Rules — Thu, 25 Jul 2013 12:32:59 GMT

Try:

%let preday=%sysfunc(date()-1, date9.);

Re: Yesterdays Date

Fleroo — Thu, 25 Jul 2013 12:42:55 GMT

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.

Re: Yesterdays Date

BrunoMueller — Thu, 25 Jul 2013 12:43:41 GMT

Fleroo

Check this code:

%let curday=%sysfunc(PUTN(%eval(%sysfunc(date()) - 1), date9.));
%put NOTE: &=curday;

Re: Yesterdays Date

OS2Rules — Thu, 25 Jul 2013 12:47:03 GMT

My Bad:

use:

CALL SYMPUT('predte',put(date()-1.date9.));

Re: Yesterdays Date

Fleroo — Thu, 25 Jul 2013 12:54:55 GMT

Bruno......... BANG. YOU NAILED IT. Man you're good. Do you want to fly to Pennsylvania ? :smileylaugh:

THANKS ALL.... I LUV THIS BOARD

Re: Yesterdays Date

Haikuo — Thu, 25 Jul 2013 13:08:47 GMT

You can also use INTNX:

%let curday=%sysfunc(intnx(day,%sysfunc(date()), -1),date9.);

%put NOTE: &=curday;

Haikuo