A sparser, speedier reshape

Kenneth Simons

Stata Journal, 2016, vol. 16, issue 3, 632-649

Abstract: A new command, sreshape, supports sparse and speedy reshaping of data. Often reshaped data are “sparse” in the sense of containing many miss- ing values that are dropped after reshaping. sreshape automates the process of reshaping and dropping such missing information to avoid potential errors and, for both sparse and nonsparse data, yields speed improvements. Using large test datasets, sreshape achieves identical results to reshape 8 to 31 times faster in wide-to-long reshapes and 2 to 13 times faster in long-to-wide reshapes. Further suggested improvements may allow StataCorp to increase these speed gains in the built-in version. Copyright 2016 by StataCorp LP.

Keywords: sreshape; reshape; sparse data; missing data; long form; wide form; data management; speed (search for similar items in EconPapers)
Date: 2016
Note: to access software from within Stata, net describe http://www.stata-journal.com/software/sj16-3/dm0090/
References: Add references at CitEc
Citations:

Downloads: (external link)
http://www.stata-journal.com/article.html?article=dm0090 link to article purchase

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:tsj:stataj:v:16:y:2016:i:3:p:632-649

Ordering information: This journal article can be ordered from
http://www.stata-journal.com/subscription.html

Access Statistics for this article

Stata Journal is currently edited by Nicholas J. Cox and Stephen P. Jenkins

More articles in Stata Journal from StataCorp LLC
Bibliographic data for series maintained by Christopher F. Baum () and Lisa Gilmore ().