Programming the statistical procedures from SAS

Quintiles!

Accepted Solution Solved
Reply
N/A
Posts: 0
Accepted Solution

Quintiles!

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

Accepted Solutions
Solution
3 weeks ago
Respected Advisor
Posts: 3,773

Re: Quintiles!

[ Edited ]
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


All Replies
Solution
3 weeks ago
Respected Advisor
Posts: 3,773

Re: Quintiles!

[ Edited ]
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.

N/A
Posts: 0

Re: Quintiles!

Thanks this was helpful!
What if I needed to trim for the outliers (1%) before ranking for the quintiles?
Super Contributor
Posts: 281

Re: Quintiles!

Proc Rank or Proc Univariate can inform you which data points are in the top or bottom 1%.
☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

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