Hello
I have the following problem in SAS DI.
The following warning appears in the control flow window, see screen
Here is a chart
Who faced this, please tell me how to fix it? Does the warning affect the result or speed of the process?
Thanks in advance.
Hi @Shukhrat
I think it might be caused by the same table being used as input and output. It is just a guess, because a storage system problem prevents me from testing it today, but DI Studio might detect that the table is populated in the insert transformation 3, so it might happen that the table is empty when it is used as input to the join transformation 1. I can't see how it could have any impact on speed or result.
So if the job is complete, i.e. it is able to execute, and the output is as expected, I think you can ignore the warning. Warnings from Flow Control often disappears when the job is saved/closed and opened again. Did you try that?
Hi @Shukhrat
I think it might be caused by the same table being used as input and output. It is just a guess, because a storage system problem prevents me from testing it today, but DI Studio might detect that the table is populated in the insert transformation 3, so it might happen that the table is empty when it is used as input to the join transformation 1. I can't see how it could have any impact on speed or result.
So if the job is complete, i.e. it is able to execute, and the output is as expected, I think you can ignore the warning. Warnings from Flow Control often disappears when the job is saved/closed and opened again. Did you try that?
Catch the best of SAS Innovate 2025 — anytime, anywhere. Stream powerful keynotes, real-world demos, and game-changing insights from the world’s leading data and AI minds.
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.