topic Re: Sorting Summary Statistics by Mean in New SAS User

Sorting Summary Statistics by Mean

brush01 — Tue, 23 Nov 2021 01:23:42 GMT

I am working with the default CARS data set in SAS Studio, and want to examine the difference in mean horsepower between car manufacturers. The image/code below is my simple Summary Statistics program.

https://prnt.sc/20kfe5g

ods noproctitle;
ods graphics / imagemap=on;

proc means data=SASHELP.CARS chartype mean std vardef=df;
	var Horsepower;
	class Make;
run;

As you can see, the output is organized by make. This would be fine if I were only interested in a single make, but the large number of manufacturers makes it difficult to examine the order of all at once. I need to sort the output table by Mean. How do I do it?

Re: Sorting Summary Statistics by Mean

Reeza — Tue, 23 Nov 2021 03:48:25 GMT

You cannot control the displayed output at that level unfortunately.

You can save the output to a data set (click on the OUTPUT tab and check the box and select the stats).

Then you can sort/re-order the output data set as desired.

@brush01 wrote:

I am working with the default CARS data set in SAS Studio, and want to examine the difference in mean horsepower between car manufacturers. The image/code below is my simple Summary Statistics program.

https://prnt.sc/20kfe5g
ods noproctitle;
ods graphics / imagemap=on;

proc means data=SASHELP.CARS chartype mean std vardef=df;
	var Horsepower;
	class Make;
run;
As you can see, the output is organized by make. This would be fine if I were only interested in a single make, but the large number of manufacturers makes it difficult to examine the order of all at once. I need to sort the output table by Mean. How do I do it?

Re: Sorting Summary Statistics by Mean

Ksharp — Tue, 23 Nov 2021 12:09:22 GMT

proc sql;
select Make,count(Horsepower) as n label='Nobs',
       mean(Horsepower) as mean label='Mean',
    std(Horsepower) as std label='Stddev'
 from sashelp.cars
  group by Make
   order by mean desc;
quit;