Query nodes in SAS® Studio flows might show a mismatch between the graphical join condition and the text in the Expression Builder


Background

When SAS® Data Integration Studio (DIS) jobs are imported into SAS Viya, join transformations are converted into Query nodes within a SAS® Studio flow. By design, these migrated Query nodes should display only the text-based representation of the join condition, accessible via the Join tab in the node options.

Here is an example:

migrated Query nodes should display only the text-based representation of the join condition, accessible via the Join tab in the node options

Issue

Following an upgrade to SAS® Studio 2025.09 or later, migrated Query nodes might unexpectedly display a graphical representation of the join condition alongside the text-based version that is available in the Expression Builder, as shown here:

migrated Query nodes may unexpectedly display a graphical representation of the join condition alongside the text-based version available in the Expression Builder

Although the code generated by the node continues to reference the condition defined in the Expression Builder, any modifications that you make through the graphical Join tab or at the flow level—such as adding or removing input tables—are not propagated to the Expression Builder. This leaves the node in an inconsistent state.

The only indications that you are encountering this issue is the difference in the display shown above and the data quality issues that result. 

Resolution

The fix / patch restores the expected behavior. It ensures that only the text-based join condition is displayed in the Expression Builder for migrated Query nodes. Install the appropriate fix/patch: