SUPPORT / SAMPLES & SAS NOTES
Problem Note 39279: Computed columns that use an aggregate function cause problems when "Automatically select groups" is selected in SAS® Enterprise Guide®
 |  |  |  |  |
In SAS Enterprise Guide, if your query includes a computed column that uses a CASE statement, which, in turn, contains an aggregate function such as SUM() or AVG(), then the Query Builder will generate invalid SQL if you also include an aggregate function in the query.
Once the computed column is included in the query, the Automatically select groups option will include it and generate invalid SQL, resulting in the following error:
ERROR: Summary functions are restricted to the SELECT and HAVING clauses only.
Select the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Enterprise Guide | Microsoft® Windows® for x64 | 4.2 | 4.3 | 9.2 TS2M0 | 9.2 TS2M3 |
| Microsoft Windows Server 2003 Datacenter Edition | 4.2 | 4.3 | 9.2 TS2M0 | 9.2 TS2M3 | ||
| Microsoft Windows Server 2003 Enterprise Edition | 4.2 | 4.3 | 9.2 TS2M0 | 9.2 TS2M3 | ||
| Microsoft Windows Server 2003 Standard Edition | 4.2 | 4.3 | 9.2 TS2M0 | 9.2 TS2M3 | ||
| Microsoft Windows XP Professional | 4.2 | 4.3 | 9.2 TS2M0 | 9.2 TS2M3 | ||
| Windows Vista | 4.2 | 4.3 | 9.2 TS2M0 | 9.2 TS2M3 | ||