Hi
Thanks for your reply. I am attaching datasets i am working on and output i am getting. I will explain what output i need.
dataset unmapped - contains branch code(brcode) and account id which arent mapped
dataset managersFinal - contains list of managers who can be assigned those accounts. this dataset contains names of managers multiple times, indicating those many more accounts can be assigned to them.
dataset assigned - the output i am getting when i execute following data step -
data icici.assigned;
merge unmapped (in=a) managersfinal (in=b);
by brcode;
if a and b ;
run;
issue with my output:
total observations for branch 1 in the unmapped dataset are 148
total managers that can be assigned account for branch 1 are 366
so output dataset should contain only 148 observations for branch 1
we need to merge datasets based on branch code value.
Expected output -
fin