Hi,
Newbie to Stata and trying two merge two datasets (one from Compustat and one from Execucomp) with unique ID numbers (these are called 'gvkey'). The problem I'm facing arises when I want to merge the two datasets based upon their 'gvkey', I keep getting the message that "gvkey does not uniquely identify observations" (both for master and using data). I get why Stata reports this message, as each 'gvkey' has a observation per year, but I do not know how to go further at this point. My goal is to merge the two datasets based on their 'gvkey' and 'fyear' (see below).
Dataset 1:
GVKEY FYEAR IBC OANCF
001004 1994 $X $X
001004 1995 $X $X
001004 1996 $X $X
Dataset 2:
GVKEY FYEAR CEO EARLYYEARS
001004 1994 1 1
001004 1995 1 1
001004 1996 1 1
----------
What I whish to get is this:
Dataset 1+2 (merged):
GVKEY FYEAR IBC OANCF CEO EARLYYEARS
001004 1994 $X $X 1 1
etc. etc.
----------
Please help me out!
Thanks in advance!!
Related Posts with Merging datasets with multiple observations per company ID
Create Functions using MataHi All, I am new to the Mata programming and currently trying to convert some codes from Matlab to …
how can i combine two datasets like this?Hi, I want to combine two datasets. Here is an example of what i have: Dataset A: id Country Gen…
Looping through multiple levels of variables not workingHello, I am working on a project but I am struggling with my stata code. I have a data set that I cr…
FE RE ModelHello everyone. I wanted to know apart from testing which model to use , fixed effects or random eff…
Why does Stata 16 crash every time I close a do-file??Stata experts, Can anyone help me figure out why stata 16 crashes every time I close a do-file? It …
Subscribe to:
Post Comments (Atom)
0 Response to Merging datasets with multiple observations per company ID
Post a Comment