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
@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;
Would this be acceptable?
proc means data=new min p20 p40 p60 p80 max median ;
class quintiles;
var Score ;
run;
@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;
Thank you ver much!
Thank you very much!
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.