When you import SAS Enterprise Guide projects into SAS Studio for SAS Viya, Query Builder tasks that use basic filters with datetime literals that reference midnight (00:00:00) might be incorrectly converted to Query nodes with datetime literals that reference midday (12:00:00). 

This issue is limited to Query Builder tasks that use basic filters. Query Builder tasks that use advanced filters are not affected.

Example Scenario

In an SAS Enterprise Guide project, a Query Builder task uses a basic filter with the following condition:

This task generates the following code:

t1.DateOperation BETWEEN '1Jan2024:0:0:0'dt AND '31Dec2024:0:0:0'dt

When you import the project into SAS Studio for SAS Viya, the filter is converted to a Query node with condition that references midday values:

t1.DateOperation BETWEEN '01Jan2024:12:00:00'dt AND '31Dec2024:12:00:00'dt

Resolution

• SAS^® Studio 2026.04 — The fix will be included as part of the standard release.
• SAS^® Studio 2026.03 — A patch has been developed and is currently available.