I need to compile a data set with variables from two existing data sets. I need financial and patent data for a number of companies for 20 years (1987-2006). The financial data is found in Compustat (I have access) and the patent data is given by the NBER (publicly available).
I need to merge variables from both into one dataset.