[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:38:35 -0000

Ashim: I can only comment on what you post. If you post incorrect or inefficient code people are likely to spot it. 

You are correct insofar as your original solution, minus a line that was illegal, plus a line replacing it,  plus a line that is a fix gets you where the questioner appears to want to be. 

You can also get there directly in one line. 

My earlier post has appeared on Statalist. See the archives if you are still missing it. 


Ashim Kapoor


I know it is not exactly what is written but it does the job of
grouping 2 consecutive variables and hence can be used in the by
command. To refine it you may say

egen j=group(var)

then we will have 1 1 2 2  3 3 etc.

By the way I never got your 1st post. Email got eaten up I guess.

On Wed, Nov 12, 2008 at 8:48 PM, Nick Cox <> wrote:

> 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