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;

.........

......

sas-innovate-2024.png

Don't miss out on SAS Innovate - Register now for the FREE Livestream!

Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.

 

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

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