Assuming everything else is good, the "all" or "all.x" or "all.y" arguments to merge() should do what I think you're asking for. You did read the help page for merge, right?
-Don -- Don MacQueen Lawrence Livermore National Laboratory 7000 East Ave., L-627 Livermore, CA 94550 925-423-1062 On 4/26/12 12:33 PM, "RHelpPlease" <rrum...@trghcsolutions.com> wrote: >Hi there, >I wish to merge a common variable between a list and a data.frame & return >rows via the data.frame where there is NO match. Here are some details: > >The list, where the variable/col.name = CLAIM_NO >CLAIM_NO >20 >83 >1440 >4439 >7002 >... > >> dim(hrc78_clm_no) >[1] 6678 1 > >The data.frame, where there exists a variable with the same name, >CLAIM_NO. >> dim(bestPartAreadmin) >[1] 13068 93 > >I wish to merge the two together & only return a data.frame where there is >NO match in the CLAIM_NO between both files. > >I've read & tried code via the "merge" function. If "merge" can do this, >I'm missing something with the available options. > >I'm figuring something like: > >clm_no_nomatch <- merge(hrc78_clm_no, bestPartAreadmin, by = "CLAIM_NO", >.. >.. ..) > >Your help is most appreciated! > > > >-- >View this message in context: >http://r.789695.n4.nabble.com/Merge-function-Return-NON-matches-tp4590755p >4590755.html >Sent from the R help mailing list archive at Nabble.com. > >______________________________________________ >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.
