I am working with bank financial statements. I need to merge data from FDIC Bank financial statements, I/B/E/S, and Compustat datasets. But there is no common identifier that I can use to merge the two datasets. So, I have to merge the datasets using company names in the datasets. The names are not identical in the datasets. The name of the same company is written slightly differently in different datasets. Thus, I need to first clear the common expressions like Ltd., Bank, etc. And then compare the core name and calculate the similarity score of the names. Then, I can set a benchmark (say, 0.7 or 70%) and merge the observations with at least 70% match in names for any given fiscal year.
I highly appreciate your time and effort.
Ismat Jahan You may use the following methods to combine two datasets in SPSS v.28 using business names as the common identifier:
1. Using SPSS's "string" tools, clean up the firm names in both datasets by eliminating frequent phrases such as "Ltd.", "Bank," and so on.
2. In SPSS, use the "string" functions to compute the similarity score of the firm names in both datasets.
3. Make a new variable to keep track of the similarity score.
4. In SPSS, use the "sort" command to sort the data in decreasing order by similarity score.
5. In SPSS, use the "match files" command to combine the two datasets based on the firm names and fiscal year, and specify a name match threshold of 70%.
6. To choose the observations that pass the benchmark, use the "select if" command.
Before applying your technique to the full dataset, it is essential that you test it on a small sample of the data to confirm that the merging is done appropriately.
Ismat Jahan In SPSS v.28, you can use the "Match File" command to merge two datasets based on a common identifier, such as company name. Here's a general outline of the steps you can take to merge the FDIC Bank financial statements, I/B/E/S, and Compustat datasets using company names:
If you could not solve the problem yet I will be pleased to check your files and try to solve it for you! Cheers!
- Badges
- Science topic
- Similar topics
- Names