# RE: st: how to add 23 in each row of a variable

 From "Nick Cox" To Subject RE: st: how to add 23 in each row of a variable Date Mon, 15 Sep 2008 19:32:10 +0100

```I think there are two quite distinct points being conflated here.

You can do an awful lot of Stata work without needing subscripts.
Perhaps many users never need them, and good luck.

But it would be quite wrong to wonder whether they are ever necessary.

Two quick examples:

1. Any problem that hinges on looking at previous observations and uses
[_n-1].
That makes some awkward problems trivial. Examples in

http://www.stata.com/support/faqs/data/sequence2.html

http://www.stata.com/support/faqs/data/missing.html

2. There are problems in which you do need to loop over observations.
See SJ 7(4): 571-581 (2007) for one.

Nick
n.j.cox@durham.ac.uk

P.S. a correction to Eva's correction:

replace number[`i'] =

would have to be

replace number =

Martin Weiss

I see braod agreement on the solution. This thread is a tough reminder,
though, of the difficulties that can sometimes seem insurmountable for
beginners in Stata. Having had a distraught student walk into my office
a
couple of days ago with the exact same problem, I think it is extremely
important to emphasize that Stata does not exactly "push" subscripting
as a
solution to data management problems. I would have trouble recalling a
single instance where subscripting has proved necessary for me in
Stata...

Eva Poen
>
> er, no need for a loop. May
>
> replace number = number + 23
>
> be what you want?
>
> The code for your (unnecessary!) loop as a few mistakes which I am
> going to correct anyway.
> If you use -while-, you have to increment your counter macro inside
the
> loop:
> local i 1
> while `i' < 100 {
> ....
> local ++i
> }
>
> Else you have an infinite loop, because the initial condition is
> always true. -foreach- and -forvalues- are usually much better
> choices, and run faster, I believe.
>
> Your condition -while `i' < _N- leaves out the last observation. Next,
> number[i] should read number[`i']. _However_, none of this is
> necessary! Use -generate- and -replace-.
>
> 2008/9/15 Fabian Brenner <Fabian.Brenner@gmx.de>:
>>
>> how can I tell Stata to add 23 in each row of a variable in the
dataset?
>>
>> I do not know what I am doing wrong because it does not work like
this:
>>
>> local i=1
>> while `i'<_N {
>>  2. replace number[i]= number[`i'] + 23
>>  3. }
>>

*
*   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/
```