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

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:

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