Hello Tom Of course the use of array and vvaluex are ideal solutions. I was wondering if we could take the distinct of name and val so that we have macro variables created which has the VAL corresponding to name. BR ... View more

Hello Koen, thank you for the response. Do we have an alternate solution utilizing macro variables ? ... View more

Thanks for the clarification Patrick 🙂 ... View more

Hi Gosten... Thanks for the response and welcome to the group 🙂   Below statement of your helps... For the insurance policy, validating the correct combination of Business keys for generating RK is the challenge I have .. it all depends on the source details though... agree .. let me know if you have some standard model with the business key details for each DDS table that could be referred... I undersatnd that it might not be appropriate for all cases though   In case of the insurance_policy table the policy_rk can be generated based on any unique combination of non-key attributes (excludes policy_rk and valid_from_dttm)  that are candidates for a unique business key, and this can be different from customer to customer. For instance, policy_no could be a unique business key for one customer, and yet for another customer policy_no + policy_version might represent a unique policy identifier     ... View more

Hi Patrick, "Build a SAS service which you can call via HTTP request and which returns the value of the SAS macro variable back to DataFlux)" should solve the problem...Let me know if you could send a good link which directs me to the process to call a SAS services from Dataflux... and also I think SAS should look into integrating both DF and SAS services to solve so many such issues ....       Best Regards, Sandeep   ... View more

Thanks Chris, but this is a way to create a macro in SAS code node... but I want a solution to get the same macro value in DF ... View more

Hi Patrick,   Thanks for the response... Kindly find more information on my ticket in the above post. In fact... i don't want to call any service in DF, instead I would like to get the value  of macro variable defined @ Autoexec.sas into DF    Best Regards, Sandeep   ... View more

Thanks for responding Chris:   Following are the details:   I am using DataFlux Data Management Studio To be more clear... I have created a global variable in autoexec.sas , so I have this macro variable available in every session of the Data Integration Studio.... how could I get the value of this global variable in every session of DF . Is there a way macro variable could be shared between SAS BI and DF?   Thanks, Sandeep ... View more