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: format
From
Nick Cox <[email protected]>
To
[email protected]
Subject
Re: st: Re: format
Date
Mon, 30 Jul 2012 13:50:06 -0500
Use the string variable in each case. (If your files are not
consistent in exactly which string values represent the "same" entity,
then no numeric equivalent can possibly help until that is addressed.)
Nick
On Mon, Jul 30, 2012 at 1:42 PM, Chiara Mussida <[email protected]> wrote:
> sure, but I need a unique id to be used to merge two files. In this
> way i would prob get different new id for the same individual across
> the two files
>
> On 30/07/2012, Maarten Buis <[email protected]> wrote:
>> You can just leave the string in your dataset and create a new numeric
>> id like this
>> bys stringid : gen numid = _n == 1
>> replace numid = sum(numid)
>>
>> -- Maarten
>>
>> On Mon, Jul 30, 2012 at 4:16 PM, Chiara Mussida <[email protected]> wrote:
>>> encode works. The only constraint is that it does not encode string
>>> variables that takes more than 65,536 unique values.
>>> Thanks
>>>
>>> On 29/07/2012, Joseph Coveney <[email protected]> wrote:
>>>> Chiara Mussida wrote:
>>>>
>>>> i have a string variable of 18 lenght. This is my id and i need it
>>>> numerical. I proceeded with destring and i got a numerical variable in
>>>> double format. I tried to get it in the format %18.0f, but i realised
>>>> that stata does not maintain the original number. It approx each
>>>> variable and in this way i cannot get a unique id Per individual. Do
>>>> you know whether it is a problem of wrong format?
>>>>
>>>> --------------------------------------------------------------------------------
>>>>
>>>> It is not a problem of the wrong format. At the command line type:
>>>>
>>>> help data_types
>>>>
>>>> and examine the precision of Stata's numerical data types.
>>>>
>>>> I'm curious as to why you believe that you must store eighteen-character
>>>> IDs
>>>> as
>>>> numbers. If you need to obtain a numerical ID for use of one of Stata's
>>>> -xt-
>>>> commands, then you can use -encode-.
>>>>
>>>> Joseph Coveney
>>>>
>>>>
>>>> *
>>>> * 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/
>>>>
>>>
>>>
>>> --
>>> Chiara Mussida
>>> PhD candidate
>>> Doctoral school of Economic Policy
>>> Catholic University, Piacenza (Italy)
>>> *
>>> * 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/
>>
>>
>>
>> --
>> --------------------------
>> Maarten L. Buis
>> Institut fuer Soziologie
>> Universitaet Tuebingen
>> Wilhelmstrasse 36
>> 72074 Tuebingen
>> Germany
>>
>>
>> http://www.maartenbuis.nl
>> --------------------------
>> *
>> * 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/
>>
>
>
> --
> Chiara Mussida
> PhD candidate
> Doctoral school of Economic Policy
> Catholic University, Piacenza (Italy)
> *
> * 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/