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
 |  |  |  |  |
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 Family | Product | System | SAS Release | |
| Reported | Fixed* | |||
| SAS System | Base SAS | z/OS | 9.4 TS1M0 | |
| Z64 | 9.4 TS1M0 | |||
| Microsoft® Windows® for x64 | 9.4 TS1M0 | |||
| Microsoft Windows 8 Pro | 9.4 TS1M0 | |||
| Microsoft Windows Server 2008 for x64 | 9.4 TS1M0 | |||
| Microsoft Windows Server 2012 | 9.4 TS1M0 | |||
| Windows 7 Enterprise x64 | 9.4 TS1M0 | |||
| Windows 7 Professional x64 | 9.4 TS1M0 | |||
A fix for this issue for Base SAS 9.3_M2 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/I22.html#48605| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2013-09-06 09:58:18 |
| Date Created: | 2012-12-05 12:07:04 |