how to display multiple stars in spearman and export them to excel

[Arnoud Blaakmeer]

Dear all,

i was using the following commands to export a correlation matrix with significance stars on three levels to either word or excel;

estpost correlate financialconstraint k16 noneed, matrix
esttab using D:\test\test_correlation.csv, unstack not noobs compress replace

I need to make the spearman matrix and be able to export it with significance stars (0.001 / 0.01 / 0.05) to excel, I have over 60 variables and it takes significant time to do it manually. Unfortunately the above commands do not work, please help?

Thanks,

Arnoud

[Damien Dussaux]

Hi Arnoud,

You may have figured it out since May, but I think it is interesting to know why the commands did not "work".

I identify 2 potential reasons that it is not working:

1) The matrix you try to generate with estpost could exceed the maximum size of a matrix in stata.
The maximum number of cells of matrix for Stata/MP and Stata/SE is 11000 and 800 for Stata/IC.
This means that the maximum number of variables you could have in the correlation table is 147 since 147 variables requires 10878 cells and 148 variables requires 11026 in Stata MP/SE and 39 variables in Stata/IC.

2) Your exportation failed
Do export in xls instead of csv.
Instead of typing esttab using "D:\test\test_correlation.csv", not unstack compress noobs
Type esttab using corrtrial.xls, not unstack compress noobs
Then in the Excel file, you select the entire first column and you separate what's inside by space.



Damien

[Arnoud Blaakmeer]

Dear Damien,

Thanks for your answer, i still didn't find the answer on the above question but i find a way through it by transforming my variables into rank variables and then use the correlate command i once used.

Thanks for you reply anyway,

Arnoud