----------
# Readme #
----------
prepared by Stella S. Zilian
Date 06/07/2021
This document explains how to replicate the empirical results in the paper “Digitalization, Industry Concentration, and Productivity in Germany”.
We provide all Data needed to replicate the results.
As Orbis data are not publicly available, we cannot provide the raw Orbis-data to replicate the derivation of the concentration indices.
However, the codes to derive the concentration measures based on Orbis can be made available upon request.
-------------------------------------------------------------------------------------
Where to get the original data:
EU KLEMS from http://www.euklems.net/, free access.
Orbis from https://www.bvdinfo.com/en-gb/, subscription is needed.
CompNet from https://www.comp-net.org/data/, access after submitting a data request.
-------------------------------------------------------------------------------------
----------
# Data #
----------
We provide the following data files so that the empirical results can be replicated:
* OECD taxonomy and sector correspondance between KLEMS, OECD, NACE, ISIC:
- "../excel/oecd_taxonomy.xlsx"
--> needed for the derivation of aggregated concentration data
* Concentration measures
- Orbis: "../rdat/conc_measures_oecd_approx_linear.RDat" (OECD aggregation)
- Orbis: "../rdat/conc_measures_klems_approx_linear.RDat" (KLEMS aggregation)
- CompNet: "../csv_files/compstat_conc.csv"
--> needed to derive "../rdat/conc_compstat_klems.RDat" (KLEMS aggregation)
- Weche/Wambach (2018): "../csv_files/weche_data.csv"
--> needed to derive "../rdat/weche_tcompstat_tech_oecd_merged_rr.Rdat" (OECD aggregation)
* Technology and productivity indicators:
- KLEMS: "../excel/euklems_selection_prod.xlsx"
--> needed to derive "../rdat/tech_prod_indicators_rr.Rdat"
* Merged sample for regression:
- "../rdat/regdata0015_RandR.RDat"
----------
# Codes #
----------
* Code to prepare data for KLEMS aggregation level is saved in:
"./R/code/01a_DA_prepare_data_KLEMS_aggregated.R"
Output saved in "./R/rdat/."
--> Tech indicators from KLEMS: "tech_prod_indicators_rr.RDat"
--> Concentration data at KLEMS-level from CompNet: "conc_compstat_klems.RDat"
--> Merged sample for regressions: "regdata0015_RandR.RDat"
* Code to prepare data for OECD aggregation level is saved in:
"./R/code/01b_DA_prepare_data_OECD_aggregated.R"
Output saved in "./R/rdat/."
--> Concentration data at OECD-level from CompNet: "conc_compstat_oecd.RDat"
* Code to replicate Tables 1, 2 and 5A and Figures 2, 4A--11A is saved in:
"./R/code/02_DA_tables_figures.R"
--> Summary stats saved in "./tables/table1_summaryStat.html"
--> Data for Table 2 and 5A saved in "./R/tables/."
- Data for Table 2: "conc_oecd_all_approx_linear.csv"
- Data for Table 5A: "conc_weche_wambach.csv"
- Data used in Excel-File "../excel/table2_figure3.xlsx", which contains the data for Table 2, Table 5A and Figure 3.
--> Figures 2 and 4A--11A are saved in "./R/descriptives/."
* Code to replicate the main regression results (Table 3 and Table 4) and robustness check with cumulated time lags (Table 9A) is saved in:
"./R/code/03_DA_regressions.R"
Output saved in "./R/regout/."
--> Table 3: "LP_HHI_dig_capintT-1.html"
--> Table 4: "LP_IA_HHI_dig_capintT-1.html"
--> Table 9A: "LP_lagged_capint_1_3.html"
* Code to merge data for robustness checks with OECD taxonomy and different concentration measure sources:
"./R/code/04_DA_merge4weche_oecd.R"
Output saved in "./R/rdat/."
--> weche_conc_oecd (dataframe): "weche_tcompstat_tech_oecd_merged_rr.RDat"
--> Regression data for robustness checks: "regdata_oecd_rr.RDat"
* Code to replicate regressions with OECD taxonomy:
"./R/code/05_DA_regression_oecd_taxonomy.R"
Output saved in "./R/regout/."
--> Table 10A: "AppTable10A_LP_final_taxonomy.html"
--> Table 11A: "AppTable11A_LP_final_taxonomy.html"
--> Table 12A: "AppTable12A_LP_final_taxonomy_sameSample.html"
--> Table 13A: "AppTable13A_LP_final_taxonomy_WecheCompNet.html"