Hello everyone,
Please I downloaded a dataset in excel format from BankFocus' website for 1455 banks within 19 EU countries and used it to estimate competition using Lerner index and Boone indicator and I've saved the result (Lerner and Boone) in dta format.
Moreover, I have another dataset (macroeconomic data) in excel format from world bank's website for the same 19 EU countries but there are no banks or firms attached to this new dataset.
Now I want to merge or join these two datasets to help me estimate the impact of the competition measures (Lerner and Boone) on one of the macroeconomic variables (GDP) using regression. So how do I merge or combine or join these two datasets?
Or differently put, how do I add the competition measures (Lerner and Boone) to the macroeconomic dataset? Which stata function can help me to merge these two datasets?
I would be grateful for your assistance, thanks.
Related Posts with Merge Dataset
how to generate variables contaning distinct values of other varaibles?For example, accordging to expDomain1 to expDomain4, I want to generate var6, which includes the dis…
First differencing in Seasonal Agriculture DataI am using STATA 16.1 and trying to estimate the following household (hhid) model. reg D.y peak D.x…
remove "inflation" without inflation data?say I have a signal, which includes some form of inflationary price, but I don't know the inflation …
ivprobit - very high wald chi2 - not the expected signsDear experts, Iam a bit lost in understanding what is going wrong with my model. Here is what I 've…
Stepwise regression as a robustness test after an OLS?Would it be accepted to use the same variables, but switch from OLS to stepwise in Stata? Or what ot…
Subscribe to:
Post Comments (Atom)
0 Response to Merge Dataset
Post a Comment