BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
Hi everybody,
-I want to get my sample divided into 5 quintiles based on the variable "v1".
Can you help me in this?
Cheers, Malek
1 ACCEPTED SOLUTION

Accepted Solutions
data_null__
Jade | Level 19
proc rank data=sashelp.class out=quintiles groups=5;
 var weight;
 ranks q;
run;
proc print;
run;

 

What if I needed to trim for the outliers (1%) before ranking for the quintiles? 


@Paige answered: Proc Rank or Proc Univariate can inform you which data points are in the top or bottom 1%.

 

See more discussion about Winsorization and trimmed means in this blog post.

View solution in original post

3 REPLIES 3
data_null__
Jade | Level 19
proc rank data=sashelp.class out=quintiles groups=5;
 var weight;
 ranks q;
run;
proc print;
run;

 

What if I needed to trim for the outliers (1%) before ranking for the quintiles? 


@Paige answered: Proc Rank or Proc Univariate can inform you which data points are in the top or bottom 1%.

 

See more discussion about Winsorization and trimmed means in this blog post.

deleted_user
Not applicable
Thanks this was helpful!
What if I needed to trim for the outliers (1%) before ranking for the quintiles?
Paige
Quartz | Level 8
Proc Rank or Proc Univariate can inform you which data points are in the top or bottom 1%.

sas-innovate-2026-white.png



April 27 – 30 | Gaylord Texan | Grapevine, Texas

Registration is open

Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!

Register now

What is ANOVA?

ANOVA, or Analysis Of Variance, is used to compare the averages or means of two or more populations to better understand how they differ. Watch this tutorial for more.

Find more tutorials on the SAS Users YouTube channel.

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