Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.
From | "Martin Weiss" <martin.weiss1@gmx.de> |
To | <statalist@hsphsun2.harvard.edu> |
Subject | st: AW: Creating a Group Pair ID (where the generating variables order shouldn't matter) |
Date | Fri, 23 Jul 2010 11:21:23 +0200 |
<> Try NJC`s http://www.stata-journal.com/article.html?article=dm0043 HTH Martin -----Ursprüngliche Nachricht----- Von: owner-statalist@hsphsun2.harvard.edu [mailto:owner-statalist@hsphsun2.harvard.edu] Im Auftrag von J Taylor Gesendet: Freitag, 23. Juli 2010 11:00 An: statalist@hsphsun2.harvard.edu Betreff: st: Creating a Group Pair ID (where the generating variables order shouldn't matter) I am trying to create an ID corresponding to numbers from two lists. For example, if the two lists were of countries, one would have clear input str20 c1id str20 c2id "US" "Canada" "US" "Mexico" "Canada" "US" "US" "France" "France" "England" "France" "US" end egen newid = group(c1id c2id) I would like newid to create an ID pair for each country pair. My first instinct was to use the egen group command. However, the problem is that egen group takes into account which id comes first. For example, (c1id,c2id)=(United States,Canada) and (c1id,c2id)=( Canada ,United States) have different IDs. I would like them to be able to have the same ID. That is, I would like to create newid as a group pair ID, reflecting which two countries are in the pair, and where the order doesn't matter. Any thoughts on how to do this? Thanks, JT * * For searches and help try: * http://www.stata.com/help.cgi?search * http://www.stata.com/support/statalist/faq * http://www.ats.ucla.edu/stat/stata/ * * For searches and help try: * http://www.stata.com/help.cgi?search * http://www.stata.com/support/statalist/faq * http://www.ats.ucla.edu/stat/stata/