Hello,
I am relatively new to stata, but I have encountered a problem of not being able to find duplicates across variables. I have a table like this:
id Start Destination
1 China US
2 US Japan
3 US China
4 Italy Spain
and I would like to find a list of all the observations that have another's start as destination and destination as start. I would like a result like this:
1 China US
3 US China
Thanks a ton to anyone that would help! I'd really appreciate it : )
Related Posts with How to find duplicate across variables
splitting time spanGood afternoon, I have a problem in constructing my dataset on stata. I have repeated events for eac…
Gini coefficients with confidence intervalsDear Statalisters, I have conceptual and Stata-oriented questions about generating (and later plott…
computing marginal effects using logit fixed effects modelDear Statalist, My dataset is crossectional, but I want to include industry and year fixed effects.…
Transforming a string variable into a time/dateI have a string variable called month containing; "Jan 2018" till "Dec 2020". How do I separate this…
Computer says 'no' - How to allocate more memory for STATA[Please note: I've looked at a few other forums with similar problems, but the solutions don't seem …
Subscribe to:
Post Comments (Atom)
0 Response to How to find duplicate across variables
Post a Comment