Hi stata experts,
I am trying to merge two datasets. The first dataset (A) has 39,082 observations and the second (B) one has 56,521. I merge A with B. This is the result:
Array
(total number of observations 70,497)
The dataset B contains two dummy variables and I match the two datasets based on CIK-code. After merging I want to remove the observations from dataset B that did not match in my dataset A. So essentially, I would want to have 39,082 observations in the end again.
Does someone know what I can do to achieve this?
Kind regards,
Sarah
Related Posts with Merging datasets
Descompositioncan someone explain to me about the gap descomposition methods and which are commands in Stata? I wa…
Destringing vars and changing commas to dotsHi all I have some datasets in which Italian notation has been used - this means that commas have …
Curious error when listing longI'm working with latitude and longitude variables but I ran into a curious error: Code: clear input…
Find the most recent observationHi, I have a year-firm panel data. How should I write the code to find the most recent observation …
Unable to cd and use the file in DropboxHi Everyone, I have difficulty to cd the file to Dropbox and use the file in Dropbox. Here are my s…
Subscribe to:
Post Comments (Atom)
0 Response to Merging datasets
Post a Comment