topic Re: Calculating Percentiles in New SAS User

Calculating Percentiles

bnd — Sun, 15 Mar 2020 21:46:37 GMT

Hello,

I am trying to calculate the top 25% and bottom 25% for a change score variable. The top 25% indicates high increases in scores and the bottom 25% indicates smaller increases in scores. Is there a way to determine the top 25% of scores and the bottom 25% of scores using proc means or proc univariate in SAS?

Thanks!

Re: Calculating Percentiles

Reeza — Sun, 15 Mar 2020 21:53:59 GMT

Use PROC RANK with GROUPS=4.

proc rank data=sashelp.cars groups=4 out=cars;
var mpg_city;
ranks mpg_city_rank;
run;

Haven't verified the code but the idea is there.

@bnd wrote:

Hello,

I am trying to calculate the top 25% and bottom 25% for a change score variable. The top 25% indicates high increases in scores and the bottom 25% indicates smaller increases in scores. Is there a way to determine the top 25% of scores and the bottom 25% of scores using proc means or proc univariate in SAS?

Thanks!

Re: Calculating Percentiles

PaigeMiller — Sun, 15 Mar 2020 21:55:01 GMT

PROC UNIVARIATE, PROC MEANS and PROC SUMMARY will compute the 25th percentile, the 75th percentile and many other percentiles upon request.

Re: Calculating Percentiles

bnd — Sun, 15 Mar 2020 22:10:31 GMT

Thank you @Reeza! The proc rank procedure allowed me to group the variable into quartiles. But, how would I go about getting the actual top 25% of scores and the bottom 25% of scores once the scores are grouped into the four quartiles? Also, the groups start at 0 rather than 1.

Re: Calculating Percentiles

Reeza — Sun, 15 Mar 2020 22:18:14 GMT

Group=0 are your bottom 25% and Group=3 is your top 25%. Yes the groups start from 0 and go to 3, you can add one to it, if that helps you.

Re: Calculating Percentiles

PaigeMiller — Sun, 15 Mar 2020 22:40:20 GMT

@bnd wrote:

But, how would I go about getting the actual top 25% of scores and the bottom 25% of scores once the scores are grouped into the four quartiles?

PROC UNIVARIATE, PROC MEANS or PROC SUMMARY will calculate these percentiles.

Re: Calculating Percentiles

bnd — Mon, 16 Mar 2020 03:30:17 GMT

Thanks so much! @PaigeMiller

Re: Calculating Percentiles

bnd — Mon, 16 Mar 2020 03:31:39 GMT

Okay, now I understand! Thanks so much! @Reeza

Re: Calculating Percentiles

ballardw — Mon, 16 Mar 2020 20:20:14 GMT

The report procedures Tabulate and Report as well will do some percentiles. An example of calculating P25 and P75 for 3 variables, horsepower mpg_city and weight grouped by 3 categories, type drivetrain and number of cylinders from the SASHELP.CARS data.

proc tabulate data=sashelp.cars;
   class type  drivetrain cylinders;
   var horsepower mpg_city weight;
   table type  drivetrain cylinders,
         (horsepower mpg_city) *(p25 p75)
   ;
run;