I use a database in which firms have sometimes two International Securities Identification Number (ISIN). I would like to merge two databases but I can not merge firms with two ISIN (I use the ISIN to merge the two databases). Is there any way I can convert two ISINs next to each other into vertically sperate cells (from horizontal to vertical). For example:
ISIN___________________|_Number of employees | number of executives |
GB32153453 GB34523454 | 12365 _____________| 20
I would like them to be:
ISIN_______ |_Number of employees | number of executives |
GB32153453 | 12365 _____________| 20
GB34523454 | 12365 _____________| 20
I would like to use a command in STATA to do this for me.
Related Posts with I would like to merge two databases but I can not merge firms with two ISIN
Fixed effects and Control function approachHello Expert, I am trying to apply the fixed effects estimator and control function approach in cont…
RD Regression with multiple thresholdsHello all, I currently try to set up an RD-regression with 10 thresholds. For a single threshold the…
"insufficient memory" errorHi guys, When I run an OLS regression I have the following error: "insufficient memory r(950)". The…
Does Stata create observations when mergingIs there a situation where Stata creates new observations when you merge? I ran a model on a master …
Factor Analysis - LR & chi square testHi there, I'm conducting a factor analysis (EFA, factor command, pf default) and have 2 questions: …
Subscribe to:
Post Comments (Atom)
0 Response to I would like to merge two databases but I can not merge firms with two ISIN
Post a Comment