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
Using IVREG2HPlease can someone help me with the use of the ivreg2h command for analysis? My dependent variable i…
Generating average variable of previous observationsHi All, I am writing my Bachelor thesis which is about how total payout policy (dividends + share r…
Reduce number of decimals in twostepweakiv outputHello, I was trying to use the twostepweakiv command to compute the AR 95% confidence intervals. The…
Calculating censorship date for survival analysisI'm doing survival analysis and trying to calculate the end of follow-up date for each patient. Foll…
Clustering Industry typesI have constructed the following one year lagged regression of ESG on ROA. However, I do not get an …
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