Problem Note 56510: The SQL procedure CASE statement might return incorrect results when used with the SAS® Scalable Performance Data Server
 |  |  |  |  |
When you run SAS Scalable Performance Data Server 5.1 or later and your code includes an SQL CASE statement, you might see incorrect results. The issue occurs if your data contains numeric columns with a length less than 8 bytes.
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 | Scalable Performance Data Server | Microsoft® Windows® for x64 | 5.1 | 5.1 HF4 | 9.4 TS1M2 | 9.4 TS1M3 |
| Microsoft Windows 8 Enterprise x64 | 5.1 | 5.1 HF4 | 9.4 TS1M2 | 9.4 TS1M3 | ||
| Microsoft Windows Server 2008 for x64 | 5.1 | 5.1 HF4 | 9.4 TS1M2 | 9.4 TS1M3 | ||
| 64-bit Enabled AIX | 5.1 | 5.1 HF4 | 9.4 TS1M2 | 9.4 TS1M3 | ||
| 64-bit Enabled Solaris | 5.1 | 5.1 HF4 | 9.4 TS1M2 | 9.4 TS1M3 | ||
| HP-UX IPF | 5.1 | 5.1 HF4 | 9.4 TS1M2 | 9.4 TS1M3 | ||
| Linux for x64 | 5.1 | 5.1 HF4 | 9.4 TS1M2 | 9.4 TS1M3 | ||
| Solaris for x64 | 5.1 | 5.1 HF4 | 9.4 TS1M2 | 9.4 TS1M3 | ||
A fix for this issue for SAS Scalable Performance Data Server 5.2 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/U88.html#56510A fix for this issue for SAS Scalable Performance Data Server 5.1 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/N49.html#56510| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2015-09-02 17:56:30 |
| Date Created: | 2015-08-27 08:51:17 |