EXCELSAVE: Stata module to provide a convenient way to export matched Stata datasets from a specified input directory (also including, if wanted, additionally recursively matched subsets of files within distinctly matched offspring-directories) to Excel-files

Lars Angquist ()

Statistical Software Components from Boston College Department of Economics

Abstract: excelsave provides a convenient way to export matched Stata datasets from a specified input directory (also including, if wanted, additionally recursively matched subsets of files within distinctly matched offspring-directories) to Excel-files.The achieved generality is governed by the options that implements e.g. the choice of folder, and a filename matching criterion to apply within this folder; moreover a distinct matching criterion for which subdirectories to similarly, recursively, search through may be stated. If wanted, only a matched subset of variables will be exported for all matched files. Moreover, one may also select whether the output Excel-files should be created in .xls or .xlsx format (the latter serves as the default). Further, it works as a full wrapper of –export excel- and hence all options defined with respect to that command may be used here as well. Typical use could e.g. be to export a certain large set of files located within a specific directory-structure to Excel before sharing them with co-workers. All matchings are case-sensitive. All options are optional and corresponding defaults exists.

Language: Stata
Requires: Stata version 9
Keywords: data files; data management; Excel (search for similar items in EconPapers)
Date: 2013-04-06
Note: This module should be installed from within Stata by typing "ssc install excelsave". 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.
References: Add references at CitEc
Citations:

Downloads: (external link)
http://fmwww.bc.edu/repec/bocode/e/excelsave.ado program code (text/plain)
http://fmwww.bc.edu/repec/bocode/e/excelsave.sthlp help file (text/plain)

Related works:
This item may be available elsewhere in EconPapers: Search for items with the same title.

Export reference: BibTeX RIS (EndNote, ProCite, RefMan) HTML/Text

Persistent link: https://EconPapers.repec.org/RePEc:boc:bocode:s457628a

Ordering information: This software item can be ordered from
http://repec.org/docs/ssc.php

Access Statistics for this software item

More software in Statistical Software Components from Boston College Department of Economics Boston College, 140 Commonwealth Avenue, Chestnut Hill MA 02467 USA. Contact information at EDIRC.
Bibliographic data for series maintained by Christopher F Baum ().