topic Re: Quintile cut offs in SAS Programming

Quintile cut offs

anonymous_user — Fri, 24 Apr 2020 09:42:31 GMT

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

Re: Quintile cut offs

anonymous_user — Fri, 24 Apr 2020 10:06:21 GMT

Would this be acceptable?

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

class quintiles;

var Score ;

run;

Re: Quintile cut offs

PaigeMiller — Fri, 24 Apr 2020 11:17:12 GMT

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

Re: Quintile cut offs

Ksharp — Fri, 24 Apr 2020 11:21:21 GMT

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

anonymous_user — Fri, 24 Apr 2020 11:25:02 GMT

Thank you ver much!

Re: Quintile cut offs

anonymous_user — Fri, 24 Apr 2020 11:25:28 GMT

Thank you very much!