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
How to use Stata commands to calculate the total score of Likert Scale questions?In order to assess the attitude about antibiotic use, there are 6 questions with 5 levels of respons…
Problem with capture confirm and graph combine Hello. I have problems combining two graphs in a loop . I do not have all of the combination …
Drop if - variable not foundHi all, Just a very simple question and command yet I can't figure out why it is not working. I ju…
Creating variables with a sequence of numbers based on whether other variables stay the same (for case:control matching)Hello everyone. This is my first time posting here, and I do so because I haven't been able to find…
ivregress and country fixed effectsHi friends I am new to the use of STATA and Instrumental variables (IV) and using STATA 14.2 I am …
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