Looking for Best Way to Summarize Percentiles Across Groups

[Zachary]

Below is my very basic code:

proc univariate data = Combined;

  by Bin;

  var Gross;

  output pctlpre = P_ pctlpts = 1, 5 to 95 by 5, 9, 100;

run;

I am only interested in seeing the percentiles and none of the rest of the univariate output.

It also would be groovy to see the results side-by-side for each Bin. I have 10 Bins.

Any suggestions? Thank you in advance.

[Reeza · Accepted solution]

ODS SELECT NONE and a proc transpose on your output.

Also, you haven't specified the data set in your OUTPUT statement which is a bit odd.

proc sort data=sashelp.cars out=cars; by origin;

ods select none;

proc univariate data = cars;

  by origin;

  var mpg_highway;

  output out=want pctlpre = P_ pctlpts = 1, 5 to 95 by 5, 9, 100;

run;

ods select all;

proc transpose data=want out=want2;

id origin;

run;

proc print data=want2;

run;