Publication quality regression tables with asdoc in Stata – video example

Nicole Martin

Firstly, thank you for making your Stata package available – it’s really speeding up my workflow compared to the other options available. I’m writing to make a suggestion that you consider adding an option that value labels can be reported in regression tables as well as variable labels.

Many thanks, and best wishes,

Emily

Can ” asdoc” export the OR and 95% CI from logistic regression analysis?

Eric

asdoc is an amazing service to the field. Appreciate it very much. Like Nicole, I would love a labels option for regression outputs. That function works great for asdoc sum, but would be of great value in this function too.

Thanks again.

Attaullah Shah

Dear Eric and Nicole, thanks for your suggestions. I am exploring the suggested possibilities. Since version 2 of asdoc is almost ready, I may come up with label option in version 3 or version 2.1.

Sher Khan

Appreciate for your great work ,thank you for making your Stata package available – it’s really speeding up my workflow and saved time. Honestly , i learned a lot .
i asked one question Can asdoc command used for advance Dynamic Model ? e.g asdoc reg .. How to used for Dynamic Model to create tables ? Your response with this regard is highly appreciated

Attaullah Shah

Sher Khan, can you tell which specific Stata command are you referring to?

Mike

I am excited to see this! However, I have a question. What would the code be if we want to put several models into the same table with different IVs but the same DV? So, say in the first model I want to include IV1, in the second model IV2, and so forth. But in model 6 I want to include IVs1-IVs5. What would this code look like if I’m nesting my model?

Justin

This is a wonderful tool! Thank you so much for making this available.

I see asdoc v2.0 allows ORs from ologit in the detailed table output. Is it possible to display ORs in the nested table output as well?

Justin

That would so fantastic. Being able to use the reporting options, nested ORs and 95% CIs especially, to get tables directly to Word would save me hours of table-copying.

Attaullah Shah

Justin: You mean to report the 95% CIs instead of t-values or standard errors?

Justin

Yes!

Ayub

Thank You so much sir for sharing your knowledge with.us.sir I have one question, how can I replace t-value on se value in regression tables, I tried but it shows se value in. perenthesis in word tables.plz, guide me. best regards

Dr Zumin Shi

I like your asdoc very much. In epidemiological research, we often focus on one independent variable (recoded into quartiles) and run multiple multivariable models (with different adjustment). The regression coefficients are often reported in one table (see below). Is it possible to do it using asdoc?

note: model 1 adjusted for age
model 2 further adjusted for education, and physical activity
model 3 further adjusted for hypertension.

p for trend was calculated using qartiles of fruit intake as an ordinal variable in logistic regression.
The table is based on six logistic regression models.

Bassem Hamandi

Thank you for developing this Stata package. I wonder if there is a way to export the 95% confidence interval reported after running stcox in Stata? My apologies if this is trivial but I could not find any details in the help file.
Thank you for any help you can provide.

Bassem Hamandi

Thank you. I am hoping to report using detailed regression tables.

Juan Miranda

Dear Attaullah Shah, good afternoon.

I’m a Stata user, but some programming things I do not understand yet.
I’ve been looking at forums like https://stackoverflow.com/questions/53524560/looping-and-storing-beta-coefficients-after-regress-over-files#new-answer
answer to a question I have.

I am not able to make my loop save the results after regressing over files (betas, t, R2 and N), with all my datasets. I have 11 named 2005.dta to 2017.dta (except for 2009) contained in a folder (F:\datasets).

The objective is to use asdoc, and to generate a summary table of the estimates I make. The code that I have written is the following.

