Message-ID: <429AC0B1-87C6-4087-ADD7-54E1D8A6DE48@comcast.net>
Date: 2016-04-20T19:44:39Z
From: David Winsemius
Subject: Merging Data Sets with Full Outer Join
In-Reply-To: <OFCEAA073F.71D9D863-ONC1257F9B.0022E7D3-C1257F9B.0023124A@lotus.hawesko.de>
> On Apr 19, 2016, at 11:23 PM, G.Maubach at weinwolf.de wrote:
>
> Hi All,
>
> I would like to match some datasets. Both deliver variables AND cases
> which might or might not be present in all datasets:
>
> This sequence
>
> Kunden <- Kunden_2011
> Kunden <- merge(Kunden, Kunden_2012,
> by.x = "Debitor", by.y = "Debitor")
>
> Kunden <- merge(Kunden, Kunden_2013,
> by.x = "Debitor", by.y = "Debitor")
>
> Kunden <- merge(Kunden, Kunden_2014,
> by.x = "Debitor", by.y = "Debitor")
>
> Kunden <- merge(Kunden, Kunden_2015,
> by.x = "Debitor", by.y = "Debitor")
>
> delivers too few cases. So I guess it does an equi-join.
You should not be guessing. Read the help page. It calls the default setting a natural join.
>
> How can I join the datasets and keep the variables as well as the cases?
>
If you want a full outer join use all=TRUE. This, too, should have been in the ?merge help page.
> I am looking forward to your reply.
>
> Kind regards
>
> Georg
>
> ______________________________________________
> R-help at r-project.org mailing list -- To UNSUBSCRIBE and more, see
> https://stat.ethz.ch/mailman/listinfo/r-help
> PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
> and provide commented, minimal, self-contained, reproducible code.
David Winsemius
Alameda, CA, USA