topic Re: What's %extora(&extdate) in SAS Programming

What's %extora(&extdate)

ywon111 — Wed, 12 Jan 2022 05:39:12 GMT

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

Re: What's %extora(&extdate)

andreas_lds — Wed, 12 Jan 2022 06:08:44 GMT

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

Re: What's %extora(&extdate)

ywon111 — Wed, 12 Jan 2022 06:37:52 GMT

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

Re: What's %extora(&extdate)

SASKiwi — Wed, 12 Jan 2022 07:17:41 GMT

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.

Re: What's %extora(&extdate)

andreas_lds — Wed, 12 Jan 2022 10:32:20 GMT

@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.