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
merging variableshello. How do i merge a single variable from a using data set to the main data set? …
Problem while using xtfmb (Fama-MacBeth (1973)) on dummy variablesDear Stata community, I am new to this forum and I have a question that I hope you might be able to…
Repeated Measures ANOVAHi, I would like to know how to do the repeated measures ANOVA analysis with the following data - I …
how to set a dummy to arrange datahello I have a question needs to help. Z code mode I want to category Z variable below as gen zcode …
Proportional odds assumption in order logit regression: how to test multiple parameters simultaneouslyDear Statalisters, I'm using Stata 15.1. I have an ordinal outcome that may assume 5 distinct valu…
Subscribe to:
Post Comments (Atom)
0 Response to Merging datasets
Post a Comment