topic Re: Loop on SAS Data Integration Studio in SAS Data Management

Loop on SAS Data Integration Studio

Spiky123 — Tue, 07 Nov 2017 22:16:19 GMT

Hi !

I have a problem. I want to do a LOOP on SAS Data Integration Studio and execute this Loop until the value in my table is equal 1.

For example :

The user writer code generate a variable "file_test" in the table work.test

I want to make a LOOP with the LOOP transformation (no user writer code) to execute the loop until the value of "file_test" equal 0 and if the value of "file_test" = 1 then stop the LOOP.

Is it possible ?

The version of SAS DIS is 4.9

Thanks 🙂

Re: Loop on SAS Data Integration Studio

LinusH — Wed, 08 Nov 2017 22:20:14 GMT

Spontaneously I would say no, that's not how the loop transform works.
A dirty solurion is to wrap the steps in the inner job with a surronding macro with %do and %while/%until.
If you describe the logic how you assign the file_test we might can come up with a neater solution.

Re: Loop on SAS Data Integration Studio

Spiky123 — Thu, 09 Nov 2017 12:12:11 GMT

Hello LinusH,

First of all thanks for your reply !

The operation of the process is as follows:

The DIS job should run every 5 minutes by searching a directory for a specific file.
The macro loops as long as the file is not found. If the file is found, it stops.
How can I set up a condition in my program that runs the DIS job every 5 minutes to check for the presence of the file and does not run after the file is found?

I can use the USER WRITER transformation, as you said the LOOP transformation doesn't work for this.

Best regards,

Re: Loop on SAS Data Integration Studio

LinusH — Thu, 09 Nov 2017 21:53:31 GMT

This sounds more like a job for a scheduler or an external script.
DI Studio is mainly for dealing with data flows, not application logic.

Re: Loop on SAS Data Integration Studio

Spiky123 — Fri, 10 Nov 2017 13:02:13 GMT

Super !! you confirm all iwas thinking :)))

Thanks a lot 🙂

Best regards,

Stefan