Problem Note 63768: The SAS® Scalable Performance Data Server DACCTAB function returns incorrect results using the SQL pass-through facility
 |  |  |  |  |
The DACCTAB function returns incorrect results when you use it with the SAS Scalable Performance Data Server. When you use the function with SAS® Foundation, the results are correct.
The problem occurs because the SPD Server is setting the fractional results to 1 if the value is greater than 1. Instead, SAS Foundation sets the value to missing.
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 | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SPDS | SAS Scalable Peformance Data Server | Microsoft® Windows® for x64 | 5.2 | 5.4 HF1 | 9.4 TS1M2 | 9.4 TS1M5 |
| Microsoft Windows 10 | 5.2 | 5.4 HF1 | 9.4 TS1M2 | 9.4 TS1M5 | ||
| 64-bit Enabled AIX | 5.2 | 5.4 HF1 | 9.4 TS1M2 | 9.4 TS1M5 | ||
| 64-bit Enabled Solaris | 5.2 | 5.4 HF1 | 9.4 TS1M2 | 9.4 TS1M5 | ||
| HP-UX IPF | 5.2 | 5.4 HF1 | 9.4 TS1M2 | 9.4 TS1M5 | ||
| Linux for x64 | 5.2 | 5.4 HF1 | 9.4 TS1M2 | 9.4 TS1M5 | ||
| Solaris for x64 | 5.2 | 5.4 HF1 | 9.4 TS1M2 | 9.4 TS1M5 | ||
A fix for this issue for SAS Scalable Performance Data Server 5.4 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/C9A.html#63768A fix for this issue for SAS Scalable Performance Data Server 5.3 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/A3J.html#63768| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2019-05-10 10:46:45 |
| Date Created: | 2019-02-27 16:58:48 |