How to Obtain Output of proc fastclus (and proc cluster) as SAS Dataset

ehsanmath — Fri, 20 Jun 2014 15:20:20 GMT

Hallo,

Recently, I have to use "proc fastclus" to cluster some data. But I do not know how to obtain the Output given by "proc fastclus" as a SAS dataset.

For instance, I am obtaining the following Output in the SAS Output Window. Is there a way to obtain the following Output as a SAS dataset ?

I shall be thankful for your time and suggestions.

regards

Ehsan

_____________________________________________________________________________________________________

The FASTCLUS Procedure

Replace=FULL Radius=0 Maxclusters=3 Maxiter=20 Converge=0.02

Initial Seeds

Cluster open_STA

-------------------------

1 0.005405405

2 1.000000000

3 0.502824859

Minimum Distance Between Initial Seeds = 0.497175

Iteration History

Relative Change in Cluster Seeds

Iteration Criterion 1 2 3

----------------------------------------------------------

1 0.1052 0.1281 0.2490 0.1139

2 0.0777 0.000855 0.1090 0.0593

3 0.0745 0.00544 0.0474 0.0520

4 0.0729 0.00488 0.0312 0.0387

5 0.0719 0.00360 0.0206 0.0268

6 0.0715 0.00269 0.0150 0.0195

Convergence criterion is satisfied.

Criterion Based on Final Seeds = 0.0712

Cluster Summary

Maximum Distance

RMS Std from Seed Radius Nearest Distance Between

Cluster Frequency Deviation to Observation Exceeded Cluster Cluster Centroids

--------------------------------------------------------------------------------------------------

1 527037 0.0520 0.1436 3 0.2812

2 55402 0.1324 0.2347 3 0.4184

3 115267 0.0991 0.2082 1 0.2812

Statistics for Variables

Variable Total STD Within STD R-Square RSQ/(1-RSQ)

--------------------------------------------------------------------------

percent_open_STA 0.21582 0.07110 0.891462 8.213326

OVER-ALL 0.21582 0.07110 0.891462 8.213326

Pseudo F Statistic = 2865231

Approximate Expected Over-All R-Squared = 0.88889

Cubic Clustering Criterion = 15.911

Cluster Means

Cluster open_STA

-------------------------

1 0.0602435223

2 0.7598437436

3 0.3414665366

Cluster Standard Deviations

Cluster open_STA

-------------------------

1 0.0519829005

2 0.1324085885

3 0.0990948798

______________________________________________________________________________________________________________

Re: How to Obtain Output of proc fastclus (and proc cluster) as SAS Dataset

stat_sas — Fri, 20 Jun 2014 15:44:09 GMT

Hi,

You need to put ods output before proc fastclus syntax. All the desired output datasets will be saved in work library.

Regards,

Naeem

ods output InitialSeeds=InitialSeeds MinDist=MinDist IterHistory=IterHistory

ConvergenceStatus=ConvergenceStatus ClusterSum=ClusterSum VariableStat=VariableStat;

proc fastclus data=have Replace=FULL Radius=0 Maxclusters=3 Maxiter=20 Converge=0.02;

var a b c d e;

run;

proc print data=InitialSeeds;

run;

proc print data=MinDist;

run;

.........

......

topic Re: How to Obtain Output of proc fastclus (and proc cluster) as SAS Dataset in SAS Programming

How to Obtain Output of proc fastclus (and proc cluster) as SAS Dataset

Re: How to Obtain Output of proc fastclus (and proc cluster) as SAS Dataset