Whats is Percentile in SAS?

aman23 · Posted 02-22-2019 01:13 PM

What is percentile in SAS??? what are the different ways to calculate the same??

Reeza · Posted 02-22-2019 01:21 PM

Quantile and Related Statistics

The keywords for quantiles and related statistics are

MEDIAN

is the middle value.

P1

is the 1^st percentile.

P5

is the 5^th percentile.

P10

is the 10^th percentile.

P90

is the 90^th percentile.

P95

is the 95^th percentile.

P99

is the 99^th percentile.

Q1

is the lower quartile (25^th percentile).

Q3

is the upper quartile (75^th percentile).

QRANGE

is interquartile range and is calculated as

table with 1 row and 1 column , row1 column 1 , q sub 3 , minus , q sub 1 , end table

You use the QNTLDEF= option (PCTLDEF= in PROC UNIVARIATE) to specify the method that the procedure uses to compute percentiles. Let

be the number of nonmissing values for a variable, and let

x sub 1 , comma , x sub 2 , comma dot dot dot comma , x sub n

represent the ordered values of the variable such that

is the smallest value,

is next smallest value, and

is the largest value. For the tth percentile between 0 and 1, let

. Then define

as the integer part of

and

as the fractional part of

or

, so that

table with 2 rows and 2 columns , row1 column 1 , , column 2 n p equals j plus g , w h e n . q n t l d e f equals 1 comma 2 comma 3 comma o r 5 , row2 column 1 , , column 2 open n plus 1 close . p equals j plus g . w h e n q n t l d e f equals 4 , end table

Here, QNTLDEF= specifies the method that the procedure uses to compute the tth percentile, as shown in the table that follows.

When you use the WEIGHT statement, the tth percentile is computed as

table with 1 row and 1 column , row1 column 1 , y equals left brace . table with 2 rows and 2 columns , row1 column 1 , 1 half . open , x sub i , plus . x sub i plus 1 end sub . close , column 2 if . modified cap sigma with j equals 1 below and with i above . w sub j , equals p w , row2 column 1 , x sub i plus 1 end sub , column 2 if . modified cap sigma with j equals 1 below and with i above . w sub j , less than p w less than . modified cap sigma with j equals 1 below and with i plus 1 above . w sub j , end table , end table

where

is the weight associated with

and

w equals . modified cap sigma with i equals 1 below and with n above . w sub i

is the sum of the weights. When the observations have identical weights, the weighted percentiles are the same as the unweighted percentiles with QNTLDEF=5.

Methods for Computing Quantile Statistics
QNTLDEF=	Description	Formula
1	weighted average at
1	weighted average at	where is taken to be
2	observation numbered closest to		if
			if and is even
			if and is odd
		where i is the integer part of
3	empirical distribution function		if
3	empirical distribution function		if
4	weighted average aimed at
4	weighted average aimed at	where is taken to be
5	empirical distribution function with averaging		if
5	empirical distribution function with averaging		if

https://documentation.sas.com/?docsetId=proc&docsetTarget=p0v0y1on1hbxukn0zqgsp5ky8hc0.htm&docsetVer...

@aman23 wrote:

What is percentile in SAS??? what are the different ways to calculate the same??

VDD · Posted 02-22-2019 01:21 PM

here is a nice link

http://support.sas.com/documentation/cdl/en/procstat/66703/HTML/default/viewer.htm#procstat_univaria...

on the examples tabs you should be-able to find your needs

http://support.sas.com/documentation/cdl/en/procstat/66703/HTML/default/viewer.htm#procstat_univaria...

Satish_Parida · Posted 02-25-2019 04:32 AM

This Document Explains the Percentile.

http://support.sas.com/documentation/cdl/en/procstat/66703/HTML/default/viewer.htm#procstat_univaria...

Example:

data Heights(drop=i);
do i=1 to 1000;
	Height=round(ranuni(8)*100,.01);
	output;
end;
run;

title 'Analysis of Female Heights';
ods select Quantiles;
proc univariate data=Heights ciquantdf(alpha=.1);
   var Height;
run;