How do I present in a table the mean and standard deviation of 34 variables X1-X34 ordered from the

[NPConcorida]

How do I present in a table the mean and standard deviation of 34 variables X1-X34 ordered
from the highest to the lowest value of the mean?

[Reeza]

https://gist.github.com/statgeek/d4c36ea88523d49e135a7aa494c29846

In this example, I sort by N, but hopefully you can see how to extend it to MEAN instead.

*generate fake data;
data have;
    array a(17);

    do i=1 to 100;

        do j=1 to 17;
            a(j)=rand('bernoulli', 0.27);

            if rand('bernoulli', 0.1)=1 then
                call missing(a(j));
        end;
        output;
    end;
run;

*Summary statistics;
proc means data=have stackods n sum mean maxdec=1;
    var a1-a17;
    ods output summary=want;
run;

*sort by N, descending count, and print;
proc sort data=want;
    by descending n;
run;

proc print data=want label noobs;
    label variable='Defect Categories';
run;

---

@NPConcorida wrote:

How do I present in a table the mean and standard deviation of 34 variables X1-X34 ordered
from the highest to the lowest value of the mean?

---