topic Re: Dynamic Loop with Dataflux - it is possible? in SAS Data Management

Dynamic Loop with Dataflux - it is possible?

VROUSSAKIS — Wed, 26 Apr 2017 08:24:43 GMT

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

Re: Dynamic Loop with Dataflux - it is possible?

RonAgresta — Thu, 27 Apr 2017 12:57:39 GMT

If you haven't already done so, take a look at process jobs and work tables in Data Management Studio. Process jobs have nodes that let you set macro variables, use conditional logic for loops, fork processes, and run processes in parallel. Work tables can be accessed at this level to provide a mechanism for your control table. Ron

Re: Dynamic Loop with Dataflux - it is possible?

VROUSSAKIS — Fri, 28 Apr 2017 07:46:44 GMT

Thank you Ron for your reply.

I manage to loop a job with your information.