thank you for your response, the code works except that have1 has 3000 observations, have2 has 100000 observations. I want to have the final output to have 3000 observations, some items matched with have2 some unmatched. using this code, i have an output with around 100000 observations.
Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss. Register now and lock in 2025 pricing—just $495!