Difference between revisions of "Job Market Paper Development"

From edegan.com
Jump to navigation Jump to search
imported>Ed
m (Protected "Job Market Paper Development" [edit=private:move=private:read=private])
imported>Ed
Line 1: Line 1:
==Connecting to the Postgres Server==
+
==Postgres Server==
 +
 
 +
===Connecting to the Postgres Server===
  
 
To connect the Postgres server:
 
To connect the Postgres server:
 
  psql -h 128.32.204.203 -U ed_egan StartupInnov
 
  psql -h 128.32.204.203 -U ed_egan StartupInnov
  
==To do on the Postgres Server==
+
===To do on the Postgres Server===
  
 
*Reconfigure IPTables to allow access outside of the Berkeley network.
 
*Reconfigure IPTables to allow access outside of the Berkeley network.
 +
 +
==To do==
 +
 +
===Building out the Diff-in-Diff===
 +
 +
Panel data:
 +
*Unit of observation: Company-year
 +
**Company is in sample from first patent to time of exit (all years)
 +
**Patent and citation stock in each year
 +
*Newey-West Std Errors

Revision as of 18:43, 24 July 2013

Postgres Server

Connecting to the Postgres Server

To connect the Postgres server:

psql -h 128.32.204.203 -U ed_egan StartupInnov

To do on the Postgres Server

  • Reconfigure IPTables to allow access outside of the Berkeley network.

To do

Building out the Diff-in-Diff

Panel data:

  • Unit of observation: Company-year
    • Company is in sample from first patent to time of exit (all years)
    • Patent and citation stock in each year
  • Newey-West Std Errors