Bookmark and Share

Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: st: RE: Percentiles with basic statistics

From   Maarten Buis <>
Subject   Re: st: RE: Percentiles with basic statistics
Date   Thu, 18 Aug 2011 16:41:06 +0200

On Thu, Aug 18, 2011 at 4:11 PM, Ozgur Ozdemir wrote:
> I have a list of 20 variables in an excel and would like to get the mean, standard dev etc of all variables after eliminating the1% and 99% percentiles. is there any easy way of doing it rather than doing it one by one. thanks

I have a number of comments:

1)  We can only help you with Stata, not with excel (whatever that may be).

2) Do you want this variable by variable, or remove all observations
where at least one variable satisfies your criterion? If you want to
use these variables later together in an estimation command you will
have to use the latter option and live with the fact that you will
loose more than 2% of your observations.

3) This is a very bad idea. Outliers are the most informative
observations, blindly throwing those away should (IMHO) be a crime!

Anyhow, below is an example that shows how to do this over all
variables and variable by variable:

*------------------------ begin example ---------------------
sysuse auto, clear

// store a list of all variables excluding foreign and make in
// a local macro `varl'
ds foreign make, not
local varl `"`r(varlist)'"'

// remove if at least one variable contains "outlier"
gen byte touse = 1
foreach var of local varl {
	qui sum `var', detail
	replace touse = 0 if `var' <= r(p1) | ( `var' >= r(p99) & `var' < .)

// get the means and standard deviations
sum `varl' if touse == 1

// remove "outlier" variable by variable
foreach var of local varl {
	qui sum `var', detail
	sum `var' if `var' > r(p1) & `var' < r(p99)
*---------------- end example -----------------------
(For more on examples I sent to the Statalist see: )

Maarten L. Buis
Institut fuer Soziologie
Universitaet Tuebingen
Wilhelmstrasse 36
72074 Tuebingen
*   For searches and help try:

© Copyright 1996–2018 StataCorp LLC   |   Terms of use   |   Privacy   |   Contact us   |   Site index