topic Re: How to apply macro to proc sql ? in SAS Programming

How to apply macro to proc sql ?

BETO — Sat, 26 Oct 2019 03:29:33 GMT

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

Re: How to apply macro to proc sql ?

BETO — Sat, 26 Oct 2019 03:31:08 GMT

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

Re: How to apply macro to proc sql ?

Kurt_Bremser — Sat, 26 Oct 2019 06:31:18 GMT

Don't overcomplicate it. Just use

where date = today() - 1

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

Re: How to apply macro to proc sql ?

BETO — Sat, 26 Oct 2019 17:05:50 GMT

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

Re: How to apply macro to proc sql ?

Kurt_Bremser — Sat, 26 Oct 2019 17:26:01 GMT

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