Export Summary Statistics from Stata to Excel, Word | asdocx

  Export Summary Statistics from Stata

‎

  Default summary statistics

---

The default in asdocx is to report mean, standard deviation, minimum, maximum for all numeric variables. Therefore, we do not need to type variable names with the sum command.

* Load Example dataset
sysuse auto, clear

* Estimate summary statistics
asdocx sum, replace

Statistics for selected variables

---

In case summary statistics are required only for selected variables, then we need to write the variable names after the sum word. Assume that we need summary statistics for price, trunk, mpg, weight, and foreign, our code and results are shown below.

asdocx sum price trunk mpg weight foreign,  replace

Reporting variable Labels

---

Variable labels can be reported with the option label. This option works with all other tables that asdocx can create. If a variable does not have a label, then the variable name is reported.

asdocx sum price trunk mpg weight foreign,  replace label

  Using [if] [in] conditions

---

asdocx accepts if and in conditions just like any other Stata command. Both if and in should come at the end of the variable list and before the ,. See the following example where we want to report descriptive statistics for cases where the car price is greater than 4000.

asdocx sum if price > 4000,  replace

  Controlling decimal points

---

Decimal points can be controlled using the dec() option. The default is to report three decimal points. If we were to report 4 decimal points, we shall add dec(4) option.

asdocx sum ,  dec(4)

tzok : Reporting equal number of decimal points

---

In the preceding example, we reported four decimal points using option dec(4). However, some of the values have no decimal points. The reason is that asdocx does not report decimal points if all the trailing values are zeros. We can force asdocx to report equal number of decimal points even if all trailing values are zero. This can be done using the option tzok, that is, trailing zeros ok.

asdocx sum ,  dec(4) tzok

Detailed summary statistics

---

To find detailed summary statistics, we normally type summarize, detail or sum, detail command in Stata. To make a table of detailed summary statistics, we shall just add detail after comma to the asdocx sum command. Using this option, the following statistics are added to the table : observations, mean, standard deviation, minimum, maximum, 1st percentile, 99th percentile, skewness, and kurtosis. If additional statistics or a specific combination of statistics are required, then we can use the customized statistics option [see the following section].

asdocx sum,  replace detail

Custom summary statistics

---

To make a table of a specific combination of statistics, use the option statistics() or stat() with asdocx sum command. Option statistics() allows the following statistics:

Assume that we wish to report mean, standard deviation, t-value, 1st, and 99th percentiles for all variables.

asdocx sum,  replace stat(N mean sd tstat p1 p99)

  Statistics over a grouping variable

---

To find summary statistics separately for each category of a grouping variable, we can use by(varname) or the prefix bysort varname: with asdocx. Examples of grouping variables can include country, year, industry, gender, family, etc. In the following example, let us report mean SD, t-value 1st and 99th percentiles for each category of the variable foreign. In the auto dataset, the variable foreign has two categories : Domestic and Foreign.

bys foreign : asdocx sum,  replace stat(N mean sd tstat p1 p99)

  See also

---

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

  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.