Re: [R] Mapping two data files

2014-02-20 Thread farnoosh sheikhi
Thank you so much Arun:)   On Wednesday, February 19, 2014 6:06 PM, arun wrote: Hi Farnoosh, Try: library(plyr) res <- join(`DATA-A`,`DATA-B`,by="Var1",type="right")[,c(3,1:2,4)]  head(res) #  ID   Var1   Var2 var3 #1  1 AETNA CARDINAL CARE TIER 2      10 #2  2 

Re: [R] Mapping two data files

2014-02-19 Thread arun
Hi Farnoosh, Try: library(plyr) res <- join(`DATA-A`,`DATA-B`,by="Var1",type="right")[,c(3,1:2,4)]  head(res) #  ID   Var1   Var2 var3 #1  1 AETNA CARDINAL CARE TIER 2      10 #2  2  AETNA EPO Group1  110 #3  3 BLUE CARD INTE Group1    2 #4  4