SUPPORT / SAMPLES & SAS NOTES
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 | ||