cd "F: \ datasets"
local i: dir. files "* .dta"
foreach file in `i '{
    asdoc reg and x1 x2 x3, append nest rep (t | se) title (Table 1 MCO per year) dec (3)
}

But the result is that asdoc saves the results of a single database (only the first – 2005) 11 times and does nothing for the others.

If you could have time to help me solve this problem I would thank you very much.

Cheers Juan

Dr. Naimat Ullah Khan

Salam Jee,

If I wish to generate a table with standard errors instead of p-values, what I have to do with asdoc command?

Dr. Naimat Ullah Khan

Dear Sir Jee
Every time I use asdoc, I pray for you my heart.

Preshit Ambade

Hello Dr. Shah,
Wonderful work on asdoc. It has made life easy for many students like me. I am using Fairle decomposition in stata with ado. file for it. I found the asdoc command doesnot work with it. If you get time please check it and update it in the next version. Thank you.

Regards
Preshit

HP

Hello Dr. Shah,
H have few questions?
1. I am wondering if we can use order option in asdoc regresssion as

asdoc reg price mpg trunk, nest rep(t) dec(2) replace order (_cons trunk mpg)

. I want to use order option like estout.
2. Is there decimal alignment options?
Thank you for your help .
HP

HP

Thanks. One more question.
How to report Pseudo R2 in asdoc regression results.
Thanks.
HP

Krishanu Karmakar, PhD

Recently I came across your -asdoc- routine in Stata and was trying to use it for my Econometrics courses. I think I came across a bug in the routine. If you have time kindly have a look at it. The stata code is copied below.

Description of the problem: When creating tables with multiple equations, where one of the equations may have a logged dependent variable, it is quite difficult to use the eform option with asdoc – mostly the output is wrong. Probably you did intend to make “eform” an option for asdoc. It still takes the option but makes only the first equation of the set exponentiated. No matter which command I add the “eform” option to, it is always only the first equation that is exponentiated. code below.

System: Windows 10, asdoc version 2.2.0

***************************************

version 14.2

sysuse auto, clear
gen lnmpg=ln(mpg)

*base models, no exponentiation tried
asdoc reg mpg turn, eform() save(file.doc) reset nest  replace
asdoc reg lnmpg turn, save(file.doc) nest  
asdoc reg lnmpg turn, save(file.doc) nest ///
            title(table1: base models, no exponentiation tried) 

*eform() in first command - nothing happens
asdoc reg mpg turn, eform() save(file.doc) reset nest
asdoc reg lnmpg turn, save(file.doc) nest  
asdoc reg lnmpg turn, save(file.doc) nest ///
            title(table2: eform in first command - nothing happens) 

*eform() all last command - first equation exponentiated
asdoc reg mpg turn, eform() save(file.doc) reset nest  
asdoc reg lnmpg turn, eform() save(file.doc) nest  
asdoc reg lnmpg turn, eform() save(file.doc) nest ///
            title(table3: eform in all commands - only first equation exponentiated) 
***********************************************************

Anyway, notwithstanding this small bug, thank you for writing a quite useful routine.

Joanna Woersching

Hi Dr. Shah,
Thank you very much for this wonderful program, will save me hours of table editing. I was hoping to create a nested table with odds ratio, se and confidence interval listed, are these options for asdoc nest? Thank you, Joanna Woersching

asdoc logistic stagedx3 eldepression elpsychosis elotherneurological eldrugabuse elalcoholabuse ///
ib2.casite2 i.sex2 i.agecat ib1.race2 elixscoret ib3.medincomecat ib2.insurance3 eltobacco, stats(se ci) ///
base cluster(facility), nest append dec(2)

Krishanu Karmakar

Thank you for taking a look at it and spending your valuable time on this. This command is a wonderful addition to user written commands of Stata.

Daniel

When I use logit with or option, it provides the coefficient instead of the odds ratio. I check the numbers, and those were coefficient, and not OR. IS there a way to display the odds ratio?

Richard Makurumidze

Greetings

It seems asdoc does not work with the chi (chi -square) and or (odds ratio) in logistic regression. Is this correct or am making some error?

Micah

Hi there!

– Is there any way to export ONLY the coefficients in the nested regression output table? Without including standard errors OR t-values?
– Or if not, is there a way to export the table so that the standard errors / t-values are in the same table cell as the coefficients? And not in the cell below them?

Thank you so much for all that you do!!

Kabir Ahmed

Is the asdoc for un-weighted estimates?
asdoc svy: table sex urb, col row sc format(%11.0f) //gives unweighted estimates
asdoc table sex urb, col row sc format(%11.0f) //gives unweighted estimates
table sex urb[pw=wgt_test], col row sc format(%11.0f) //gives weighted estimates
kindly clarify it.

Theo

Hi,
Is it possible to get the same table as with nest function, with the wide format? Missing t values or standard deviation , with p values in the wide version.

Thanks.

ALI UBAID

Dear professor,
margins are not working in my analysis. Is this command is not compatible with asdoc? or I am doing it wrong? Kindly advise
……………………………

ALI UBAID

apologies for bothering you, I found the correct command online it was helpful and issued resolved.

asdoc margins, dydx(rem_for_dummy), save(margins.doc) title(marginal effect)

Average marginal effects                        Number of obs     =      3,305
Model VCE    : Linearized

Expression   : Pr(lab_per_dum), predict()
dy/dx w.r.t. : rem_for_dummy

-------------------------------------------------------------------------------
              |            Delta-method
              |      dy/dx   Std. Err.      z    P>|z|     [95% Conf. Interval]
--------------+----------------------------------------------------------------
rem_for_dummy |   .0253485   .0122308     2.07   0.038     .0013765    .0493205
-------------------------------------------------------------------------------
(note: file margins.doc not found)
Click to Open File:  margins.doc

Thank you for your response.

Theo

Hi,

Thanks for replying.

When you use the nested function, you get SD values in parentheses under the coefficients. You also get *** for p values. And you have the dependent variable in the columns.
With the wide function, where you have the dependent variables in the rows, you do not get the SD in parentheses under the coefficients. So, i would like in the wide option to have the same model output as with the nested function, only with the dependent variables in the rows, such as with the wide option. I would like the t values to be switched out with SD in the wide option also.

Hope this is a little more clear.

Jana Tillmann

Dear Professor Shah,

I am very thankful for your asdoc – breakthrough – program.
My name is Jana Tillmann and I currently write my Thesis. Hopefully, you can help me with this issue, it is very urgent as I have to hand in the thesis on Thursday.
What can I do to create a nested table with multiple additional regression statistics?

When I try to create nested regression tables, I can not find a solution to extend the tables with multiple additional regression statistics.

Here is the command I use:

asdoc reg v_fisccap v_cspart, nest  stat(N rmse r2_a) replace

If I use only one additional statistic:
– RMSE:

asdoc reg v_fisccap v_cspart, nest  stat(rmse) replace

If I use stats() instead of stat(), I don’t get any additional statistics:

asdoc reg v_fisccap v_cspart, nest  stats(N rmse r2_a) replace

If I list them separately, it only gives me the latter one:

asdoc reg v_fisccap v_cspart, nest stat(F) stat(rmse) replace

With a wide format, it does work:

asdoc reg v_fisccap v_cspart, wide stat(N rmse r2_a) replace

What can I do to create a nested table with a few extra regression statistics?

Jana Tillmann

Dear Professor Shah,

I am very thankful for your asdoc – breakthrough – program.
My name is Jana Tillmann and I currently write my Thesis.

Hopefully you can help me with this issue, it is very urgent as I have to hand in the thesis on Thursday.
What can I do to create a nested table with multiple additional regression statistics?

When I try to create nested regression tables, I can not find a solution to extend the tables with multiple additional regression statistics.

Here is the command I use:

asdoc reg v_fisccap v_cspart, nest  stat(N rmse r2_a) replace

If I use only one additional statistic:
– RMSE:

asdoc reg v_fisccap v_cspart, nest  stat(rmse) replace

If I use stats() instead of stat(), I don’t get any additional statistics:

asdoc reg v_fisccap v_cspart, nest  stats(N rmse r2_a) replace

If I list them separately, it only gives me the latter one:

asdoc reg v_fisccap v_cspart, nest stat(F) stat(rmse) replace

With a wide format, it does work:

asdoc reg v_fisccap v_cspart, wide stat(N rmse r2_a) replace

What can I do to create a nested table with a few extra regression statistics?