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
Managing workflow with the global macroHello Stata users, I am trying to use the global macro to switch between subfolders. For instance, …
SchemesI have just upgraded from 15 to 16. Is there any way to import my schemes from 15 without having to …
Graph line with values for only a few groups over timeHi, I want to graph the development of the number of houses of the type "allmännyttan" (publicly ow…
Keep last 4 digits of a numeric variableHi everyone, I would like to ask you how can I keep the last 4 digits of the variable date. It is a …
OLS regression where one independent variable is a rare eventHello all, I am performance ols regression, something like: regress y i.x1##i.x2 x3 x4 x5, cluster…
Subscribe to:
Post Comments (Atom)
0 Response to Merging datasets
Post a Comment