How to apply macro to proc sql ?

[BETO]

Hi i have this code gives me date.
PUT %SYSFUNC(PUTN(%SYSFUNC(INTNX(DAY,%SYSFUNC(TODAY()),-1)),date9.)) 24ocr2019

How can i spply that to my proc sql
From table
Where date = ? Here is where i would like to make refer to the macro thank you

[BETO]

I currently have a date between '12oct2019'd and '18oct2019'd;

[Kurt_Bremser · Accepted solution]

Don't overcomplicate it. Just use

where date = today() - 1

(dates are counts of days, so today() - 1 gives you yesterday's date)

[BETO]

KurtBremser. I tried that and it brings back 0 entries when i use between '12oct2019'd and '18oct2019'd; it brings in data ... sorry selected accept solution when i wanted to reply

[Kurt_Bremser]

Please post your whole code. Use the "little running man" icon for posting code.