## Looking for Best Way to Summarize Percentiles Across Groups

Solved
Frequent Contributor
Posts: 115

# Looking for Best Way to Summarize Percentiles Across Groups

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.

Accepted Solutions
Solution
‎02-05-2015 11:49 AM
Super User
Posts: 23,791

## Re: Looking for Best Way to Summarize Percentiles Across Groups

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;

All Replies
Solution
‎02-05-2015 11:49 AM
Super User
Posts: 23,791

## Re: Looking for Best Way to Summarize Percentiles Across Groups

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;

🔒 This topic is solved and locked.