LBO Data Description - Revision history

Ed at 21:44, 5 October 2020

2020-10-05T21:44:31Z

Ed at 21:43, 5 October 2020

2020-10-05T21:43:21Z

JakeSilberman: /* Introduction of Compustat and Preparation for Stata */

2016-08-03T16:39:05Z

Introduction of Compustat and Preparation for Stata

JakeSilberman at 15:44, 3 August 2016

2016-08-03T15:44:48Z

JakeSilberman: /* Resources */

2016-08-03T15:41:17Z

Resources

JakeSilberman: /* Resources */

2016-08-03T15:41:04Z

Resources

JakeSilberman: /* Introduction of Compustat and Preparation for Stata */

2016-08-03T15:39:09Z

Introduction of Compustat and Preparation for Stata

JakeSilberman: /* LBO Data and Patent Data */

2016-08-03T15:35:51Z

LBO Data and Patent Data

JakeSilberman: /* Work Description */

2016-08-03T15:35:16Z

Work Description

Ed at 21:51, 2 August 2016

2016-08-02T21:51:24Z

← Older revision		Revision as of 21:44, 5 October 2020
Line 1:		Line 1:
		+	{{Project
		+	\|Has project output=Content
		+	\|Has sponsor=McNair Center
		+	\|Has title=LBO Data Description
		+	\|Has owner=James Chen,Brian Ayash,Ed Egan
		+	\|Has project status=Complete
		+	}}
		+
		+
	This page is included in the project [[Leveraged Buyout Innovation (Academic Paper)]]		This page is included in the project [[Leveraged Buyout Innovation (Academic Paper)]]
	==Work Scripts==		==Work Scripts==

← Older revision		Revision as of 21:43, 5 October 2020
Line 232:		Line 232:
	RE -- Retained Earnings		RE -- Retained Earnings

		+	==SQL Fixes==
		+	(Moved here from deleted page: LBO Fix List)
		+
		+	*Improve SIC to NAICS fill in further
		+	**Manually add in conversions from three digit SIC (e.g., 1110) to three digit NAICS (e.g., 134)
		+	**Re-import into STATA


	[[category:Internal]]		[[category:Internal]]

@@ Line 107: / Line 107: @@
 *'''statastaging''' with all variables from compupatentlboyearsummary in addition to all the pulled compustat variables
-*'''sicnaicsconversion''' with sic codes and naics codes as a conversion table for adding naics that correspond to the sic codes in blank rows
+*'''sicnaicsconversion''' with sic codes and naics codes as a conversion table for adding naics that correspond to the sic codes in blank rows. Table from https://www.census.gov/eos/www/naics/concordances/concordances.html
 *'''statastagingnew''' with two extra columns, concordsic and concordnaics, then export to stata

@@ Line 2: / Line 2: @@
 ==Work Scripts==
 ===SQL===
-*<code>E:\McNair\Projects\LBO\LBO academic paper script pre compustat</code>
+*<code>E:\McNair\Projects\LBO\patent data script</code>
 *<code>E:\McNair\Projects\LBO\LBO academic paper script post compustat</code>
 ===Stata===
@@ Line 10: / Line 10: @@
 ==Work Description==
 ===LBO Data and Patent Data===
-See script for exact work: <code>E:\McNair\Projects\LBO\Patent Data Script</code>
+See script for exact work: <code>E:\McNair\Projects\LBO\patent data script</code>
 *Get the source file for the LBOs

@@ Line 232: / Line 232: @@
 RE -- Retained Earnings
-==Resources==
 [[category:Internal]]

← Older revision		Revision as of 15:41, 3 August 2016
Line 233:		Line 233:

	==Resources==		==Resources==
−	~~WRDS USER: mcnair~~
−	~~WRDS PASS: 9Mil2015~~
−
−	~~http://www.axial.net/forum/how-private-equity-screens-lbo-candidates/ - Variables that private equity firms examine to decide whether or not to lbo~~

	[[category:Internal]]		[[category:Internal]]

@@ Line 66: / Line 66: @@
 ===Introduction of Compustat and Preparation for Stata===
 See script for exact work: <code>E:\McNair\Projects\LBO\LBO academic paper script post compustat</code>
 Create tables as follows:
