topic Re: Produce Cluster stats on Manually updated Clusters in SAS Data Science

Produce Cluster stats on Manually updated Clusters

MR_E — Tue, 07 Mar 2017 11:25:32 GMT

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

Re: Produce Cluster stats on Manually updated Clusters

MR_E — Mon, 13 Mar 2017 09:25:34 GMT

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

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

Re: Produce Cluster stats on Manually updated Clusters

MarcHuber — Wed, 15 Mar 2017 13:52:22 GMT

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;

Re: Produce Cluster stats on Manually updated Clusters

sbxkoenk — Wed, 15 Mar 2017 14:20:32 GMT

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