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;
.........
......
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
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.