Statalist


[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]

RE: st: How to drop some Observation in Stata, if they are out of range?


From   "Martin Weiss" <martin.weiss1@gmx.de>
To   <statalist@hsphsun2.harvard.edu>
Subject   RE: st: How to drop some Observation in Stata, if they are out of range?
Date   Tue, 23 Sep 2008 11:17:39 +0200

In a similar vein, but shorter:
***********
_pctile earnings, p(2.5 97.5)
drop if earnings <r(r1) | earnings >r(r2)
***********


HTH
Martin


-----Original Message-----
From: owner-statalist@hsphsun2.harvard.edu
[mailto:owner-statalist@hsphsun2.harvard.edu] On Behalf Of Neil Shephard
Sent: Tuesday, September 23, 2008 11:14 AM
To: statalist@hsphsun2.harvard.edu
Subject: Re: st: How to drop some Observation in Stata, if they are out of
range?

bumbuminc wrote:
> Thanks for your answer,
> but the problem is i don't now the min and max values. I want to drop
> the observations if they are under 2.5% and over 97.5% of the maximum
> earnings.
> Boris
>   
This would have been useful to state in your original question!

Its not that hard though...

sysuse auto, clear
centile price, centile(2.5)
local min = r(c_1)
centile price, centile(97.5)
local max = r(c_1)
gen restrictedprice = price if(price > `min' & price < `max')

Its general etiquette on Statalist to reply to the list rather than 
individuals as it means that the archives then contain complete 
solutions to problems which are then searchable by others.

Neil


***********************************************************************
This  message  may  contain  confidential and  privileged  information.
If you  are not the  intended recipient  you should not  disclose, copy
or distribute information in this e-mail or take any action in reliance
on its contents.  To do so is strictly  prohibited and may be unlawful.
Please  inform  the  sender that  this  message has  gone astray before
deleting it.  Thank you.

2008 marks the 60th anniversary of the NHS.  It's an opportunity to pay
tribute to the NHS staff and volunteers who help shape the service, and
celebrate their achievements.

If you work for the NHS  and  would like  an NHSmail  email account, go
to: www.connectingforhealth.nhs.uk/nhsmail
***********************************************************************

*
*   For searches and help try:
*   http://www.stata.com/help.cgi?search
*   http://www.stata.com/support/statalist/faq
*   http://www.ats.ucla.edu/stat/stata/

*
*   For searches and help try:
*   http://www.stata.com/help.cgi?search
*   http://www.stata.com/support/statalist/faq
*   http://www.ats.ucla.edu/stat/stata/



© Copyright 1996–2014 StataCorp LP   |   Terms of use   |   Privacy   |   Contact us   |   What's new   |   Site index