Problem Note 64148: The "Automatically select groups" option does not work properly in the SAS® Studio Query Utility
 |  |  |  |  |
When using the SAS Studio Query Utility, the Automatically select groups option on the GROUP tab is selected by default. When this option is selected, the GROUP tab should contain all columns without any summary functions.
However, sometimes, the GROUP tab contains additional columns as well. For example, suppose that your query utility contains the columns Name, Sex, Weight, and Height from SASHELP.CLASS, and that Summary=COUNT has been applied for the columns Weight and Height.
Given that scenario, the GROUP tab should contain only the columns Name and Sex because they do not have any summaries.
However, the GROUP tab might still show the Name, Sex, and Weight columns as well.
This issue affects only the user interface. The SQL procedure that is automatically generated from SAS Studio is not affected by this problem, so the result of the query utility is correct.
CREATE TABLE WORK.QUERY
AS
SELECT CLASS.Name, CLASS.Sex, COUNT(CLASS.Height)
AS Height, COUNT(CLASS.Weight)
AS Weight
Click 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 Studio | Microsoft® Windows® for x64 | 3.71 | 5.2 | 9.4 TS1M5 | Viya |
| Microsoft Windows 8 Enterprise 32-bit | 3.71 | 9.4 TS1M5 | ||||
| Microsoft Windows 8 Enterprise x64 | 3.71 | 5.2 | 9.4 TS1M5 | Viya | ||
| Microsoft Windows 8 Pro 32-bit | 3.71 | 9.4 TS1M5 | ||||
| Microsoft Windows 8 Pro x64 | 3.71 | 5.2 | 9.4 TS1M5 | Viya | ||
| Microsoft Windows 8.1 Enterprise 32-bit | 3.71 | 9.4 TS1M5 | ||||
| Microsoft Windows 8.1 Enterprise x64 | 3.71 | 5.2 | 9.4 TS1M5 | Viya | ||
| Microsoft Windows 8.1 Pro 32-bit | 3.71 | 9.4 TS1M5 | ||||
| Microsoft Windows 8.1 Pro x64 | 3.71 | 5.2 | 9.4 TS1M5 | Viya | ||
| Microsoft Windows 10 | 3.71 | 5.2 | 9.4 TS1M5 | Viya | ||
| Microsoft Windows Server 2008 | 3.71 | 9.4 TS1M5 | ||||
| Microsoft Windows Server 2008 R2 | 3.71 | 5.2 | 9.4 TS1M5 | Viya | ||
| Microsoft Windows Server 2008 for x64 | 3.71 | 5.2 | 9.4 TS1M5 | Viya | ||
| Microsoft Windows Server 2012 Datacenter | 3.71 | 5.2 | 9.4 TS1M5 | Viya | ||
| Microsoft Windows Server 2012 R2 Datacenter | 3.71 | 5.2 | 9.4 TS1M5 | Viya | ||
| Microsoft Windows Server 2012 R2 Std | 3.71 | 5.2 | 9.4 TS1M5 | Viya | ||
| Microsoft Windows Server 2012 Std | 3.71 | 5.2 | 9.4 TS1M5 | Viya | ||
| Microsoft Windows Server 2016 | 3.71 | 9.4 TS1M5 | ||||
| Windows 7 Enterprise 32 bit | 3.71 | 9.4 TS1M5 | ||||
| Windows 7 Enterprise x64 | 3.71 | 5.2 | 9.4 TS1M5 | Viya | ||
| Windows 7 Home Premium 32 bit | 3.71 | 9.4 TS1M5 | ||||
| Windows 7 Home Premium x64 | 3.71 | 5.2 | 9.4 TS1M5 | Viya | ||
| Windows 7 Professional 32 bit | 3.71 | 9.4 TS1M5 | ||||
| Windows 7 Professional x64 | 3.71 | 5.2 | 9.4 TS1M5 | Viya | ||
| Windows 7 Ultimate 32 bit | 3.71 | 9.4 TS1M5 | ||||
| Windows 7 Ultimate x64 | 3.71 | 5.2 | 9.4 TS1M5 | Viya | ||
| 64-bit Enabled AIX | 3.71 | 5.2 | 9.4 TS1M5 | Viya | ||
| 64-bit Enabled Solaris | 3.71 | 5.2 | 9.4 TS1M5 | Viya | ||
| HP-UX IPF | 3.71 | 5.2 | 9.4 TS1M5 | Viya | ||
| Linux for x64 | 3.71 | 5.2 | 9.4 TS1M5 | Viya | ||
| Solaris for x64 | 3.71 | 5.2 | 9.4 TS1M5 | Viya | ||
A fix for this issue for SAS Studio 3.8 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/D8F.html#64148A fix for this issue for SAS Studio 3.71 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/C2L.html#64148| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2019-06-03 15:41:17 |
| Date Created: | 2019-05-02 04:27:42 |