Hi all,
I want to create a dynamic loop in Dataflux and I want to ask if is it possible?
The logic that I want to use is similar with the Data integration Studio logic (Control table - Loop).
First of all I will create a control table with the variables that I want to pass as macro to the loop
Control table e.g.
TABLE NAME COLUMN
TABLE1 Col1
TABLE1 Col2
............. ..........
Then I will create two macros variables, the TableName and the Column and then I want to run a job for every raw of the control table.
If it is not possible I will use sas code.
Thanks in advance,
Vassilis
Thank you Ron for your reply.
I manage to loop a job with your information.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.
Find more tutorials on the SAS Users YouTube channel.