topic Re: proc tree in SAS Procedures

proc tree

niyi — Fri, 23 Sep 2016 23:58:31 GMT

what is the syntax for proc list in proc tree that will list members of each cluster

Re: proc tree

Shmuel — Sat, 24 Sep 2016 01:18:16 GMT

"The TREE procedure creates tree diagrams from a SAS data set containing the tree structure. You can create this type of data set with the CLUSTER or VARCLUS procedure." (quoted from SAS 9.2 O.L. Doc);

As you are looking for a list and not a diagram, I guess that, maybe, proc print may help you.

Please display what output you expect.

Re: proc tree

niyi — Sat, 24 Sep 2016 01:29:44 GMT

i want to see the list of individual members of each cluster in a tree

Re: proc tree

Shmuel — Sat, 24 Sep 2016 02:12:47 GMT

I have very little experience with proc tree and using SAS UE I have no access to SAS Stat.

Anyhow, I guess that sorting your data by cluster and printing it may help:

proc sort data=have out=temp; by <cluster variable>; run;

proc print data=temp;

by <cluster variable>;

run;

Re: proc tree

Reeza — Sat, 24 Sep 2016 03:12:33 GMT

@Shmuel SAS UE supports SAS/STAT procedures.

@niyi Can you post your current Proc tree code and/or any preceding code.

Re: proc tree

PGStats — Sat, 24 Sep 2016 03:14:21 GMT

Assuming that you have used OUTTREE=procClusterOuttree with proc cluster, get the cluster membership for, say, 3 clusters with :

proc tree data=procClusterOuttree noprint nclusters=3 out=Clusters;
run;

proc sort data=Clusters; by CLUSTER; run;

proc print data=Clusters; run;

Re: proc tree

niyi — Sat, 24 Sep 2016 04:50:26 GMT

Thanks samuel see below

proc cluster data=outmean out=outff
outtree=tree method=average pseudo;
id Acces_Number;
run;
proc fastclus data=outmean
out=outff outstat=outstat MAXCLUSTERS=5;
id Acces_Number;
run;
proc freq data=outff ;
tables cluster*Acces_Number/list
nofreq nopercent norow nocol;
run;
options text=10pct title=5pct;
proc tree data=tree HPAGES=3;
id Acces_Number;
height _rsq_;
run;
PROC CLUSTER DATA=Wildvig_Oyatomi METHOD=ward pseudo standardize;
VAR TERMLLT--SEEDPPD;
id Acces_Number;
RUN;

PROC TREE;
id Acces_Number;
RUN;

Re: proc tree

niyi — Sat, 24 Sep 2016 04:51:58 GMT