Export output from Stata’s LIST command

Export output from Stata list command

Struggling to export results from Stata’s list command to formats like Excel, Word, HTML, or LaTeX? Look no further! This tutorial guides you through using asdocx, a powerful tool that simplifies the process.

With asdocx, you can easily export both variable names and values, along with their corresponding labels using the label option. And the best part? If asdocx is already set up, simply prefix your list command with asdocx! For instance, to export the list output to Microsoft Excel, you’d simply use:

sysuse nlsw88
asdocx list idcode age race married industry, label save(File.xlsx) replace

Both if and in qualifier are supported.

sysuse nlsw88
asdocx list idcode age race married industry in 1/20, label save(File.xlsx) replace

Export to LaTeX

To export in different formats, simply modify the file extension. For instance, to save in LaTeX format, use the option save(Myfile.tex)

* Load data

sysuse nlsw88, clear
‎
* Export the first 20 values in LaTeX Format
asdocx list idcode age race married industry in 1/20, label save(File.tex) replace

Other uses of list

The idea of using the list command as a tool of creating results table is to create a Stata dataset and export it. Several Stata commands can be used to create a new dataset of results from the existing one. The most commonly used command is the collapse command.

sysuse nlsw88
collapse (sum) wage , by(industry race)

* Create a table from the collapsed data
asdocx list

Export a two-ways table

After collapsing the data, we have two grouping variables, that are race and industry, and one numerical variables, i.e, wage. We can use the tabdisp command to create a two way table. The variable industry has 12 levels and race has three levels. Therefore, the table will look much better if we report industry in rows and race in columns. The values of the wage variables that occur at the intersection of the levels of industry and race will be reported in cells. The asdocx code for this is:

asdocx tabdisp industry race , c(wage) replace

See also

• fre – One-way frequency tables
• crosstab – table of means and weighted by in cross tabulations
• missings – Various utilities for managing missing values
• mrtab – One- and two-way tables of multiple responses
• pctab – Percentage over a grouping variable
• tab3way – Three way table of frequencies and percentages
• tabcount – tabulates frequencies for up to 7 variables
• tabmany – Table of multiple coded answers
• tabulate, tab1, tab2

Order asdocx

Yearly license of asdocx is available at $14.99. Its life-time license is available at $59.99. With the asdocx membership, you get :

• Life-time license to use
• All future updates
• All premium templates / plugins.