SAS Data Integration Studio, DataFlux Data Management Studio, SAS/ACCESS, SAS Data Loader for Hadoop and others

Macro variable for setting BF_PATH

Accepted Solution Solved
Reply
New Contributor Che
New Contributor
Posts: 3
Accepted Solution

Macro variable for setting BF_PATH

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.

 

 


Accepted Solutions
Solution
Thursday
SAS Super FREQ
Posts: 90

Re: Macro variable for setting BF_PATH

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

View solution in original post


All Replies
SAS Super FREQ
Posts: 90

Re: Macro variable for setting BF_PATH

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

New Contributor Che
New Contributor
Posts: 3

Re: Macro variable for setting BF_PATH

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.

 

 

 

Solution
Thursday
SAS Super FREQ
Posts: 90

Re: Macro variable for setting BF_PATH

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

New Contributor Che
New Contributor
Posts: 3

Re: Macro variable for setting BF_PATH

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

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 4 replies
  • 179 views
  • 0 likes
  • 2 in conversation