[R] Merging nested files

2008-11-02 Thread David Kaplan
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

Re: [R] Merging nested files

2008-11-02 Thread Erik Iverson
Hello - David Kaplan 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

Re: [R] Merging nested files

2008-11-02 Thread Gabor Grothendieck
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

Re: [R] Merging nested files

2008-11-02 Thread David Kaplan
I think this will work. Thanks. But, is there a command to merge on a string variable. All I have is the country 3 letter designation. Thanks again, David === David Kaplan, Ph.D. Professor Department of Educational