How to export high-quality table of correlations from Stata to MS Word

Zhang Huang

I can’t download asdoc from the stata. Can you help me and sent the asdoc.ado and asdoc.sthlp to me?
Thank you.

Zhang Huang

Sorry. It always replies like this in Stata:

ssc install asdoc, replace

checking asdoc consistency and verifying not already installed…
connection timed out -- see help r(2) for troubleshooting
could not copy http://fmwww.bc.edu/repec/bocode/a/asdoc.sthlp
(no action taken)
r(2);

I think maybe because I am in China, so the download action is defined.

Attaullah Shah

OK, copy the attached files to the mentioned directories

copy asdoc.ado and asdoc.sthlp to this folder

C:/ado/plus/a

2. Copy the lasdoc.mlib to this folder

C:/ado/plus/l

The last letter is L in small.

Simon

Hi Attaullah,

How can I get the star sign in the correlation number? Is it possible to get it using the asdoc command.

Simon

Hi Attaullah,

Many thanks for your reply. can we get also 0.05 and 0.10. I have tried with the given code but it does not work.

Regards,

Simon

Anonymous

Many thanks Attaullah. I understand your point. But actually, my query was in one table, how we can generate all star sign for 0.1, 0.5, and 0.01. Similar like the correlation table published in the article. Sometimes, in one table, some variables may be significat at 1%, some at 5% and some at 10%.

Appreciate your help.

Thanks again.
Regards,
Simon

Philipp

Thank you very much Attaullah. I have one question:

I have a lot of independent variables (41) in my correlation matrix. How can i prevent that asdoc exports them and needs more than the breadth of one page in word? In an ideal case i can tell asdoc to continue the correlation matrix at the next page.

Do you know if there is such an opportunity?

Thank you in advance!

Philipp

Philipp

Dear Attaullah. No worries. I dont want to estimate all of the variables within one model. With the large variable list i can show that for several combinations of variables serious issues of multicollinearity arise. Thereby i can justify my choosen model better.

Professor Michael Glencross

Dear Professor Shah

I have recently come across your excellent addition to Stata in the form of asdoc. Is there any way that it can be made compatible with Stata 11?

Kind regards

Michael Glencross

Attaullah Shah

Dear Michael Glencross
The only reason asdoc does not support Stata 11 is that the Stata Corp. introduced the r(table) with regression commands in Stata 12 and onwards. Since asdoc creates regression tables from r(table) matrix, therefore, I restricted it to version 12 and onwards. Still, if you do not use asdoc for regressions, it can still work with Stata 11. So find asdoc.ado on your computer, open it with notepad or Stata do editor and delete the line version 12.
Restart Stata and it will work with Stata 11.

Professor Michael Glencross

Dear Professor Shah

I have another query and hope you don’t mind me asking for your help again.

I have done as you said and removed the line version 12 from my asdoc.ado file.

I ran: asdoc tab gender and received the following error message:

asdoc_tab_onevar() in lasdoc, compiled by Stata 11.1, is too new to be run by this version of Stata and so was ignored

Is there something I can do to overcome this?

Your help will be much appreciated.

Kind regards

Michael Glencross

Chris Boulis

Dr. Attaullah Shah .

I have just downloaded asdoc and am planning to capture the results from three pairs of regressions. Each pair regresses the same control variables, but changes the dependent variable (I have 2 measures of my depvar). Each pair works the same, but in each pair I assess the impact of a slightly different life event.

I’ve watched your youtube video which shows how to keep adding variables, but I was wondering how I do that in my case?

I’d like to produce a table where the rows included all the control variables (which as I said are the same for each regression) and across the columns have the three different life events – with two separate columns below each life event to show the results of my two measures of my depvar.

I would really appreciate your guidance on how I can do this using your package asdoc. I tried using outreg but copying the table to word in html format leaves a mess that will require a lot of time to make it presentable.

Kind regards,
Chris

Chris Boulis

Dr Attaullah Shah.

Thank you for your response. However, after I tried that, it moved all independent variables wide and only had the two measures of the depvar in rows, which results in the table being too wide. I need all the indepvars in the rows and each pair of depvars for each of the three life events across the columns.

The following is an example of the table I am trying to obtain from my six regressions (e.g.

Life event1 – depvar1, Life event1 – depvar2, Life event2 – depvar1, Life event2 – depvar2, Life event3 – depvar1, Life event3 – depvar2).

Variables                    Life event 1                                    Life event 2                                   Life event 3
                              depvar1       depvar2                   depvar1       depvar2                    depvar1       depvar2
                                0.003             0.004                         0.25               0.21                            0.32              0.28
                                                                                                      
Control vars

Sex                               0.22           0.19                          0.25              0.36                           0.38                0.42
Age                               0.65           0.54                          0.32              0.45                           0.62                0.49                
Emp Status                 etc
Income
Education

Kind regards,
Chris

Chris Boulis

Dear Dr Attaullah Shah.

Thank you for your assistance. Unfortunately, I am using a very large panel dataset and not permitted to share sorry.

I used the following code and added several other regressions and was able to get close to what I wanted but I had to do a fair amount of formatting as it carried over the pre-recoded (original) variables names, but that’s ok. I need to finalise this for tomorrow. The output I have I have now is much better than using ‘outreg’.

asdoc xtreg relat b100.time_marr_sep b10.rel b1.age b1.empstat b9.edlev ///

b1.Inc if reli ! = . & wave > = 4 & wave < = 14  & time_marr_sep  96, fe nest replace

 

asdoc xtreg reli b100.time_marr_sep b10.rel b1.age b1.empstat b9.edlev ///

b1.Inc if relat ! = . & wave > = 4 & wave < = 14  & time_marr_sep  96, fe nest append

 

etc.

What do you think?

Kind regards,

Chris

Nighat Seema

Dear Sir

Hope you are fine. I am facing some issue in output of corr matrix via asdoc. I am using the command

asdoc cor f_con f_con2 f_man exp own_foreign bank_loans audit web exports f_age, label replace

The output table attached below does not include the names of all the variables. Kindly suggest something in this regard. I will be really thankful to you.

Regards