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
Creating a table for many variablesHello everyone, I have a data which has a categorical variable (north/south) and about 10 variables …
How can I display the value of a scalar "labelling" it?Hi all A very quick question. How can I display the value of a scalar "labelling" it? I mean, I'd l…
Tobit - function returned errorHello Statalisters, I am investigating the effect of a health-information warning on the purchases …
Transforming a Categorical Variable into Separate VariablesI am working with factory-year panel data wherein information about many variables (for e.g. wages, …
Generate new variable from several variablesI have a survey dataset from several countries from a few time periods. Each country and period has …
Subscribe to:
Post Comments (Atom)
0 Response to Sub-setting data and merging
Post a Comment