Changes

{{McNair ProjectsProject|Has project output=|Project TitleHas title=Matching VentureOne (Data)|Topic Area=Patents and Innovation|OwnerHas owner=Ariel Sun, Rosemarie Ziedonis|Start TermHas start date=Summer 2016|StatusDue Date=NA|Has sponsor=McNair Center|Has notes=|Is dependent on=Active|DeliverableDepends upon it=Other|Primary BillingHas project status= AccMcNair01Complete

#*re-run the match using *both* name-related fields in the startups_cl.dta file: “name” and “name_prev”.*#the latter field pulls in patents applied for under a former name of the same company

#*in the output file, please include…*#include the field “entityid” that corresponds to each startup (this step is critical; else, we can’t link patents filed under alternative names of the company to the same firm); in startups_cl.dta*#all assignee-related fields in your patent data (e.g., assignee name, and any original and current uspto assignee codes listed for the patent); merge in from your patent files

Text files are in:<code>E:\McNair\Projects\Venture One Data\</code>#<code>summarytablefinal</code>: summary on number of patents and grant year for all companies#<code>ullyjoinedtable</code>: all patent and assignee information for entities that have patents (combining 3 and 4)#<code>fullyjoinednow</code>: patent information under current name of the company#fullyjoinedprec<code>fullyjoinedprev</code>: patent information under previous name of the company  A new version of sql script can be cound at :<code>E:\McNair\Projects\Venture One Data\sql script.txt</code>

</includeonly><!-- flush flush --><!-- flush flush --><!-- flush flush --><!-- flush -->