SUPPORT / SAMPLES & SAS NOTES
Problem Note 19170: Errors issued when integer references for column is used in a PROC SQL GROUP BY statement
 |  |  |  |  |
You will receive the following error messages when a integer for the column position on the SELECT clause is used in the PROC SQL GROUP BY clause:
ERROR: GROUP BY clause contains a summary function, which is not
allowed.
ERROR: Summary functions are retricted to the SELECT and HAVING
clauses only.
The errors may be generated incorrectly if none of the columns referenced in the GROUP BY clause contain a summary function.
An example of a query which generates this error follows:
proc sql;
create table new as
select
table1.col1,
table4.col2,
table5.col3,
table2.col4,
table3.col5,
(table3.col6) as newcol6,
sum(table0.col7) as col7,
sum(table0.col8) as col8
from table0
inner join table1
on table0.key1=table1.key1
inner join table2
on table0.key2=table2.key2
inner join table3
on table0.key3=table3.key3
inner join table4
on table0.key4=table4.key4
inner join table5
on table0.key5=table5.key5
group by 1, 2, 3, 4, 5, 6;
quit;
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 | SAS Release | |
| Reported | Fixed* | |||
| SAS System | Base SAS | Microsoft Windows NT Workstation | 9.1 TS1M3 | |
| Microsoft Windows Server 2003 Enterprise Edition | 9.1 TS1M3 | 9.2 TS1M0 | ||
| Microsoft Windows Server 2003 Standard Edition | 9.1 TS1M3 | 9.2 TS1M0 | ||
| Microsoft Windows Server 2003 Datacenter Edition | 9.1 TS1M3 | 9.2 TS1M0 | ||
| Microsoft Windows 2000 Advanced Server | 9.1 TS1M3 | 9.2 TS1M0 | ||
| Microsoft Windows 2000 Datacenter Server | 9.1 TS1M3 | 9.2 TS1M0 | ||
| Microsoft Windows 2000 Server | 9.1 TS1M3 | 9.2 TS1M0 | ||
| Microsoft Windows 2000 Professional | 9.1 TS1M3 | 9.2 TS1M0 | ||
| 64-bit Enabled Solaris | 9.1 TS1M3 | 9.2 TS1M0 | ||
| z/OS | 9.1 TS1M3 | 9.2 TS1M0 | ||
| HP-UX IPF | 9.1 TS1M3 | 9.2 TS1M0 | ||
| Linux | 9.1 TS1M3 | 9.2 TS1M0 | ||
| Linux on Itanium | 9.1 TS1M3 | 9.2 TS1M0 | ||
| 64-bit Enabled HP-UX | 9.1 TS1M3 | 9.2 TS1M0 | ||
| 64-bit Enabled AIX | 9.1 TS1M3 | 9.2 TS1M0 | ||
| OpenVMS Alpha | 9.1 TS1M3 | 9.2 TS1M0 | ||
| Tru64 UNIX | 9.1 TS1M3 | 9.2 TS1M0 | ||
| Microsoft Windows XP Professional | 9.1 TS1M3 | 9.2 TS1M0 | ||