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
______________________________________________________________________________________________________________
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;
.........
......
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.