SUPPORT / SAMPLES & SAS NOTES
Problem Note 55406: The COALESCE function might return incorrect results when used with SAS® Scalable Performance Data Server 5.1
 |  |  |  |  |
When you run SAS Scalable Performance Data Server 5.1 and use the COALESCE () function, you might see incorrect results. The problem occurs when you are using SQL pass-through on a little endian system. The behavior is related to the presence of short numeric operands in your data.
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 HF1 | 9.4 TS1M3 | 9.4 TS1M3 |
| Linux for x64 | 5.1 | 5.1 HF1 | 9.4 TS1M3 | 9.4 TS1M3 | ||
| Solaris for x64 | 5.1 | 5.1 HF1 | 9.4 TS1M3 | 9.4 TS1M3 | ||