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

[ksachar]

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. 

[data_null__]

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

[ksachar]

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. 

[data_null__ · Accepted solution]

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

[ksachar]

Thanks.

[RW9]

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);

[ksachar]

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. 

[RW9]

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;

[Kurt_Bremser]

Another method:

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