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-2024.png

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.

 

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
  • 16306 views
  • 0 likes
  • 3 in conversation