Whats is Percentile in SAS?

aman23 — Fri, 22 Feb 2019 18:13:03 GMT

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

Re: Whats is Percentile in SAS?

Reeza — Fri, 22 Feb 2019 18:21:38 GMT

Quantile and Related Statistics

The keywords for quantiles and related statistics are

MEDIAN

is the middle value.

is the 1^st percentile.

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.

is the lower quartile (25^th percentile).

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
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&docsetVersion=9.4&locale=en#n096sxke940tubn1mwmydr89jxdk

@aman23 wrote:

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

Re: Whats is Percentile in SAS?

Satish_Parida — Mon, 25 Feb 2019 09:32:45 GMT

This Document Explains the Percentile.

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

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;

topic Re: Whats is Percentile in SAS? in SAS Programming

Whats is Percentile in SAS?

Re: Whats is Percentile in SAS?

Quantile and Related Statistics

Re: Whats is Percentile in SAS?

Re: Whats is Percentile in SAS?