Hi Alex merge wont write a file automatically. You need to use something which can direct the output to a file.
write.table(merge12, file = "output.data" ) should do the trick. Read more at ?write.table -Abhi On Tue, Apr 27, 2010 at 5:23 PM, Alex Jameson <ajameso...@gmail.com> wrote: > David, > > merg12 > > displays the files > with this message at the bottom > > [reached getOption("max.print") -- omitted 321526 rows]] > > str(merg12) displays the following message > > 'data.frame' : 329218 obs. of 13 variables > > $ patientid: > $ Name: > $ Age: > > but no file is created in the folder mydata > > i would expect a file to be created, which is not happening > > Thank you > > Alex > > > On Tue, Apr 27, 2010 at 4:41 PM, David Winsemius > <dwinsem...@comcast.net>wrote: > >> >> On Apr 27, 2010, at 4:23 PM, Alex Jameson wrote: >> >> 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, >>> >> >> That is what you should have gotten. what happens when you type >> >> merg12 >> >> ?? >> >> and i would need to eliminate some column names (fields) which are not >>> required >>> >> >> That can be don easily. Show us: >> >> str(merg12) >> >> >> -- David. >> >> >>> >>> Alex >>> >>> >>> >>> On Tue, Apr 27, 2010 at 2:51 PM, David Winsemius <dwinsem...@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> >>>>> <http://www.r-project.org/posting-guide.html> >>>>> >>>>> and provide commented, minimal, self-contained, reproducible code. >>>>> >>>>> >>>> >>>> >>> [[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. >>> >> >> David Winsemius, MD >> West Hartford, CT >> >> > > [[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 > 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.