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

Product Family	Product	System	Product Release		SAS Release
			Reported	Fixed*	Reported	Fixed*
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;

A fix for this issue for Scalable Performance Data Server 4.52 is available at:

http://ftp.sas.com/techsup/download/hotfix/HF2/B57.html#40663

---

A fix for this issue for SPD Server 4.4 is available at:

http://www.sas.com/techsup/download/hotfix/spds44.html#040663

---

Type:	Problem Note
Priority:	alert

Date Modified:	2010-09-03 18:25:05
Date Created:	2010-08-23 12:59:21