SUPPORT / SAMPLES & SAS NOTES
 

Support

Problem Note 64148: The "Automatically select groups" option does not work properly in the SAS® Studio Query Utility

DetailsHotfixAboutRate It

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.

/* Query code generated for SAS Studio by Common Query Services */
PROC SQL;
  CREATE TABLE WORK.QUERY
    AS
  SELECT CLASS.Name, CLASS.Sex, COUNT(CLASS.Height)
    AS Height, COUNT(CLASS.Weight)
    AS Weight
FROM SASHELP.CLASS CLASS
GROUP BY CLASS.Name, CLASS.Sex;
QUIT;

Click the Hot Fix tab in this note to access the hot fix for this issue.



Operating System and Release Information

Product FamilyProductSystemProduct ReleaseSAS Release
ReportedFixed*ReportedFixed*
SAS SystemSAS StudioMicrosoft® Windows® for x643.715.29.4 TS1M5Viya
Microsoft Windows 8 Enterprise 32-bit3.719.4 TS1M5
Microsoft Windows 8 Enterprise x643.715.29.4 TS1M5Viya
Microsoft Windows 8 Pro 32-bit3.719.4 TS1M5
Microsoft Windows 8 Pro x643.715.29.4 TS1M5Viya
Microsoft Windows 8.1 Enterprise 32-bit3.719.4 TS1M5
Microsoft Windows 8.1 Enterprise x643.715.29.4 TS1M5Viya
Microsoft Windows 8.1 Pro 32-bit3.719.4 TS1M5
Microsoft Windows 8.1 Pro x643.715.29.4 TS1M5Viya
Microsoft Windows 103.715.29.4 TS1M5Viya
Microsoft Windows Server 20083.719.4 TS1M5
Microsoft Windows Server 2008 R23.715.29.4 TS1M5Viya
Microsoft Windows Server 2008 for x643.715.29.4 TS1M5Viya
Microsoft Windows Server 2012 Datacenter3.715.29.4 TS1M5Viya
Microsoft Windows Server 2012 R2 Datacenter3.715.29.4 TS1M5Viya
Microsoft Windows Server 2012 R2 Std3.715.29.4 TS1M5Viya
Microsoft Windows Server 2012 Std3.715.29.4 TS1M5Viya
Microsoft Windows Server 20163.719.4 TS1M5
Windows 7 Enterprise 32 bit3.719.4 TS1M5
Windows 7 Enterprise x643.715.29.4 TS1M5Viya
Windows 7 Home Premium 32 bit3.719.4 TS1M5
Windows 7 Home Premium x643.715.29.4 TS1M5Viya
Windows 7 Professional 32 bit3.719.4 TS1M5
Windows 7 Professional x643.715.29.4 TS1M5Viya
Windows 7 Ultimate 32 bit3.719.4 TS1M5
Windows 7 Ultimate x643.715.29.4 TS1M5Viya
64-bit Enabled AIX3.715.29.4 TS1M5Viya
64-bit Enabled Solaris3.715.29.4 TS1M5Viya
HP-UX IPF3.715.29.4 TS1M5Viya
Linux for x643.715.29.4 TS1M5Viya
Solaris for x643.715.29.4 TS1M5Viya
* 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.