R
RonaldP
I have a set of 13 databases containing annual company information, tha
I would like to match. Each database contains a column of compan
identification codes and a wide variety of variables for each year
such as monthly returns, market capitalization etc. I want to match th
13 databases into one database, which is sorted on company codes
However, the number of companies differs for each year, since some ar
liquidated or merged during the course of the year, while others ar
founded later in the sample period, such that they do not appear in th
first databases (the variation in codes is quite big). Normally, I woul
use pivot tables to match these kind of databases. However, due to th
size of the databases (around 2000 entries each) and the large amoun
of variables in each of the databases this is only possible for about
databases at a time, that must be matched manually afterwards. Sinc
this gets very time-consuming, I hope that someone knows a les
cumbersome solution (either in excel or another software package).
Thanks in advance,
Ronald
I would like to match. Each database contains a column of compan
identification codes and a wide variety of variables for each year
such as monthly returns, market capitalization etc. I want to match th
13 databases into one database, which is sorted on company codes
However, the number of companies differs for each year, since some ar
liquidated or merged during the course of the year, while others ar
founded later in the sample period, such that they do not appear in th
first databases (the variation in codes is quite big). Normally, I woul
use pivot tables to match these kind of databases. However, due to th
size of the databases (around 2000 entries each) and the large amoun
of variables in each of the databases this is only possible for about
databases at a time, that must be matched manually afterwards. Sinc
this gets very time-consuming, I hope that someone knows a les
cumbersome solution (either in excel or another software package).
Thanks in advance,
Ronald