Dear Stata experts,
I am working on my Master thesis and I need to use Stata to find a matched sample.
At the moment, I have two excel files: one with a sample of 163 chinese companies and 9 variables (company name, isin code, number of employees, common equity, total assets, mkt capitalization, net sales, net income, general industry classification); the second one is with a sample of 1459 US companies and the same 9 variables.
I need to match each chinese company with at least one (2 or 3 would be even better) US company from the SAME INDUSTRY, and very similiar size (number of employees) and balance sheet scores (common equity, total assets, mkt capitalization, net sales, net income).
As a final result, I just need to know the name or the isin code of the US companies which are matched to the chinese ones. Therefore, I should have a sample of at least 163 US companies. The general industry classification is represented with a number from 1 to 6.
I already read some previous posts as well as the guide on treatment effects and I watched some youtube videos about Nearest-neighbor matching, but I am completely new to Stata and I still don't know how to proceed.
I really hope you could help me! Many thanks in advance!
Armelina
I am working on my Master thesis and I need to use Stata to find a matched sample.
At the moment, I have two excel files: one with a sample of 163 chinese companies and 9 variables (company name, isin code, number of employees, common equity, total assets, mkt capitalization, net sales, net income, general industry classification); the second one is with a sample of 1459 US companies and the same 9 variables.
I need to match each chinese company with at least one (2 or 3 would be even better) US company from the SAME INDUSTRY, and very similiar size (number of employees) and balance sheet scores (common equity, total assets, mkt capitalization, net sales, net income).
As a final result, I just need to know the name or the isin code of the US companies which are matched to the chinese ones. Therefore, I should have a sample of at least 163 US companies. The general industry classification is represented with a number from 1 to 6.
I already read some previous posts as well as the guide on treatment effects and I watched some youtube videos about Nearest-neighbor matching, but I am completely new to Stata and I still don't know how to proceed.
I really hope you could help me! Many thanks in advance!
Armelina
