Quintile cut offs

[This widget could not be displayed.]

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 

[This widget could not be displayed.]

Would this be acceptable?

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

class quintiles;

var Score ;

run;

[PaigeMiller · Accepted solution]

---

@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;

[This widget could not be displayed.]

Thank you ver much!

[Ksharp]

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;

[This widget could not be displayed.]

Thank you very much!