I have two datasets and I want to make sure that the same IDnumber has not been recorded twice in the two different data sets (They are two different stata files). See example below. Variable name is IDnumber. How can I ask stata to highlight where the same IDnumber has been recorded twice. for example in this data set, IDnumber 1 and 3 have been recorded twice and I would like stata to list these for me.
Eg.
Dataset1
IDnumber
1
2
3
4
5
Dataset2
IDnumber
1
3
6
7
8
Thanks very much
Related Posts with Compare variable in two stata files and list
how to get x-standardized coefficient in logistic regression, i.e., reproduce results from "listcoef" commandI was trying to get the standardized coefficient from ologit model. "listcoef" can produce the table…
reshape - wide connectionsI have variables in wide that belong together i groups (eg. var1a and var2a). I would like to reshap…
Estimation output for Svy: meologit and melogit commandsHi all, I am using Stata 14.1 and i am getting an odd but of output. I am estimating a series of m…
interaction effects: Poisson or Double-limit TobitHi All, I am working with the DHS data across five countries and looking at relationship between wo…
How to filter dates within an interval from a set of observationHello, i have a dataset of around 900,000 observations from about 130,000 ids. The variables i am w…
Subscribe to:
Post Comments (Atom)
0 Response to Compare variable in two stata files and list
Post a Comment