Hi David,

I have executed

data1 <- read.table("c:\\mydata\\file1.txt")
data2 <- read.table("c:\\mydata\\file2.txt")

merg12 <- merge(data1, data2)

but am not sure, if it has merged them,
ideally, i would want a new file name for the merged data, based on the
identical IDs,
and i would need to eliminate some column names (fields) which are not
required


Alex



On Tue, Apr 27, 2010 at 2:51 PM, David Winsemius <dwinsemius@comcast.net>wrote:

>
> On Apr 27, 2010, at 1:19 PM, Alex Jameson wrote:
>
> This is a more detailed description of the problem,
>>
>> I have written the following lines of code to read the files
>>
>> data1=("c:\\mydata\\file1.txt")
>> data2=("c:\\mydata\\file2.txt")
>>
>
> NONONO. Read the manual again. Perhaps:
>
> data1 <- read.table("c:\\mydata\\file1.txt")
> data2 <- read.table("c:\\mydata\\file2.txt")
>
>
>> file 1 has fields like patientID, Name which are common in file2, however
>> not all fields are common
>>
>> i would like to create file3.txt with the merged data fields,
>>
>
> And what might happen happened when you tried:
>
> merg12 <- merge(data1, data2)
>
> ??? ...  by default it would merge on the field names (actually column
> names in R-parlance) that were shared by the two dataframes.
>
> --
> David
>
>>
>> i hope this is clear, and i thank everyone, who has responded so far.
>>
>>
>> Alex Jameson
>> Student,
>> University of Colorado
>>
>>        [[alternative HTML version deleted]]
>>
>> ______________________________________________
>> 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<http://www.r-project.org/posting-guide.html>
>> and provide commented, minimal, self-contained, reproducible code.
>>
>
>

	[[alternative HTML version deleted]]

