The Ascending order specified on the Sort tab of some query nodes of a flow might change to Descending after you upgrade to SAS® Studio 2025.06 and later releases.
This issue occurs only in query nodes where the columns listed on the Sort tab contain a sortDirection property that is set to null in the JSON file. For these columns, the sort order was set to Ascending prior to SAS Studio 2025.06 but changed to be Descending in SAS Studio 2025.06 and later versions. As a result, the flow might fail whenever an ascending order was necessary for a successful execution, which results an error similar to the following in the log:
ERROR: BY variables are not properly sorted on data set <libraryName.datasetName>
The issue has been reported on only flows that result from the import of SAS® Data Integration Studio jobs into SAS® Studio 2025.05 and earlier versions (as this is the only action that might lead to a sortDirection property to be set to null).
To circumvent this issue, manually set the sort order to Ascending for these specific columns.
The first version of SAS Studio containing the fix is SAS® Studio 2026.01. A patch has been developed for all versions between SAS® Studio 2025.09 and SAS® Studio 2025.12.