Help using Base SAS procedures

compute percentiles based on various groups

Reply
Frequent Contributor
Frequent Contributor
Posts: 79

compute percentiles based on various groups

Hi , I have a dataset as the following

date  numberofclusters variable  data

I would like to compute the xthe percentile using the data column but partitioned by date and numberofclusters. I could do it using two for loops but I was wondering if there is a more elegant way to do this.. Thanks very much!

Super User
Posts: 19,770

Re: compute percentiles based on various groups

Proc summary or univariate with a By or Class statement.

proc univariate data=sashelp.cars noprint;

class make;
  var mpg_city;
  output pctlpre=P_ pctlpts= 50, 75 to 100 by 5;
run;

Ask a Question
Discussion stats
  • 1 reply
  • 134 views
  • 0 likes
  • 2 in conversation