Dear all,

I am using Stata 16, on mac. I have attached the two excel datasets that I am working with for my project. Both have a variable named movie_title. I want to merge two datasets, so that I will end up with one that has the movie_title, rotten_tomatometer_score, and opening weekend revenue. The problem is that the movies in each of the datasets are not entirely the same and are not in the same order. For example, the first dataset will have Deadpool in the first column but the other has Deadpool in column 50. There are also movies in the second dataset that are not in the first one. For example, the first will have the movie Star Trek Beyond, but the other will not. Does anyone have an idea how I can merge these two together? I honestly have no idea on what to do and would greatly appreciate any help on how to solve this!

Thank you in advance for your help

Jason Browen