Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: st: merge not in (exclude)
From
[email protected] (Brendan Halpin)
To
[email protected]
Subject
Re: st: merge not in (exclude)
Date
Tue, 15 Mar 2011 23:07:55 +0000
On Tue, Mar 15 2011, Nicholas Winter wrote:
> If I understand what you want to do, something like this:
>
> use A
> desc using B, varlist
> foreach v in `r(varlist)' {
> capture drop `v'
> if !_rc local dropped `dropped' `v'
> }
> di "Dropped: `dropped'
I read the OP as asking for
. use A
. merge 1:1 name using B
. drop if _merge==3
but the question is a little ambiguous (at least, not knowing SQL that
well).
Brendan
--
Brendan Halpin, Department of Sociology, University of Limerick, Ireland
Tel: w +353-61-213147 f +353-61-202569 h +353-61-338562; Room F1-009 x 3147
mailto:[email protected] http://www.ul.ie/sociology/brendan.halpin.html
*
* 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/