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

APPLYVARLABELS: Stata module to apply variable labels to the data in memory from a two-column (Variable, Label) crosswalk

Author

Listed:
  • Eric A. Booth

    (Texas 2036)

Programming Language

Abstract

Label the variables in memory from an Excel workbook or a delimited file that lists each variable name beside the label it should carry. Solves the Statalist problem (thread 1768839) where a levelsof/tokenize loop puts the wrong label on the wrong variable because levelsof sorts the labels alphabetically. applyvarlabels reads the crosswalk in row order and matches every label to its variable BY NAME, never by position. It writes a capture-guarded relabel do-file (a variable named in the crosswalk but absent from the data is skipped, not an error), runs it to apply the labels, and prints an inventory of what did not line up: crosswalk rows with no such variable, and variables in memory with no crosswalk row. The data in memory are never sorted, dropped, or reordered - the crosswalk is read in its own frame, so nothing changes but the variable labels themselves. The generated do-file is a keepable, rerunnable artifact (see dofile()). Reads .xlsx/.xls and .csv/.tsv/.txt; nocase matches names ignoring case; norun writes the relabel do-file without applying it.

Suggested Citation

  • Eric A. Booth, 2026. "APPLYVARLABELS: Stata module to apply variable labels to the data in memory from a two-column (Variable, Label) crosswalk," Statistical Software Components S459844, Boston College Department of Economics.
  • Handle: RePEc:boc:bocode:s459844
    Note: This module should be installed from within Stata by typing "ssc install applyvarlabels". The module is made available under terms of the MIT license (https://opensource.org/licenses/MIT).
    as

    Download full text from publisher

    File URL: http://fmwww.bc.edu/repec/bocode/a/applyvarlabels.ado
    File Function: program code
    Download Restriction: no

    File URL: http://fmwww.bc.edu/repec/bocode/a/applyvarlabels.sthlp
    File Function: help file
    Download Restriction: no

    File URL: http://fmwww.bc.edu/repec/bocode/e/example_applyvarlabels.do
    File Function: example do-file
    Download Restriction: no

    File URL: http://fmwww.bc.edu/repec/bocode/e/example_varlabels.xlsx
    File Function: example dataset
    Download Restriction: no

    File URL: http://fmwww.bc.edu/repec/bocode/m/make_example_varlabels.py
    File Function: Python helper script
    Download Restriction: no
    ---><---

    More about this item

    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:s459844. 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.