Loop on SAS Data Integration Studio

[Spiky123]

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 🙂

[LinusH]

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.

[Spiky123]

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,

[LinusH · Accepted solution]

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.

[Spiky123]

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

Thanks a lot 🙂

Best regards,

Stefan