Hello, I have searched for an answer to this simple question on previous forums, and cannot find the specific situation I am hoping to rectify.
I am looking to detect duplicates, but they will be found inverted over two columns, so it is not the typical "duplicate" usually referred to in Stata. As an example:
Obs Var1 Var2
1 A B
2 B A
3 A C
4 C A
(This is a simplification of the content of the cells.)
I need Stata to let me know when 2 and 4 occur, because I need to delete them. They are in String format. I have tried identifying them with loops over levelsof locals but I cannot seem to get the right identification of repeated content).
Thank you.
I am looking to detect duplicates, but they will be found inverted over two columns, so it is not the typical "duplicate" usually referred to in Stata. As an example:
Obs Var1 Var2
1 A B
2 B A
3 A C
4 C A
(This is a simplification of the content of the cells.)
I need Stata to let me know when 2 and 4 occur, because I need to delete them. They are in String format. I have tried identifying them with loops over levelsof locals but I cannot seem to get the right identification of repeated content).
Thank you.
Comment