topic Re: Macro for yesterday's date using sysfunc and datetime22.3 format in SAS Programming

Macro for yesterday's date using sysfunc and datetime22.3 format

ksachar — Wed, 20 Jan 2016 14:27:47 GMT

I want to create a global macro for yesterdays date using sysfunc (without using today() ). And I want the output in datetime22.3 format. Couldn't figured out by myself.

Re: Macro for yesterday's date using sysfunc and datetime22.3 format

data_null__ — Wed, 20 Jan 2016 14:36:52 GMT

1975  %put NOTE: %sysfunc(intnx(DTDAY,%sysfunc(datetime()),-1,same),datetime22.3);
NOTE: 19JAN2016:06:36:11.653

Re: Macro for yesterday's date using sysfunc and datetime22.3 format

RW9 — Wed, 20 Jan 2016 14:42:57 GMT

Sorry, couple of questions:

Why do you need to keep a macro variable with today()-1, what is wrong with just using that?

Why can you not use today() function which does this processing, why try to re-implement it?

To put it in the log do:

%put %sysfunc(today(),datetime22.0);

Re: Macro for yesterday's date using sysfunc and datetime22.3 format

ksachar — Wed, 20 Jan 2016 16:05:28 GMT

Thanks. I just tried and I got the following output: 19JAN2016:11:03:57.512. Is there anyway I can get 19JAN2016:00:00:00.000 as an output. I want to oull up all the transaction from the begining of the day yesterday.

Thanks once again.

Re: Macro for yesterday's date using sysfunc and datetime22.3 format

data_null__ — Wed, 20 Jan 2016 16:09:55 GMT

2027  %put NOTE: %sysfunc(intnx(DTDAY,%sysfunc(datetime()),-1,begin),datetime22.3);
NOTE: 19JAN2016:00:00:00.000

You might want to read about INTNX

Re: Macro for yesterday's date using sysfunc and datetime22.3 format

ksachar — Wed, 20 Jan 2016 16:11:13 GMT

I got the following output when I used your code.

01JAN1960:05:41:13

I hoep thats answers the question why I prefer using sysfunc.

Re: Macro for yesterday's date using sysfunc and datetime22.3 format

ksachar — Wed, 20 Jan 2016 16:12:26 GMT

Thanks.

Re: Macro for yesterday's date using sysfunc and datetime22.3 format

RW9 — Wed, 20 Jan 2016 17:10:20 GMT

Not really, you didn't mention that in the original request. You can merely modify the code slightly:

%put %sysfunc(today(),date9.):00:00:00.000;

Re: Macro for yesterday's date using sysfunc and datetime22.3 format

Kurt_Bremser — Thu, 21 Jan 2016 07:09:18 GMT

Another method:

data _null_;
call symput('yesterday',put((today()-1)*86400,datetime22.3));
run;