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 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
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.