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 -rtfutil- for page breaks and other simple tasksHello Statatalist I just discovered the user-written -rtfutil- command from SSC, which seems to be …
no observation error (2000) after entering control variables.Hi, I'm working on mexico pension program and at primary steps, when I want to estimate impact of pr…
KPSS stationarity test without trendHi there, I would like to perform KPSS stationarity tests to compliment my ADF tests. By default, th…
GraphingDear Users, I used an online app to produce this graph. Possible to do the same using Stata?: Array …
Mixlogit- "Some variables are collinear, check your model specification"Hello, I am doing a mixlogit regression for a DCE. This is the command that I am using- mixlogit c…
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