Produce Cluster stats on Manually updated Clusters

[MR_E]

Hello to All,

I am trying to obtain the centre points for my newly generated Clusters (as i will need it for future reporting cluster scoring), of which i have manually intervened and created additional clusters from the original PROC FASTCLUS. (7 New clusters identified under the Variable "NEWCLUSTER")

Now, i know if i used the original clusters i could use the OUTSTAT= option, HOWEVER as i have since split the clusters and created new ones i now require the centre points and stats for these also. How can i get the stats for the final cluster set please?

Outstat example

proc fastclus data=FINAL_CLUSters maxclusters=7 maxiter=100 converge=0

mean=mean out=prelimvol OUTSTAT=OUTSTAT;

var VOLUME: LOGVAL_Mean: LOGVAL_Sum:;

run;

I have attached an illustration of the New clusters for your reference

[MR_E]

Nobody?? i'm all alone....

Is there anything else i can provide to be more clear?

[MarcHuber]

A simple solution is just to use PROC MEANS on your newly assigned data set.  Use and NWAY option and a CLASS statement with NEWCLUSTER as the classification variable.

proc means data=OUTSTAT nway;

    class NEWCLUSTER;

    var VOLUME: LOGVAL_Mean: LOGVAL_Sum:;

    output out=CENTROIDS mean=;

run;

[sbxkoenk]

Hello,

I have 3 solutions popping up in my mind:

1. PROC MEANS just as @MarcHuber describes!

2. EMiner: Give your NEWCLUSTER variable the SEGMENT role and use the SEGMENT PROFILER node in Enterprise Miner

3. PROC FASTCLUS

proc sort data=mylib.myCLUSds; by NEWCLUSTER; run;
proc fastclus data=mylib.myCLUSds 
              maxclusters=1 maxiter=0 
              outstat=work.abc outseed=work.def;
			  /* OUTSEED= or MEAN= */
 id name;
 by NEWCLUSTER;
 var _NUMERIC_;
 *var VOLUME: LOGVAL_Mean: LOGVAL_Sum: ;
run;

Cheers,

Koen