Problem Note 67358: A SAS® Studio 5.2 query returns incorrect results for a calculated column when a GROUP BY clause is used
 |  |  |  |  |
In SAS Studio 5.2 (Basic and Enterprise), a GROUP BY clause that is performed on a calculated column in a query does not provide correct results in the query builder.
Incorrect values appear in the calculated column, and the SQL code displays incorrect syntax containing the expression instead of the calculated column name.
Click the Hot Fix tab in this note for a link to instructions about accessing and applying the software update.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Studio for Viya | Microsoft® Windows® for x64 | 5.2 | 2020.1.4 | Viya | Viya |
| Linux for x64 | 5.2 | 2020.1.4 | Viya | Viya | ||
Viya on Windows: An update for this issue is available for SAS Viya 3.5. For instructions on how to access and apply software updates, see the Updating Your SAS Viya software section in the SAS Viya 3.5 for Windows Deployment Guide at
http://documentation.sas.com/?softwareId=administration&softwareVersion=3.5&softwareContextId=softwareUpdatesWinViya on Linux: An update for this issue is available for SAS Viya 3.5. For instructions on how to access and apply software updates, see the Updating Your SAS Viya software section in the SAS Viya 3.5 for Linux Deployment Guide at
http://documentation.sas.com/?softwareId=administration&softwareVersion=3.5&softwareContextId=softwareUpdates| Type: | Problem Note |
| Priority: | medium |
| Date Modified: | 2021-02-26 15:48:47 |
| Date Created: | 2021-02-02 15:04:23 |