There are 2 datasets sales and income.Sales has a variable pno and income has a variable product.Both are same.The third dataset has to be formed by merging sales and income that has the same products.Which is the correct option?
data new;set income(in=IN_A rename=( product = pno)) sales(in=in_b); if IN_A and IN_B;run;
data new;merge income(in=IN_A) (rename( product = pno)) sales(in=IN_B);run;
data new;merge income(in=IN_A) (rename=( product = pno)) sales(in=IN_B);if IN_A and IN_B;run;
data new;merge income(in=IN_A rename=( product = pno)) sales(in=in_b); if IN_A and IN_B;run;