04-07-2014 10:24 AM
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!
04-07-2014 10:48 AM
Proc summary or univariate with a By or Class statement.
proc univariate data=sashelp.cars noprint;
output pctlpre=P_ pctlpts= 50, 75 to 100 by 5;