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.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.