SUPPORT / SAMPLES & SAS NOTES
Problem Note 34460: Incorrect results might be returned when the COUNT(DISTINCT) function is used in the SQL procedure
 |  |  |  |  |
In SAS® 9.2, you might receive incorrect results if you use the COUNT(DISTINCT variable-name) function in an SQL procedure similar to the following:
proc sql;
select count(distinct variable-name) as cnt
from ds1;
quit;
This error normally occurs when the data set contains more than five million rows. In addition, the results that are generated might differ each time the code is run.
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 | z/OS | 9.2 TS1M0 | 9.2 TS2M0 |
| Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.2 TS1M0 | 9.2 TS2M0 | ||
| Microsoft Windows Server 2003 Datacenter 64-bit Edition | 9.2 TS1M0 | 9.2 TS2M0 | ||
| Microsoft Windows Server 2003 Enterprise 64-bit Edition | 9.2 TS1M0 | 9.2 TS2M0 | ||
| Microsoft Windows XP 64-bit Edition | 9.2 TS1M0 | 9.2 TS2M0 | ||
| Microsoft® Windows® for x64 | 9.2 TS1M0 | 9.2 TS2M0 | ||
| Microsoft Windows Server 2003 Datacenter Edition | 9.2 TS1M0 | 9.2 TS2M0 | ||
| Microsoft Windows Server 2003 Enterprise Edition | 9.2 TS1M0 | 9.2 TS2M0 | ||
| Microsoft Windows Server 2003 Standard Edition | 9.2 TS1M0 | 9.2 TS2M0 | ||
| Microsoft Windows XP Professional | 9.2 TS1M0 | 9.2 TS2M0 | ||
| Windows Vista | 9.2 TS1M0 | 9.2 TS2M0 | ||
| 64-bit Enabled AIX | 9.2 TS1M0 | 9.2 TS2M0 | ||
| 64-bit Enabled HP-UX | 9.2 TS1M0 | 9.2 TS2M0 | ||
| 64-bit Enabled Solaris | 9.2 TS1M0 | 9.2 TS2M0 | ||
| HP-UX IPF | 9.2 TS1M0 | 9.2 TS2M0 | ||
| Linux | 9.2 TS1M0 | 9.2 TS2M0 | ||
| Linux for x64 | 9.2 TS1M0 | 9.2 TS2M0 | ||
| OpenVMS on HP Integrity | 9.2 TS1M0 | 9.2 TS2M0 | ||
| Solaris for x64 | 9.2 TS1M0 | 9.2 TS2M0 | ||