Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
RE: st: RE: Generating numeric ids
From
"Martin Weiss" <[email protected]>
To
<[email protected]>
Subject
RE: st: RE: Generating numeric ids
Date
Mon, 8 Mar 2010 23:35:10 +0100
<>
Say
*******
egen newid=group(ID)
*******
then.
HTH
Martin
-----Original Message-----
From: [email protected]
[mailto:[email protected]] On Behalf Of Dmitriy
Krichevskiy
Sent: Montag, 8. März 2010 23:30
To: [email protected]
Subject: Re: st: RE: Generating numeric ids
Thank you Martin, but unfortunately I get an r(134) error. I am
guessing that there are more than 65,536 unique values as possible
combinations. So I am trying to see if there is another approach.
Thanks again. Dmitriy
2010/3/8, Martin Weiss <[email protected]>:
>
> <>
>
> *******
> clear*
>
> inp str10 ID V1 str10 V2
> AAAAPTNE7 . .
> AAAAPTNE7 . .
> AAAARCOO7 1 "2002-2003"
> AAACACRI7 2 "2004-2005"
> AAACAMCP3 1 "2006-2007"
> AAACARIC9 1 "2002-2003"
> end
>
> encode ID, gen(numericid)
> l, nolab sepby(ID) noo
>
> *******
>
>
> HTH
> Martin
>
>
> -----Original Message-----
> From: [email protected]
> [mailto:[email protected]] On Behalf Of Dmitriy
> Krichevskiy
> Sent: Montag, 8. März 2010 23:01
> To: statalist
> Subject: st: Generating numeric ids
>
> Dear Statalisters,
> I have a large panel dataset creators of which decided to encrypt the
> participants IDs via some unknown algorithm to covert them (original
> id numbers) into strings. I am stock trying to figure out how to
> create unique numerical identifiers from these given that the data is
> panel (in the long format). I provide a small example below. As always
> your help is much appreciated.Thanks, Dmitriy
>
>
> ID V 1 V2
> AAAAPTNE7 . .
> AAAAPTNE7 . .
> AAAARCOO7 1 2002-2003
> AAACACRI7 2 2004-2005
> AAACAMCP3 1 2006-2007
> AAACARIC9 1 2002-2003
>
> --
>
> Research Associate, College of Education
> Lumina Foundation Project
> *
> * 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/
>
Research Associate, College of Education
Lumina Foundation Project
*
* 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/