Quintile cut offs

Hello,

I have a question about quintiles please. I divided a score into quintiles. In SAS how can I get the exact cut offs of each quintile and then how can I calculate the median value of each quintile please?

I would appreciate any help!

Thank you

1 ACCEPTED SOLUTION

Accepted Solutions
Diamond | Level 26

Re: Quintile cut offs

@anonymous_user wrote:

I have a question about quintiles please. I divided a score into quintiles. In SAS how can I get the exact cut offs of each quintile and then how can I calculate the median value of each quintile please?

Since the median of a quintile is itself a percentile, you want the 10, 20, 30, 40 ... percentiles. So you really want

``proc means data=new min p10 p20 p30 p40 p50 p60 p70 p80 p90 max;``
--
Paige Miller
5 REPLIES 5

Re: Quintile cut offs

Would this be acceptable?

proc means data=new min p20 p40 p60 p80 max median ;

class quintiles;

var Score ;

run;

Diamond | Level 26

Re: Quintile cut offs

@anonymous_user wrote:

I have a question about quintiles please. I divided a score into quintiles. In SAS how can I get the exact cut offs of each quintile and then how can I calculate the median value of each quintile please?

Since the median of a quintile is itself a percentile, you want the 10, 20, 30, 40 ... percentiles. So you really want

``proc means data=new min p10 p20 p30 p40 p50 p60 p70 p80 p90 max;``
--
Paige Miller

Re: Quintile cut offs

Thank you ver much!

Super User

Re: Quintile cut offs

Use PROC RANK to get quantitle.
proc rank data=have out=temp;
var variable;
ranks group;
run;

Use PROC SQL to get min max or cut off value and median.
proc sql;
select group,min(variable) as min,max(variable) as max,median(variable) as median
from temp
group by group;
quit;

Re: Quintile cut offs

Thank you very much!

Discussion stats
• 5 replies
• 1721 views
• 2 likes
• 3 in conversation