How Do I Match Databases?
I have a set of 13 databases containing annual company information, that I would like to match. Each database contains a column of company identification codes and a wide variety of variables for each year, such as monthly returns, market capitalization etc. I want to match the 13 databases into one database, which is sorted on company codes. However, the number of companies differs for each year, since some are liquidated or merged during the course of the year, while others are founded later in the sample period, such that they do not appear in the first databases (the variation in codes is quite big). Normally, I would use pivot tables to match these kind of databases. However, due to the size of the databases (around 2000 entries each) and the large amount of variables in each of the databases this is only possible for about 3 databases at a time, that must be matched manually afterwards. Since this gets very time-consuming, I hope that someone knows a less cumbersome solution (either in excel or another software package). Thanks in advance, RonaldP -- RonaldP ------------------------------------------------------------------------ RonaldP's Profile: http://www.excelforum.com/member.php...o&userid=34620 View this thread: http://www.excelforum.com/showthread...hreadid=543952 |
All times are GMT +1. The time now is 04:01 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com