st: Re: Fill in panel observations

["Martin Weiss" <martin.weiss1@gmx.de>]

<>

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


HTH
Martin 
_______________________
----- Original Message ----- 
From: "John Antonakis" <John.Antonakis@unil.ch>
To: <statalist@hsphsun2.harvard.edu>
Sent: Saturday, March 28, 2009 9:43 PM
Subject: st: Fill in panel observations


> 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?
>
> Thanks,
> John.
> ____________________________________________________
>
> Prof. John Antonakis
> Associate Dean
> Faculty of Business and Economics
> University of Lausanne
> Internef #618
> CH-1015 Lausanne-Dorigny
> Switzerland
>
> Tel ++41 (0)21 692-3438
> Fax ++41 (0)21 692-3305
>
> e-mail: john.antonakis@unil.ch
>
> ____________________________________________________
>
>
>
>
> *
> *   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/
*
*   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/