I have to merge 2 datasets as below and need only number of rows which are in Dataset 2 (2 in this case) Keys are column ID and B. When i merge it gives me 3 rows as a result of many to many merge. Data final; merge D1 (in=a) D2(in=b); if b; run; Dataset 1 ID B C 1 51 bb 1 51 bb 1 51 bb Dataset 2 ID B D 1 51 aa 1 51 aa This is what i need in result. Final ID B C D 1 51 bb aa 1 51 bb aa
... View more