IDEAS home Printed from https://ideas.repec.org/a/tsj/stataj/v7y2007i4p571-581.html
   My bibliography  Save this article

Speaking Stata: Counting groups, especially panels

Author

Listed:
  • Nicholas J. Cox

    (Durham University, UK)

Abstract

Counting panels, and more generally groups, is sometimes possible in Stata through a reduction command (e.g., collapse, contract, statsby) that produces a smaller dataset or through a tabulation command. Yet there are also many problems, especially with irregular sets of observations for varying times, that do not yield easily to this approach. This column focuses on techniques for answering such questions while maintaining the same data structure. Especially useful are the Stata commands by: and egen and indicator variables constructed for the purpose. With by: we often exploit the fact that subscripts are defined within group, not within dataset. egen functions are often used to produce group-level statistics. Tagging each group just once ensures that summaries, including counts, are of groups, not individual observations.

Suggested Citation

  • Nicholas J. Cox, 2007. "Speaking Stata: Counting groups, especially panels," Stata Journal, StataCorp LP, vol. 7(4), pages 571-581, December.
    • Handle: RePEc:tsj:stataj:v:7:y:2007:i:4:p:571-581
    as

    Download full text from publisher

    File URL: http://www.stata-journal.com/article.html?article=dm0033
    Download Restriction: no
    ---><---

    References listed on IDEAS

    as
    1. David Kantor & Nicholas J. Cox, 2005. "Depending on conditions: a tutorial on the cond() function," Stata Journal, StataCorp LP, vol. 5(3), pages 413-420, September.
    2. Nicholas J. Cox, 2002. "Speaking Stata: How to move step by: step," Stata Journal, StataCorp LP, vol. 2(1), pages 86-102, February.
    Full references (including those not matched with items on IDEAS)

    Most related items

    These are the items that most often cite the same works as this one and are cited by the same works as this one.
    1. Nicholas J. Cox, 2007. "Speaking Stata: Identifying spells," Stata Journal, StataCorp LP, vol. 7(2), pages 249-265, June.
    2. Nicholas J. Cox, 2008. "Stata tip 71: The problem of split identity, or how to group dyads," Stata Journal, StataCorp LP, vol. 8(4), pages 588-591, December.
    3. Nicholas J. Cox, 2007. "Speaking Stata: Turning over a new leaf," Stata Journal, StataCorp LP, vol. 7(3), pages 413-433, September.
    4. Nicholas J. Cox, 2011. "Speaking Stata: Compared with..," Stata Journal, StataCorp LP, vol. 11(2), pages 305-314, June.
    5. Nicholas J. Cox, 2006. "Speaking Stata: Graphs for all seasons," Stata Journal, StataCorp LP, vol. 6(3), pages 397-419, September.
    6. Nicholas J. Cox, 2011. "Stata tip 96: Cube roots," Stata Journal, StataCorp LP, vol. 11(1), pages 149-154, March.
    7. L. Philip Schumm, 2006. "Stata tip 28: Precise control of dataset sort order," Stata Journal, StataCorp LP, vol. 6(1), pages 144-146, March.
    8. Nicholas J. Cox & Gary M. Longton, 2008. "Speaking Stata: Distinct observations," Stata Journal, StataCorp LP, vol. 8(4), pages 557-568, December.
    9. Nicholas J. Cox, 2007. "Stata tip 43: Remainders, selections, sequences, extractions: Uses of the modulus," Stata Journal, StataCorp LP, vol. 7(1), pages 143-145, February.
    10. Maarten L. Buis, 2007. "Stata tip 48: Discrete uses for uniform()," Stata Journal, StataCorp LP, vol. 7(3), pages 434-435, September.
    11. Nicholas J. Cox, 2011. "Speaking Stata: Fun and fluency with functions," Stata Journal, StataCorp LP, vol. 11(3), pages 460-471, September.
    12. Nicholas J. Cox, 2005. "Speaking Stata: The protean quantile plot," Stata Journal, StataCorp LP, vol. 5(3), pages 442-460, September.
    13. Nicholas J. Cox, 2011. "Stata tip 101: Previous but different," Stata Journal, StataCorp LP, vol. 11(3), pages 472-473, September.
    14. Nicholas J. Cox, 2002. "Speaking Stata: On numbers and strings," Stata Journal, StataCorp LP, vol. 2(3), pages 314-329, August.
    15. Nicholas J. Cox, 2009. "Speaking Stata: Rowwise," Stata Journal, StataCorp LP, vol. 9(1), pages 137-157, March.
    16. Martin Weiss, 2009. "Stata tip 80: Constructing a group variable with specified group sizes," Stata Journal, StataCorp LP, vol. 9(4), pages 640-642, December.
    17. Nicholas J. Cox, 2012. "Speaking Stata: Output to order," Stata Journal, StataCorp LP, vol. 12(1), pages 147-158, March.

    More about this item

    Keywords

    data management; panels;

    Statistics

    Access and download statistics

    Corrections

    All material on this site has been provided by the respective publishers and authors. You can help correct errors and omissions. When requesting a correction, please mention this item's handle: RePEc:tsj:stataj:v:7:y:2007:i:4:p:571-581. See general information about how to correct material in RePEc.

    If you have authored this item and are not yet registered with RePEc, we encourage you to do it here. This allows to link your profile to this item. It also allows you to accept potential citations to this item that we are uncertain about.

    If CitEc recognized a bibliographic reference but did not link an item in RePEc to it, you can help with this form .

    If you know of missing items citing this one, you can help us creating those links by adding the relevant references in the same way as above, for each refering item. If you are a registered author of this item, you may also want to check the "citations" tab in your RePEc Author Service profile, as there may be some citations waiting for confirmation.

    For technical questions regarding this item, or to correct its authors, title, abstract, bibliographic or download information, contact: Christopher F. Baum or Lisa Gilmore (email available below). General contact details of provider: http://www.stata-journal.com/ .

    Please note that corrections may take a couple of weeks to filter through the various RePEc services.

    IDEAS is a RePEc service. RePEc uses bibliographic data supplied by the respective publishers.