compute percentiles based on various groups

[hdg]

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!

[Reeza]

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;