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

NPConcorida — Tue, 05 Oct 2021 17:06:31 GMT

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?

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

Reeza — Tue, 05 Oct 2021 19:08:36 GMT

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?

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

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

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