Statalist


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

RE: st: variable that counts double observations..


From   "Nick Cox" <n.j.cox@durham.ac.uk>
To   <statalist@hsphsun2.harvard.edu>
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. 

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

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 <linn.naper@ecgroup.no> 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:
*   http://www.stata.com/help.cgi?search
*   http://www.stata.com/support/statalist/faq
*   http://www.ats.ucla.edu/stat/stata/



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