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

From |
"Martin Weiss" <martin.weiss1@gmx.de> |

To |
<statalist@hsphsun2.harvard.edu> |

Subject |
st: Re: RE: Re: Fill in panel observations |

Date |
Sun, 29 Mar 2009 18:29:51 +0200 |

<>

HTH Martin _______________________

To: <statalist@hsphsun2.harvard.edu> Sent: Sunday, March 29, 2009 6:02 PM Subject: st: RE: Re: Fill in panel observations

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 AntonakisI 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 thetotal_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/

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

**Follow-Ups**:**Re: st: Re: RE: Re: Fill in panel observations***From:*John Antonakis <John.Antonakis@unil.ch>

**References**:**st: check whether a variable has any missing values***From:*Jacob Wegelin <jacob.wegelin@gmail.com>

**st: Re: check whether a variable has any missing values***From:*"Martin Weiss" <martin.weiss1@gmx.de>

**st: Fill in panel observations***From:*John Antonakis <John.Antonakis@unil.ch>

**st: Re: Fill in panel observations***From:*"Martin Weiss" <martin.weiss1@gmx.de>

**st: RE: Re: Fill in panel observations***From:*"Nick Cox" <n.j.cox@durham.ac.uk>

- Prev by Date:
**st: RE: check whether a variable has any missing values** - Next by Date:
**st: RE: RE: SSC Archive help files now available in HTML** - Previous by thread:
**st: RE: Re: Fill in panel observations** - Next by thread:
**Re: st: Re: RE: Re: Fill in panel observations** - Index(es):

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