Changes
Jump to navigation
Jump to search
*#Accounting vars were converted to 2011 real values using the official BEA implicit GDP price deflator index: http://www.bea.gov/national/nipaweb/TableView.asp?SelectedTable=13&ViewSeries=NO&Java=no&Request3Place=N&3Place=N&FromView=YES&Freq=Year&FirstYear=1978&LastYear=2010&3Place=N&Update=Update&JavaBox=no)
→Processing Notes
*And many others. These will be reviewed and excluded.
====Dataset Processing Notes====
#The data was imported into Postgres. There were 41,572 records
#LBO data was retrieved and processed. 164 observations were discarded.
#Acquisition Histories were calculated as number of past acquisitions for each acquirer: Total, VC only, Non-VC only
#Percentage variables were multiplied by 100 to get nice coefficients
#Every observation was assigned a unique observation number (obsno)
*The NormalizeFixedWidth.pl script uses the spacing in the header to determine the column breaks. The EquityValue column has two spaces in front of its name that screws this. Both EquityValue and EnterpriseValue needed to be imported as varchar(10), as they have the code 'np' in some observations.
*The NormalizeFixedWidth.pl script was modified so that it only drops commas in numbers and not those in names etc.
===CRSP Data===
