[R] Merge function - Return NON matches

[MacQueen, Don]

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" <rrumple at 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 at 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.