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
Replacing missing values in a panel dataHello, I am doing a difference in difference in panel data set, years 2001-2015. The observation un…
multiple imputation (-mi-) with the synthetic control method (-synth-)Has anyone combined multiple imputation with the synthetic control method (https://fmwww.bc.edu/repe…
Panelregression using pooled ols with dummiesHello all, I have a paneldataset ranging from 2002 until 2019 containing ~ 500 companies. My paneli…
Rearranging Data Code: clear input str25 sub1 marks1obt marks1max str30 sub2 marks2obt marks2max str30 sub3 marks3ob…
P-values and CI's for dotplot?Hi you helpful people. I have measured a concentration of a medical drug 1 week after operation in …
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