Re: [R] merging 3 data sets at once

2008-06-04 Thread Ben Bolker
Not following this very carefully, but today I did something similar with Reduce(merge,list(d1,d2,d3)) ... __ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/pos

Re: [R] merging 3 data sets at once

2008-06-04 Thread William Pepe
Bill> Date: Wed, 4 Jun 2008 16:24:04 -0700> From: [EMAIL PROTECTED]> To: r-help@r-project.org> Subject: [R] merging 3 data sets at once> > > Hi All,> > I am looking into merging 3 data sets I know how to do that by merging data1> with data2 and then merging the result

Re: [R] merging 3 data sets at once

2008-06-04 Thread Gabor Grothendieck
Using the built in dataset, women, here is a 3-way merge on height using sqldf: library(sqldf) sqldf("select * from women u, women v, women w where u.height = v.height and v.height = w.height") See home page at http://sqldf.googlecode.com for more info. Its also possible in zoo if you can repre

Re: [R] merging 3 data sets at once

2008-06-04 Thread William Pepe
:04 -0700> From: [EMAIL PROTECTED]> To: r-help@r-project.org> Subject: [R] merging 3 data sets at once> > > Hi All,> > I am looking into merging 3 data sets I know how to do that by merging data1> with data2 and then merging the result with data 3. I was wondering if it&

[R] merging 3 data sets at once

2008-06-04 Thread kayj
Hi All, I am looking into merging 3 data sets I know how to do that by merging data1 with data2 and then merging the result with data 3. I was wondering if it can be done all at once so I tried, M<-merge(data1,data2,data3, by=”ID”) It does not work! Any ideas? -- View this message in contex