Whats is Percentile in SAS?

[aman23]

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

[Reeza]

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

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

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

where  is the weight associated with  and  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
		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
			if
4	weighted average aimed at
		where  is taken to be
5	empirical distribution function with averaging		if
			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]

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]

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;