Changes

Jump to navigation Jump to search
no edit summary
==References==
 
==Work Description==
==Work Description==
:a text file of the final copy can be found here
::<code>Z:\allpatentsprocessed\LBO Patent Data Joined</code>
 
*create table lbopatentinfo showing lbo names, patent numbers, and grant dates of the patents
 
*use lbopatentinfo to create table lbopatentsummary to show lbo names, amount of patents they have, minimum grant date years, maximum grant date years, and average grant date years
 
*import lbo data matched against itself into table(lbodistinct), then use that table and lbopatentsummary to create to create lbofinal. lbofinal then shows distinct lbonames, number of patents, minimum grant year, maximum grant year, and average grant year
 
*use lbofinal to create lboreallyfinal. lboreallyfinal is the same as lbofinal but with null space in number of patents replaced with 0
*FINAL DATA IN THE FOLLOWING FOLDER
:<code>E:\McNair\Projects\LBO</code>
668

edits

Navigation menu