Delete rows with Percentile satisfying this expression (use keyword PCTL)

Use this option to delete rows in which the percentile meets the specified criteria.

The expression entered in this field must include the key term PCTL and have the appropriate syntax. Valid expressions include:

•	PCTL GT xx , which instructs the process to eliminate rows in which the percentile z is greater than some number xx ,

•	PCTL LT xx , which instructs the process to eliminate rows in which the percentile z is less than some number xx , and

•	PCTL EQ xx , which instructs the process to eliminate rows in which the percentile z is equal to some number xx .

The number xx is some whole number that you specify in the statement.

The percentile z is specified using the Percentile to Compute for PCTL Statistic field/slider.

To Specify an Expression for Filtering Rows:

Type the desired filtering expression in the text box.

Example : To eliminate rows in which the 80 th percentile exceeds 5, type PCTL GT 5 in the text box (shown below) and specify 80 using the Percentile to Compute for PCTL Statistic field/slider.

If you change your mind and would like to reset the field, click Clear .