Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.
From | Nick Cox <n.j.cox@durham.ac.uk> |
To | "'statalist@hsphsun2.harvard.edu'" <statalist@hsphsun2.harvard.edu> |
Subject | RE: st: RE: Transforming Unique IDs |
Date | Mon, 23 May 2011 11:49:46 +0100 |
Note that the -label- option gives you the best of both worlds should you want it. Nick n.j.cox@durham.ac.uk Dennis Kramer Thank you Jan, that was the fix. Very much appreciated On Mon, May 23, 2011 at 6:42 AM, Jan Bryla <JBR@finansraadet.dk> wrote: > I am not quite sure what the objective is, but the group function with -egen- would generate a new id based on the order of the old id. > > egen newid=group(id) Dennis Kramer > I am working with a large panel data set and I need to transform the > current unique IDs into a new set of unique IDs while maintaining the > panel nature of the data. For example, > > Year 1 ID1 Var 1 Var2 Var3 NewID1 > Year 2 ID1 Var 1 Var2 Var3 NewID1 > Year 3 ID1 Var 1 Var2 Var3 NewID1 > Year 1 ID2 Var 1 Var2 Var3 NewID2 > Year 2 ID2 Var 1 Var2 Var3 NewID2 > Year 3 ID2 Var 1 Var2 Var3 NewID2 > Year 1 ID3 Var 1 Var2 Var3 NewID3 > Year 2 ID3 Var 1 Var2 Var3 NewID3 > Year 3 ID3 Var 1 Var2 Var3 NewID3 > > does anyone have a algorithm to produce a new set of unique IDs while > maintaining the panel function? I have looked through the current FAQs > and past listserv discussions and have not found any suggestions that > would create a new ID while maintaining the panel groupings. > * * 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/