BookmarkSubscribeRSS Feed
ehsanmath
Obsidian | Level 7

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

______________________________________________________________________________________________________________

1 REPLY 1
stat_sas
Ammonite | Level 13

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;

.........

......

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

Register Now

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 1 reply
  • 806 views
  • 0 likes
  • 2 in conversation