Problem Note 60482: In SAS® Scalable Performance Data Server, using a group-by operation with an inner join causes incorrect results
 |  |  |  |  |
A query involving a join of two inner tables each performing a group-by operation might cause incorrect SAS Performance Data Server SQL results.
The query works correctly if the parallel group-by operation is disabled. You can disable parallel group-by with the SQL RESET option and the nogrpsel setting. Here are some examples.
- To use the RESET option with explicit SQL:
execute (reset nogrpsel) by sasspds; - To use the RESET option with implicit SQL:
%let SPDSSQLR=nogrpsel; - You can also set the NOGRPSEL in the spdsserv.parm file:
SQLOPTS=”rest nogrpsel”;
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 XP 64-bit Edition | 4.52 HF1 | 5.1 HF3 | ||
| Microsoft Windows 8 Enterprise x64 | 4.52 HF1 | 5.1 HF3 | ||||
| Microsoft Windows 10 | 4.52 HF1 | 5.1 HF3 | ||||
| 64-bit Enabled AIX | 4.52 HF1 | 5.1 HF3 | ||||
| 64-bit Enabled HP-UX | 4.52 HF1 | 5.1 HF3 | ||||
| 64-bit Enabled Solaris | 4.52 HF1 | 5.1 HF3 | ||||
| HP-UX IPF | 4.52 HF1 | 5.1 HF3 | ||||
| Linux for x64 | 4.52 HF1 | 5.1 HF3 | ||||
| Solaris for x64 | 4.52 HF1 | 5.1 HF3 | ||||
A 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#60482| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2017-06-12 14:35:40 |
| Date Created: | 2017-05-17 11:09:36 |