Help using Base SAS procedures

Looking for Best Way to Summarize Percentiles Across Groups

Accepted Solution Solved
Reply
Frequent Contributor
Posts: 115
Accepted Solution

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: 19,770

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;

View solution in original post


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

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.

Need further help from the community? Please ask a new question.

Discussion stats
  • 1 reply
  • 312 views
  • 0 likes
  • 2 in conversation