The list command

---

list displays the values of variables. asdocx can export the output from list command to Excel, Word, HTML, or LaTeX. With the label option, both variable labels and values labels can be exported. Here is a working example to export its output to MS Excel.

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

 

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

 

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

---

• tabmany – Table of multiple coded answers
• mrtab – One- and two-way tables of multiple responses
• tabcount – tabulates frequencies for up to 7 variables
• missings – Various utilities for managing missing values
• tabulate, tab1, tab2

 

Order asdocx

---

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

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