topic Looking for Best Way to Summarize Percentiles Across Groups in SAS Procedures

Looking for Best Way to Summarize Percentiles Across Groups

Zachary — Thu, 05 Feb 2015 16:26:26 GMT

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 — Thu, 05 Feb 2015 16:49:44 GMT

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;