SUPPORT / SAMPLES & SAS NOTES
 

Support

Problem Note 48605: Results generated by the SQL procedure GROUP BY clause might not be correct for tables that contain more than 2 billion rows

DetailsHotfixAboutRate It

Summary statistics that are generated by PROC SQL results might not be correct for tables that contain more than 2 billion rows.

When you use PROC SQL with summary functions and a GROUP BY clause, the results of the summary statistic might not be correct for tables that contain more than 2 billion rows. This problem occurs on operating systems that store their system long numeric values in 32-bits.

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



Operating System and Release Information

Product FamilyProductSystemSAS Release
ReportedFixed*
SAS SystemBase SASz/OS9.4 TS1M0
Z649.4 TS1M0
Microsoft® Windows® for x649.4 TS1M0
Microsoft Windows 8 Pro9.4 TS1M0
Microsoft Windows Server 2008 for x649.4 TS1M0
Microsoft Windows Server 20129.4 TS1M0
Windows 7 Enterprise x649.4 TS1M0
Windows 7 Professional x649.4 TS1M0
* 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.