topic Re: compute percentiles based on various groups in SAS Procedures https://communities.sas.com/t5/SAS-Procedures/compute-percentiles-based-on-various-groups/m-p/170414#M44042 <HTML><HEAD></HEAD><BODY><P>Proc summary or univariate with a By or Class statement. </P><P></P><P><STRONG>proc univariate data=sashelp.cars noprint;</STRONG></P><P><STRONG>class make;<BR />&nbsp; var mpg_city;<BR />&nbsp; output pctlpre=P_ pctlpts= 50, 75 to 100 by 5;<BR />run;</STRONG></P></BODY></HTML> Mon, 07 Apr 2014 14:48:09 GMT Reeza 2014-04-07T14:48:09Z compute percentiles based on various groups https://communities.sas.com/t5/SAS-Procedures/compute-percentiles-based-on-various-groups/m-p/170413#M44041 <HTML><HEAD></HEAD><BODY><P>Hi , I have a dataset as the following</P><P></P><P>date&nbsp; numberofclusters variable&nbsp; data</P><P></P><P>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!</P></BODY></HTML> Mon, 07 Apr 2014 14:24:39 GMT https://communities.sas.com/t5/SAS-Procedures/compute-percentiles-based-on-various-groups/m-p/170413#M44041 hdg 2014-04-07T14:24:39Z Re: compute percentiles based on various groups https://communities.sas.com/t5/SAS-Procedures/compute-percentiles-based-on-various-groups/m-p/170414#M44042 <HTML><HEAD></HEAD><BODY><P>Proc summary or univariate with a By or Class statement. </P><P></P><P><STRONG>proc univariate data=sashelp.cars noprint;</STRONG></P><P><STRONG>class make;<BR />&nbsp; var mpg_city;<BR />&nbsp; output pctlpre=P_ pctlpts= 50, 75 to 100 by 5;<BR />run;</STRONG></P></BODY></HTML> Mon, 07 Apr 2014 14:48:09 GMT https://communities.sas.com/t5/SAS-Procedures/compute-percentiles-based-on-various-groups/m-p/170414#M44042 Reeza 2014-04-07T14:48:09Z