First you need to clarify what you'd like to happen when the ID in B is not unique. What do you want the resulting dataframe to look like?
Some possible answers involve using different options for merge() or using unique() to remove duplicates from B before merging. But at least to me, "merge or retrieve the common ones" isn't clear enough to be able to say which. Sarah On Wed, Aug 25, 2010 at 5:35 AM, Mangalani Peter Makananisa <pmakanan...@sars.gov.za> wrote: > Dear R Gurus, > > > > I am currently working on the two dataset ( A and B), they both have the > same fields: ID , REGION, OFFICE, CSTART, CEND, NCYCLE, STATUS and > CB. > > I want to merge the two data set by ID. The problem I have is that the > in data A, the ID's are unique. However in the data set B, the ID's are > not unique, thus some repeat themselves. > > > > How do I the merge or retrieve the common ones? > > Please advise. > > > > Kind Regards > > > > Peter > -- Sarah Goslee http://www.functionaldiversity.org ______________________________________________ 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.