What's %extora(&extdate)

[ywon111]

Hi, I have a code as below and extora is not referenced anywhere. Can anyone help what this means?

where %extora(&extdate);

Thanks in advance 

[andreas_lds]

The macro sas-extora is called in the where statement, the value of the macro variable extdate is passed to the macro.

[ywon111]

Thanks for the reply. I am stuck at trying to figure out what the %extora macro does. Thanks

[SASKiwi · Accepted solution]

Add this statement before you run it - options mprint; - then check the log for what it shows. At a guess it is generating an Oracle-specific date filter.

[andreas_lds]

---

@ywon111 wrote:

Thanks for the reply. I am stuck at trying to figure out what the %extora macro does. Thanks

---

Impossible to answer without seeing the source code of that macro and the time to read it.