Hi. I have two datasets that I want to merge, dataset 1 and dataset 2. They both have duplicates, so to merge I would have to do a m:m merge, which I am not in favor of. I would like to do a m:1. Is there any way that I can partition dataset 2 to hold the duplicates in a sub dataset do a m:1 merge between dataset 1 and dataset 2 and then bring back the subset of duplicates.
Related Posts with Sub-setting data and merging
Leave One Out Cross ValidationHello, I am trying to look for the best n given: set obs 200 gen x = runiform(0,5) gen U = rnorma…
What does "log using 'filename', replace" do? To create logs or to replace the existing ones?Dumb question, but in my professor's notes it's to "create log in current folder." But isn't it foll…
Binary Endogenous variable in Negative binomial regressionHello everybody, In my research, the dependent variable (DV) is count data and endogenous variable …
Gravity estimation including fixed effectsHi everyone, I am estimating a gravity model of trade including exporter-time and importer-time fix…
What are some Stata skills that you need to do RA for professors? And what are the good sources to learn data cleaning?I'm about to work as a RA for a professor, what would I be expected to do? I have heard that data cl…
Subscribe to:
Post Comments (Atom)
0 Response to Sub-setting data and merging
Post a Comment