Statalist


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

st: RE: Re: Fill in panel observations


From   "Nick Cox" <n.j.cox@durham.ac.uk>
To   <statalist@hsphsun2.harvard.edu>
Subject   st: RE: Re: Fill in panel observations
Date   Sun, 29 Mar 2009 17:02:02 +0100

There will be a difference between the results 

bys iis: egen total_rater = count(rater) 

and 

bys iis : gen total_rater = _N 

if -rater- is ever missing; but otherwise the latter is more direct and
more efficient. 

Incidentally, once you known that data are sorted on -iis-, the second
command can just start -by iis:-. 

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

Martin Weiss

bys iis: g rater=_n
bys iis: egen total_rater=count(rater)

John Antonakis

>I have multiple observations on leaders (iis) by raters, like this:
> 
> iis  sex  age   y  rater   total_rater
> 1    0    43    5    1        5
> 1    0    43    9    2        5
> 1    0    43    3    3        5
> 1    0    43    6    4        5
> 1    0    43    6    5        5
> 2    1    46    9    1        7
> 2    1    46    7    2        7
> 2    1    46    9    3        7
> 2    1    46    6    4        7
> 2    1    46    7    5        7
> 2    1    46    2    6        7
> 2    1    46    8    7        7
> 
> At this time, the rater column and total_rater columns are blank. I 
> would like to fill them in such that:
> 
> a. Under "Rater" I number each within the panel, starting with 1 and 
> going up to k raters (as I have done above).
> b. The total number of k raters is included for each leader (as in the

> total_rater column).
> 
> Is there a quick way to do this?

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