44
edits
Changes
Jump to navigation
Jump to search
The idea is We want to build, create a table that lists for each startupunique portco all its eligible firms, ie, a new dataset that matches all VCs that were active in the year it matched with had its first investment from the real matched VC AND and that were had invested in a portco of the same Industry 100 codecode100 in that year. This new set of synthetic VCs (with VCs characteristics) for each startup will then be appended to After that we can simply append/union the real match table and calculate the variables from the original dataseton this new table. The final code is called 'CreatingLPM_withoutsyn.sql'
VC Startup Matching Stata Work (view source)
Revision as of 17:38, 20 July 2018
, 17:38, 20 July 2018→Building new Dataset in SQL for a Linear Probability Model
==Building new Dataset in SQL for a Linear Probability Model==
E:\McNair\Projects\MatchingEntrepsToVC\Stata\SQL\
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.
