668
edits
Changes
Jump to navigation
Jump to search
**:Draw the distinct assignees::<code>Z:\allpatentsprocessed\DistinctAssignees2</code>**:Match them against themselves::<code>Z:\allpatentsprocessed\DistinctAssignees2matched</code>
*all data under allpatentsprocessed database
**Join patent data to assignee data, creating firstjoin_cleaned **:again, just look inside database
**join firstjoin_cleaned to matchassignees data, creating secondjoin_cleaned
**join secondjoin_cleaned to lbopatentmatch data, creating thirdjoin_cleaned. This final step matches the LBO data with the patent data, creating a list of LBO's and their patents*:a text file of the final copy can be found here*::<code>Z:\allpatentsprocessed\LBO Patent Data Joined</code>
The Effect of Leverage Buyouts on Innovation (view source)
Revision as of 15:39, 15 June 2016
, 15:39, 15 June 2016no edit summary
:<code>E:\McNair\Software\Scripts\Matcher\Output\LBO_cleaned_data.txt-LBO_cleaned_data.txt.matched</code> Original matched data
:<code>E:\McNair\Projects\LBO\LBO_cleaned_data_duplicates_removed</code>
*Get the patent data
*Load the LBO data into a dbase
*match the LBO data to the patent data
:<code>Z:\allpatentsprocessed\LBO Patent matched</code>
*Note - all data in allpatentsprocessed database:access it by logging on to <code>researcher@McNair DBServ:/bulk/allpatentsprocessed</code>
