## asdoc version 2 : Summary of New features | export Stata output to MS Word

Category:UncategorizedVersion 2.0 of asdoc is here. This version brings several improvements, adds new features, and fixes minor bugs in the earlier version. Following is the summary of new features and updates.

### Brief Introduction of asdoc

asdoc sends Stata output to Word / RTF format. asdoc creates high-quality, publication-ready tables from various Stata commands such as summarize, correlate, pwcorr, tab1, tab2, tabulate1, tabulate2, tabstat, ttest, regress, table, amean, proportions, means, and many more. Using asdoc is pretty easy. We need to just add asdoc as a prefix to Stata commands. asdoc has several built-in routines for dedicated calculations and making nicely formatted tables.

### How to update

The program can be updated by using the following command from Stata command window

ssc install asdoc, replace

## New Features in Version 2.0

### 1. Wide regression tables

This is a new format in which regression tables can be reported. In this format, the variables are shown in columns and one regression is reported per row. Therefore, this type of regressions tables is ideal for portfolios, industries, years, etc. Here is one example of a wide regression table. asdoc allows a significant amount of customization for wide tables including asterisks for showing significance, reporting t-statistics and standard errors either below regression coefficients or sideways, controlling decimal points, reporting additional regression statistics such adjusted R2, RMSE, RSS, etc., adding multiple tables in the same file, and several other features. Read this post to know more about wide table format.

### 2. Allowing by-group regressions

Version 2.0 of asdoc provides the convenience of estimating regressions over groups and summarizing the regression estimates in nicely formatted tables. This feature follows the Stata default of *bysort* prefix. This feature works with all three types of regression tables of asdoc that include detailed regression tables, nested tables, and wide tables. In this blog post, I show some examples of by-group regressions.

### 3. Allowing by-group descriptive statistics

Using the *bysort* prefix with asdoc, we can now find default, detailed, and customized summary statistics over groups. Details related to this feature will be added later on in a blog post.

### 4. Option label with *tabulate* and *regress *commands

Option *label* can now be used with regression and tabulation commands. Using this option, asdoc will report variable labels instead of variable names. In case variable labels are empty, then the variable names are reported.

### 5. Developing tables row by row using option row

Option *row* is a new feature in version 2. Option row allows building a table row by row from text and statistics. In each run of asdoc with option *row*, a row is added to the output table. This is a useful feature when statistics are collected from different Stata commands to build customized tables. To know more about this option, read this blog post.

### 6. Accumulate text or numbers with option accum

Option *accum* allows accumulating text or numbers in a global macro. Once accumulated, the contents of the macro can then be written to an output file using option *row*.

### 7. Saving files in different folders

One additional feature of version 2.0 is the ability to write new files or append to existing files in different folders.

## 17 Comments

## Sophia

September 20, 2018at 6:07 pmHi, “asdoc” is very useful!

Would you give an example of its application in logistic regression or , Poisson regression analysis?

Thanks

## Attaullah Shah

September 20, 2018at 6:13 pmSophia: There are three types of regression tables that asdoc can create. Can you please specify which regression table do you intend to make. The regression table types are 1. detailed table 2. nested tables and 3. wide tables. If you open the asdoc help file by typing

in the Stata command window, there you can see further details on these regression types. See table of contents, entries 4.1, 4.2, and 4.3

## Walker

October 24, 2018at 1:12 amHi, asdoc is wonderful.

I am running into an issue with the bysort command where the word or rtf files will not open, and Microsoft Word returns the error “Word was unable to read this document. It may be corrupt.”

example includes:

I do not have this issue when creating bysort regression output.

Any help would be greatly appreciated.

Thanks!

## Attaullah Shah

October 24, 2018at 1:19 amWalker: Please update to version 2.2 and the problem should be solved

## Walker

October 31, 2018at 7:22 pmThanks for the reply. I am running v 2.2. I have uninstalled, replaced and restarted the program. I continue to get the following message when I try to open the file generated by any either version of the summary statistics over grouping variable options:

## Attaullah Shah

October 31, 2018at 8:26 pmWalker: Can you please do the following?:

1. use the bysort prefix with sum command and option replace e.g.

2. Send the file Myfile.doc to my email address at attaullah.shah@imsciences.edu.pk

I shall investigate the source of the error. Thanks for your time and feedback.

## Joske

January 10, 2019at 3:55 pmHi,

I would like to use the bysort option, but I was wondering if you can use more than 1 varname after bysort?

## Attaullah Shah

January 10, 2019at 4:30 pmJoskeYou can use

`bysort`

with more than one variables by creating a grouping variable. So using the auto dataset, we can group together the variableforeignandrep78.## Joske

January 10, 2019at 7:16 pmThanks for your reply. It’s working.

## Jukka34

February 19, 2019at 4:50 pmIs it possible to use asdoc with multinomial logistic regression in Stata

## Attaullah Shah

February 22, 2019at 8:02 amJukka34

## Trisha

June 10, 2019at 8:14 amIs there any option analogous to the unstack option in estout for multinomial logistic regressions? I want my results to be displayed side by side for each category of the dependent variable.

## Attaullah Shah

June 10, 2019at 11:26 amTrisha

Currently, unstack option is not available in asdoc. That is on my agenda since long. Thanks for reminding.

## Lola

June 14, 2019at 1:33 pmHello, first of all, thank you for the asdoc, it has enabled me to create regression outputs so conveniently. The only problem that I am facing now is that the variable labels do not appear. I have categorical variables and when I do the regression using for example i.education, I do not get the different categories in the output, even though I use the label function and I also updated the version. Could you please let me know what I am doing wrong?

Best Regards,

Lola

## Attaullah Shah

June 14, 2019at 2:13 pmLola

Thanks for your feedback. Can you please send a sample of your data at attaullah.shah@imsciences.edu.pk

## Lola

June 14, 2019at 4:36 pmDear Mr. Shah,

I am writing to you regarding a problem that I am facing with asdoc, and as you suggested me at your website, I am sending you the data that I am working with. What I want from the output table is that in cases of categorical variables, such as the variable education_isced, the name of the variable (”education_isced”) and also the labels (”primary”, ”secondary”) to appear in the output table.

Please let me know how I could fix this problem.

The code that I have used is :

I sincerely thank you for your time and help.

## Attaullah Shah

June 14, 2019at 4:39 pmThe label option sends the variable labels, not the value labels. You are asking for both the variable name and the list of value labels. That is too much to code. You have to first get the value label categories and then combine the name and these categories. And in some cases, the two would be too long to accommodate in the regression table. Still if you are interested, the following solution will work.

1. Get the value lables for each variable ( https://www.statalist.org/forums/forum/general-stata-discussion/general/706869-show-label-value) see one method discussed here, See Nick Solution in post # 6

2. combine the variable name and the value labels

3. Write the combined value to the variable label using

4. And then use the same asdoc code as you are using now i.e. using option label. Whatever is written in the variable label will appear in the regression table.