44
edits
Changes
Jump to navigation
Jump to search
VC Startup Matching Stata Work (view source)
Revision as of 17:14, 11 July 2018
, 17:14, 11 July 2018→Building new Dataset in SQL for a Linear Probability Model
To run the linear probability model, we need to build a new dataset. This was partially done in the Stata Do-File explained above, but doing it in SQL will give the opportunity to be more flexible when choosing the synthetic match.
The idea is to build, for each startup, a new dataset that matches all VCs that were active in the year it matched with the real VC AND that were in the same Industry 100 code. This new set of synthetic firm VCs (with VCs characteristics) for each startup will then be appended to the real match dataset.
