I found an excellent example of how to use SAS PROC CLUSTER do to a cluster analysis.  My problem is that my data is set up in a very different way.  I am hoping someone can give me advice on how to rearrange my data, and then procedue with SAS PROC CLUSTER.  I provide details below.     The example that I am following has the object that you want to organize (fish species in this case) listed in the first column.  For example,                            Variable X          Variable X2      Variable X3       Variable X4 Fish species           ###                     ###                   ####                 ####   I am trying to do the same thing.  I want to look for clusters of fish species.  However, my data is set up in a different way.  I want to see what fish species are caught with other fish species on fishing trips.  So each row is a trip.  An example is below.                         Fish species 1     Fish species 2      Fish species 3     fish species 4         Depth         Gear Trip A            10                           3                               6                            9                    22             trap     Trip B             7                            8                              11                           7                    31             trap Trip C             6                            0                               0                            4                    55             hook   My objective is to do a cluster analysis that will group the fish species by looking at the data from fishing trips.  For example, maybe fish species 4 should be grouped with fish species 1 because they are frequently caught together and also at similar depths and gear.       I am stuck so any help would be greatly appreciated. ... View more

I created SAS code using proc SQL to calculate a weighted mean by year.  My SAS code is below.  My weight variable is called bwght and I weight the variable called CPUE for each year.  This code produces the weighted mean by year and calls it bwghtedAverage.  However, I can't figure out how I an get proc sql to also provide me with the 95% confidence intervals for this mean.  Any help would be greatly appreciated.    proc sql;    title 'Weighted Averages';    select Year, sum(CPUE*bwght)/sum(bwght) as bwghtedAverage        from (select Year, CPUE,                    case                       when bwght gt 0 then bwght                       else 0                    end as bwght                from CPUEdat)       group by Year /*major_area_code*/; quit; ... View more