SUPPORT / SAMPLES & SAS NOTES
 

Support

Problem Note 67358: A SAS® Studio 5.2 query returns incorrect results for a calculated column when a GROUP BY clause is used

DetailsHotfixAboutRate It

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 FamilyProductSystemProduct ReleaseSAS Release
ReportedFixed*ReportedFixed*
SAS SystemSAS Studio for ViyaMicrosoft® Windows® for x645.22020.1.4ViyaViya
Linux for x645.22020.1.4ViyaViya
* For software releases that are not yet generally available, the Fixed Release is the software release in which the problem is planned to be fixed.