-*sdc with SDC data imported from the initial LBO data.
+*'''SDC''' with SDC data imported from the initial LBO data.
-*LBOCOMPUSTAT4 with Compustat data imported.
+*'''LBOCOMPUSTAT4''' with Compustat data imported.
-*dealnumbxgvkey selecting deal numbers and gvkeys from table sdc.
+*'''dealnumbxgvkey''' selecting deal numbers and gvkeys from table sdc.
-*compustatnamematch with compustat names matched against themselves imported
+*'''compustatnamematch''' with compustat names matched against themselves imported
-*stdcompnamestdorgnamematched with standardized compustat names matched against stdorgname
+*'''stdcompnamestdorgnamematched''' with standardized compustat names matched against stdorgname
-*matchedlbocompnames with standardized original lbo names matched to standardized compustat names
+*'''matchedlbocompnames''' with standardized original lbo names matched to standardized compustat names
-*compnamematchlbocompnames with standardized compustat names, compustatnames, and standardized original lbo names
+*'''compnamematchlbocompnames''' with standardized compustat names, compustatnames, and standardized original lbo names
-*stdcompnamepatentjoin with variables standardized compustat names and patent numbers
+*'''stdcompnamepatentjoin''' with variables standardized compustat names and patent numbers
-*compustatpatentinfo with variables standardized compustat names, patent numbers, and grant dates
+*'''compustatpatentinfo''' with variables standardized compustat names, patent numbers, and grant dates
-*stdcompnamexgvkeycleaned with variables standardized compustat names and gvkeys
+*'''stdcompnamexgvkeycleaned''' with variables standardized compustat names and gvkeys
-*ALLGVKey with all distinct gvkeys from stdcompnamexgvkeycleaned
+*'''ALLGVKey''' with all distinct gvkeys from stdcompnamexgvkeycleaned
-*AllYears with all years from 1970 to 2016
+*'''AllYears''' with all years from 1970 to 2016
-*KeysXYears with variables gvkey and year. Each gvkey corresponds to 47 years.
+*'''KeysXYears''' with variables gvkey and year. Each gvkey corresponds to 47 years.
-*keysxyearsxstdcompname with variables gvkeys, years, and standardized compustat names
+*'''keysxyearsxstdcompname''' with variables gvkeys, years, and standardized compustat names
-*compupatentyearsummary with variables standardized compustat names, gvkeys, years, and number of patents per year
+*'''compupatentyearsummary''' with variables standardized compustat names, gvkeys, years, and number of patents per year
-*dealnumbxgvkeyxlboyeartemp with variables deal numbers, gvkeys, LBO years, and exit years
+*'''dealnumbxgvkeyxlboyeartemp''' with variables deal numbers, gvkeys, LBO years, and exit years
-*dealnumbxgvkeyxlboyear with variables deal numbers, gvkeys, lbo years, exit years, entry year 1, entry year 2, exit year 1, and exit year 2
+*'''dealnumbxgvkeyxlboyear''' with variables deal numbers, gvkeys, lbo years, exit years, entry year 1, entry year 2, exit year 1, and exit year 2
-*compupatentlboyearsummary with variables standard compustat names, gvkeys, years, number of patents per year, and lbo entries/exits in each year
+*'''compupatentlboyearsummary''' with variables standard compustat names, gvkeys, years, number of patents per year, and lbo entries/exits in each year
-*statastaging with all variables from compupatentlboyearsummary in addition to all the pulled compustat variables
+*'''statastaging''' with all variables from compupatentlboyearsummary in addition to all the pulled compustat variables
-*sicnaicsconversion with sic codes and naics codes as a conversion table for adding naics that correspond to the sic codes in blank rows
+*'''sicnaicsconversion''' with sic codes and naics codes as a conversion table for adding naics that correspond to the sic codes in blank rows
-*statastagingnew with two extra columns, concordsic and concordnaics, then export to stata
+*'''statastagingnew''' with two extra columns, concordsic and concordnaics, then export to stata
 ===Stata Work===

← Older revision		Revision as of 21:51, 2 August 2016
Line 236:		Line 236:

	http://www.axial.net/forum/how-private-equity-screens-lbo-candidates/ - Variables that private equity firms examine to decide whether or not to lbo		http://www.axial.net/forum/how-private-equity-screens-lbo-candidates/ - Variables that private equity firms examine to decide whether or not to lbo
		+
		+	[[category:Internal]]