topic Re: Macro variable for setting BF_PATH in SAS Data Management

Macro variable for setting BF_PATH

Che — Thu, 10 Aug 2017 13:56:43 GMT

Hello,

I am using macro variable for passing BF_PATH or QKB path.We pass this macro variable through a variable section of our real time service request.Macro variable value is set perfectly if we call a simple Data Job but when we call another data job using data reference node macro variable value is not set in any of the Data Quality nodes. Instead it uses defalut QKB.

Has anyone experienced this behaviour and if yes do we know solution to this problem or any workaround?

My end goal is to pass QKB path to all DQ nodes in parent data job as well as Data job it references.

Re: Macro variable for setting BF_PATH

RonAgresta — Tue, 15 Aug 2017 18:13:44 GMT

Try the following: using the KEY_VALUES property in the advanced properties dialog of the Data Job (reference) node, add values as follows for each macro you want to pass through:

KEY = the name of the macro in the inner (or referenced) job
VALUE = the value passed in as a macro from the parent job, surrounded by %% like so: %%MyMacro%%

Ron

Re: Macro variable for setting BF_PATH

Che — Tue, 15 Aug 2017 18:45:16 GMT

Thanks Ron!

Appreciate your response.I will give it a try and confirm if it works.Do you have any detail document that describes this parameter?

When I looked at SAs help document it doesn't give much information on this parameter.

Re: Macro variable for setting BF_PATH

RonAgresta — Wed, 16 Aug 2017 18:05:20 GMT

It's an advanced topic that's probably not as well documented as it could be. I'll be sure to let our documentation team know we could use some examples in this area.

Ron

Re: Macro variable for setting BF_PATH

Che — Thu, 17 Aug 2017 14:24:54 GMT

Ron,

Thanks a bunch.Looks like using Key_values parameter has resolved our issue of passing macro variable value in an embedded job.

I am still doing testing to make sure it works in all of our scenarios but all the basic tests ran fine.

Regards,

Chetan