[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

RE: st: variable that counts double observations..

From   "Nick Cox" <>
To   <>
Subject   RE: st: variable that counts double observations..
Date   Wed, 12 Nov 2008 15:18:13 -0000

The first line won't work, as already explained in my earlier posting. 

But suppose you had a variable with values 1 up. 

The second line would replace 1,2,3,4,5,6, ... with 1,1,3,3,5,5,... 
which is not what I think is being asked for. 


Ashim Kapoor

egen var=_n , by(group)
by group : replace var=var-1 if mod(var,2)==0

I think this should work.

What the second line says is that for every even number var should
have the value of the previous var which is itself -1 .

Can someone approve this ? I am not 100% certain.

On Wed, Nov 12, 2008 at 4:36 PM, Linn Renée Naper <> wrote:

> egen var=_n, by(group) will give me a variable counting from 1 til N within each group of the data.
> BUT: how do I tell stata that the observations are double in the sense that I need a variable that repeats each number ones,
> like this: 11 22 33 44.... instead of 1 2 3 4.....
> I need this variable in order to collapse the data.

*   For searches and help try:

© Copyright 1996–2019 StataCorp LLC   |   Terms of use   |   Privacy   |   Contact us   |   What's new   |   Site index