How do I calculate the 40th and 60th percentile of a column in SAS EG?
Either 4.2 or 5.1.
Thanks!
Hi, Reeza
40 and 60 have been added to PROC MEANS, but not the EG interface. However, easy to do:
1. Select your data.
2. Summary Statistics task.
3. Put your VAR variable in the Analysis variables, and set up the rest of the task.
4. Select Preview code.
5. Select Insert Code
6. At the end of all of the parameters for the PROC MEANS statement, before the semicolon, double-click on the "double-click to insert code" entry point.
7. In the Enter User Code box, type
P40 P60
OK your way out, and close the preview code window. When you run, you should get the 40th and 60th percentiles.
Tom
Hi, Reeza
40 and 60 have been added to PROC MEANS, but not the EG interface. However, easy to do:
1. Select your data.
2. Summary Statistics task.
3. Put your VAR variable in the Analysis variables, and set up the rest of the task.
4. Select Preview code.
5. Select Insert Code
6. At the end of all of the parameters for the PROC MEANS statement, before the semicolon, double-click on the "double-click to insert code" entry point.
7. In the Enter User Code box, type
P40 P60
OK your way out, and close the preview code window. When you run, you should get the 40th and 60th percentiles.
Tom
Any idea how to get all the 99 percentiles on SAS EG or through a program?
I actually have 6 values of which I need 99 percentiles (combined). I'm trying everything available online but not getting a clue.
Kindly help me if possible.
PROC UNIVARIATE can provide this. Check the documentation.
99th Percentile is an option in the Summary Statistics task (Describe menu).
Here's an example sequence.
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.
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.