Changes

Jump to navigation Jump to search
#Get the patent data
##Draw the distinct assignees
:Z:\allpatentsprocessed\DistinctAssignees2
##Match them against themselves
::Z:\allpatentsprocessed\DistinctAssignees2matched
#Load the LBO data into a dbase
 
#match the LBO data to the patent data
 
#all data under allpatentsprocessed database
 
*access it by logging on to researcher@McNair DBServ:/bulk/allpatentsprocessed
 
##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
*Z:\allpatentsprocessed\LBO_Patent_Data_Joined
668

edits

Navigation menu