Usage Note 4308: REMERGING SUMMARY STATISTICS note using PROC SQL
Using a summary function with a GROUP BY clause in PROC SQL may cause
the following message to be written to the SAS Log:
NOTE: The query requires remerging summary statistics back with the
original data.
This note is generated when a column, listed on the select clause,
is not being used in a summary function and the column is not listed on
the GROUP BY clause. If the column selected is not used in a summary
function, adding it to a GROUP BY clause prevents the note.
When this situation occurs, summary groups are not collapsed into a
single row per group, even if a GROUP BY clause is specified and the
rows within the groups are identical. This is due to PROC SQL
choosing a course of action based on the query, not the values of the
columns.
If no GROUP BY clause is coded in the query, the complete table is
treated as one group.
Operating System and Release Information
SAS System | Base SAS | Microsoft Windows 95/98 | 8 TS M0 | |
Microsoft Windows NT Workstation | 8 TS M0 | |
Microsoft Windows 2000 Server | 8 TS M0 | |
Microsoft Windows 2000 Professional | 8 TS M0 | |
Microsoft Windows 2000 Advanced Server | 8 TS M0 | |
Microsoft Windows 2000 Datacenter Server | 8 TS M0 | |
OpenVMS VAX | 8 TS M0 | |
64-bit Enabled Solaris | 8 TS M0 | |
Solaris | 8 TS M0 | |
IRIX | 8 TS M0 | |
z/OS | 8 TS M0 | |
OS/2 | 8 TS M0 | |
HP-UX | 8 TS M0 | |
ABI+ for Intel Architecture | 8 TS M0 | |
CMS | 8 TS M0 | |
64-bit Enabled AIX | 8 TS M0 | |
64-bit Enabled HP-UX | 8 TS M0 | |
OpenVMS Alpha | 8 TS M0 | |
Tru64 UNIX | 8 TS M0 | |
AIX | 8 TS M0 | |
*
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.
Type: | Usage Note |
Priority: | |
Topic: | SAS Reference ==> SQL SAS Reference ==> Procedures ==> SQL
|
Date Modified: | 2009-11-20 10:18:01 |
Date Created: | 2001-02-13 15:39:50 |