topic Re: How to calculate Percentile in SAS Procedures

How to calculate Percentile

ross_geller — Wed, 28 Oct 2009 16:44:33 GMT

Is there a SAS method to calculate Percentile that matches the Excel function 'PERCENTILE'?

Which is the difference between each SAS method?

Thanks in advance,
Giuseppe

Re: How to calculate Percentile

sbb — Wed, 28 Oct 2009 19:00:17 GMT

Have you investigated PROC UNIVARIATE?

Base Procedures Guide: Statistical Procedures -- Calculating Percentiles
http://support.sas.com/documentation/cdl/en/procstat/63032/HTML/default/procstat_univariate_sect028.htm

Scott Barry
SBBWorks, Inc.

Re: How to calculate Percentile

ross_geller — Thu, 29 Oct 2009 08:27:07 GMT

Thanks Scott, it was really what i was looking for.

Regards
-giuseppe

Re: How to calculate Percentile

matt_w — Tue, 10 Apr 2012 10:54:52 GMT

The link you supplied is helpful, but I don't know how to replicate Excel's behaviour (whether that's desirable or not is another question...)

e.g.

data
0
0
1
3
4
7
9
13
18
20
26
29
43
46
49
58
73
78
162

Results

Excel calc	Result
percentile(range,0.25)	5.5
percentile(range,0.5)	20
percentile(range,0.75)	47.5
percentile(range,0.95)	86.4

Does anyone know what settings to apply to ensure SAS replicates Excel's behaviour using this example data?

Thanks

Matt