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
Power calculation for sensitivity of a diagnostic testHi, I want to test the sensitivity of a rapid test & need to calculate the desired sample size.…
Using xtreg, error "Panels are not nested in clusters"Dear users, I would like to find out how shocks affect household consumption. I have a balanced pane…
Remaining heteroskedasticity even after using GARCH(1,1)I've also tried GARCH(1,2) and GARCH(2,1) but both of the residuals are subject to arch after testin…
Export Summary Stats with variable labels using putexcelHi Statalisters! I am trying to make the most of stata16's new automated reporting functions, and p…
translate option to change result color in .pdf-fileThe command translator query smcl2pdf shows a table of tunable parameters that can be set either by …
Subscribe to:
Post Comments (Atom)
0 Response to Merging datasets
Post a Comment