Statalist The Stata Listserver


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

st: RE: Quick Question on how to drop individual observations


From   "Nick Cox" <[email protected]>
To   <[email protected]>
Subject   st: RE: Quick Question on how to drop individual observations
Date   Fri, 16 Jun 2006 17:01:52 +0100

I assume that this reads  

hhold 1  rd 1
hhold 1  rd 2
hhold 1  rd 2
hhold 1  rd 3

so that this example includes 4 observations. 

It sounds as if you want 

gen long obsno = _n 

gen byte different = hhold != rd 
bysort hhid (different obsno) : drop if _n == 1 & !different 

sort obsno 

-different- is 0 if -hhold- is equal to -rd- and 1 otherwise. 

Nick 
[email protected] 

JEFFREY ROSEN
 
> I have a very basic question. The panel set that I am using 
> is identified by hhold and rd. A few of the observations 
> contains the same hhold and rd. For example:
> 
> hhold 1
> rd 1
> hhold 1
> rd 2
> hhold 1
> rd 2
> hhold 1
> rd 3
> 
> I would like to drop the first observation where the hhold 
> and rd are identical. How do I do so?

*
*   For searches and help try:
*   http://www.stata.com/support/faqs/res/findit.html
*   http://www.stata.com/support/statalist/faq
*   http://www.ats.ucla.edu/stat/stata/



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