Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.

Re: st: Loop to replace values of a variable

 From emanuele mazzini To statalist@hsphsun2.harvard.edu Subject Re: st: Loop to replace values of a variable Date Wed, 18 Dec 2013 17:20:36 +0100

```That's also a nice one!

Thanks again!

2013/12/18 Jeph Herrin <stata@spandrel.net>:
> A solution that doesn't require knowing the value of x[1] in advance:
>
>  sort x
>  replace x=x[_n-1]+0.1 if _n>1
>
> hth,
> Jeph
>
>
>
> On 12/18/2013 9:04 AM, emanuele mazzini wrote:
>>
>> Yes, the way Marteen suggested worked greatly.
>> Thank you!!
>>
>> 2013/12/18 Fabrizio Colella - 1348010 <colella.fabrizio@studbocconi.it>:
>>>
>>> you generated x as Marteen suggested, now you just have to subtract:
>>>
>>> gen x = _n*.1
>>> gen y = -2.6+x
>>>
>>> Fabrizio
>>>
>>>
>>> ----- Messaggio originale -----
>>> Da: "Nick Cox" <njcoxstata@gmail.com>
>>> A: statalist@hsphsun2.harvard.edu
>>> Sent: Mercoledì, 18 dicembre 2013 14:49:34
>>> Oggetto: Re: st: Loop to replace values of a variable
>>>
>>> For -2.5(0.1)2.1 or -2.5(0.1)2.5, you can still divide integers by 10.
>>> No loop needed as _n always gives you integers in sequence.
>>>
>>>
>>> Nick
>>> njcoxstata@gmail.com
>>>
>>>
>>> On 18 December 2013 13:44, emanuele mazzini <madsoenistata@gmail.com>
>>> wrote:
>>>>
>>>> Oh, yes, I see. Thank you very much for your answers, but I may have
>>>> oversimplified, since what you said would fit in this case, as x is
>>>> exactly = _n/10, but my problem is slightly more complex.
>>>>
>>>> What if the values I want to replace go from -2.5 to 2.15, still with
>>>> a 0.1 interval? In this case I'd still need a loop, right?
>>>>
>>>> 2013/12/18 Maarten Buis <maartenlbuis@gmail.com>:
>>>>>
>>>>> no need to loop:
>>>>>
>>>>> gen x = _n*.1
>>>>>
>>>>> Hope this helps,
>>>>> Maarten
>>>>>
>>>>>
>>>>> On Wed, Dec 18, 2013 at 2:33 PM, emanuele mazzini
>>>>>>
>>>>>> Dear all statalist users,
>>>>>>
>>>>>> I would like to program a (relatively) simple loop to replace the
>>>>>> values of a variable I created, but I cannot  figure it out how to
>>>>>> write the syntax.
>>>>>>
>>>>>> The structure of my data is very simple:
>>>>>> I have 300 observations and a variable, say x, that in the first cell
>>>>>> (i.e. for n=1) is equal to 0.1, while it is missing for all other 299
>>>>>> cells. Data look like:
>>>>>>
>>>>>> n     x
>>>>>> 1    0.1
>>>>>> 2     .
>>>>>> 3     .
>>>>>> 4     .
>>>>>> .
>>>>>> .
>>>>>> .
>>>>>> .
>>>>>> .
>>>>>> 299  .
>>>>>> 300  .
>>>>>>
>>>>>> I would like the loop to replace the missing values of my variable by
>>>>>> going from cell 2 to cell 300, and to have a replace that would be at
>>>>>> a 0.1 intervals, so as to obtain data that look like:
>>>>>>
>>>>>> n     x
>>>>>> 1    0.1
>>>>>> 2    0.2
>>>>>> 3    0.3
>>>>>> 4    0.4
>>>>>> .
>>>>>> .
>>>>>> .
>>>>>> .
>>>>>> .
>>>>>> 299  29.9
>>>>>> 300  30
>>>>>>
>>>>>> I can obviously do it by hand, but a loop would be naturally much more
>>>>>> efficient!
>>>>>> Does anyone know how to make it?
>>>>>>
>>>>>> *
>>>>>> *   For searches and help try:
>>>>>> *   http://www.stata.com/help.cgi?search
>>>>>> *   http://www.stata.com/support/faqs/resources/statalist-faq/
>>>>>> *   http://www.ats.ucla.edu/stat/stata/
>>>>>
>>>>>
>>>>>
>>>>>
>>>>> --
>>>>> ---------------------------------
>>>>> Maarten L. Buis
>>>>> WZB
>>>>> Reichpietschufer 50
>>>>> 10785 Berlin
>>>>> Germany
>>>>>
>>>>> http://www.maartenbuis.nl
>>>>> ---------------------------------
>>>>> *
>>>>> *   For searches and help try:
>>>>> *   http://www.stata.com/help.cgi?search
>>>>> *   http://www.stata.com/support/faqs/resources/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/faqs/resources/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/faqs/resources/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/faqs/resources/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/faqs/resources/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/faqs/resources/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/faqs/resources/statalist-faq/
*   http://www.ats.ucla.edu/stat/stata/
```