IDEAS home Printed from https://ideas.repec.org/c/boc/bocode/s456866.html
 

KEYBY: Stata module to key the dataset by a variable list

Author

Listed:
  • Roger Newson

    (King's College London)

Programming Language

Stata

Abstract

keyby sorts the dataset currently in memory by the variables in a varlist, checking that the variables in the varlist uniquely identify the observations. This makes the variables in the varlist a primary key for the dataset in memory. If the user does not specify otherwise, then keyby also reorders the variables in the varlist to the start of the variable order in the dataset, and checks that all values of these variables are nonmissing. keybygen sorts the dataset currently in memory by the variables in a varlist, preserving the existing order of observations within each by-group, and then generates a new variable, containing the sequential order of each observation within its by-group, to form a primary key with the existing variables in the varlist. keyby and keybygen can be useful if the user combines multiple datasets using merge, which may cause a dataset in memory to become unsorted.

Suggested Citation

  • Roger Newson, 2007. "KEYBY: Stata module to key the dataset by a variable list," Statistical Software Components S456866, Boston College Department of Economics, revised 30 Jul 2014.
    • Handle: RePEc:boc:bocode:s456866
    Note: This module should be installed from within Stata by typing "ssc install keyby". The module is made available under terms of the GPL v3 (https://www.gnu.org/licenses/gpl-3.0.txt). Windows users should not attempt to download these files with a web browser.
    as

    Download full text from publisher

    File URL: http://fmwww.bc.edu/repec/bocode/k/keyby.ado
    File Function: program code
    Download Restriction: no
    File URL: http://fmwww.bc.edu/repec/bocode/k/keyby.sthlp
    File Function: help file
    Download Restriction: no
    File URL: http://fmwww.bc.edu/repec/bocode/k/keybygen.ado
    File Function: program code
    Download Restriction: no
    File URL: http://fmwww.bc.edu/repec/bocode/k/keybygen.sthlp
    File Function: help file
    Download Restriction: no
    ---><---

    More about this item

    Keywords

    data manipulation; sort; key; Stata;
    All these keywords.

    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:boc:bocode:s456866. 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.

    We have no bibliographic references for this item. You can help adding them by using 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 (email available below). General contact details of provider: https://edirc.repec.org/data/debocus.html .

    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.