BookmarkSubscribeRSS Feed
ross_geller
Calcite | Level 5
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
3 REPLIES 3
sbb
Lapis Lazuli | Level 10 sbb
Lapis Lazuli | Level 10
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....


Scott Barry
SBBWorks, Inc.
ross_geller
Calcite | Level 5
Thanks Scott, it was really what i was looking for.

Regards
-giuseppe
matt_w
Calcite | Level 5

Hi

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 calcResult
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

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 3 replies
  • 2892 views
  • 0 likes
  • 3 in conversation