Thanks once again for your help! I figured the issue was with another program used to convert CSV into a sas dataset. Because of which some hidden spaces were getting saved in the column values used for merging. I recreated the dataset and it solved the issue.
... View more
