Read them into data frames and then use the R sqldf package: http://sqldf.googlecode.com
On Sun, Nov 2, 2008 at 12:04 PM, David Kaplan <[EMAIL PROTECTED]> wrote: > Greetings all, > > I have three files that I would like to merge. The first is a student level > file that contains the student ID, their school ID, and their country ID. > > The second is the school file that contains the school ID and country ID. > > The third is the country file with a country ID. > > I would like to merge the three together using the common country ID. Of > course, what this would mean is that school data be repeated for every > student in their school, and country data repeated for every school and > student in that country. > Any direction would be helpful. > > Thanks in advance, > > David > > > -- > ======================================================================= > David Kaplan, Ph.D. > Professor > Department of Educational Psychology > University of Wisconsin - Madison > Educational Sciences, Room, 1061 > 1025 W. Johnson Street > Madison, WI 53706 > > email: [EMAIL PROTECTED] > homepage: > http://www.education.wisc.edu/edpsych/default.aspx?content=kaplan.html > Phone: 608-262-0836 > > ______________________________________________ > 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/posting-guide.html > and provide commented, minimal, self-contained, reproducible code. > ______________________________________________ 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/posting-guide.html and provide commented, minimal, self-contained, reproducible code.
