Problem Note 40663: Incorrect results returned when the data set option NOINDEX=YES is used on a cluster table
If you are running SAS® Scalable Performance Data Server on Windows, the code found in the Full Code tab in this note returns incorrect results and produces the following message in the SAS log file:
NOTE: Table WORK.CLUSTER_NOINDEX created, with 3 rows and 1 columns.
To prevent the problem, use the SAS Scalable Performance Data Server macro variable SPDSNIDX=YES as follows:
%let SPDSNIDX=YES;
proc sql;
create table cluster_noindex as
select distinct x
from spdslib.cluster_table;
quit;
Select the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| SPDS | Scalable Performance Data Server | Microsoft Windows Server 2003 Datacenter 64-bit Edition | 4.52 | 4.53 | | |
| Microsoft Windows Server 2003 Enterprise 64-bit Edition | 4.52 | 4.53 | | |
| Microsoft Windows 2000 Advanced Server | 4.52 | 4.53 | | |
| Microsoft Windows 2000 Server | 4.52 | 4.53 | | |
| Microsoft Windows 2000 Professional | 4.52 | 4.53 | | |
| Microsoft Windows NT Workstation | 4.52 | 4.53 | | |
| Microsoft Windows Server 2003 Datacenter Edition | 4.52 | 4.53 | | |
| Microsoft Windows Server 2003 Enterprise Edition | 4.52 | 4.53 | | |
| Microsoft Windows Server 2003 Standard Edition | 4.52 | 4.53 | | |
| Microsoft Windows Server 2003 for x64 | 4.52 | 4.53 | | |
| Microsoft Windows Server 2008 | 4.52 | 4.53 | | |
| Microsoft Windows Server 2008 for x64 | 4.52 | 4.53 | | |
| Microsoft Windows XP Professional | 4.52 | 4.53 | | |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
The following program, which includes the NOINDEX=YES option in the PROC SQL step, incorrectly causes a note to be written to the SAS log:
libname spdslib sasspds 'tmp' server=localhost.5400 user='anonymous';
data spdslib.member_a;
x='1';output;
x='1';output;
run;
data spdslib.member_b;
x='2';output;
run;
proc sql noprint;
create index x ON spdslib.member_a;
create index x ON spdslib.member_b;
quit;
PROC SPDO library=spdslib;
cluster create cluster_table
mem=member_a
mem=member_b
maxslot=2;
quit;
proc sql;
create table cluster_noindex as
select distinct x
from spdslib.cluster_table(NOINDEX=YES);
quit;
| Type: | Problem Note |
| Priority: | alert |
| Date Modified: | 2010-09-03 18:25:05 |
| Date Created: | 2010-08-23 12:59:21 |
