asdocx: Export from Stata to Word, Excel, LaTeX & HTML › Forums › asdocx Forum › Export output from factor command in Stata to Excel › Reply To: Export output from factor command in Stata to Excel
Adding support for factor will take some time. However, you can quickly export the tables of factor command using the wmat command of asdocx, that is writing matrix. See this example.
* Load example data webuse bg2, clear * Run the factor command factor bg2cost1-bg2cost6 * Save the matrix in L mat L = e(L) * Export the matrix with asdocx using wmat command asdocx wmat, mat(L) replace title(Factor loadings (pattern matrix)
Factor loadings (pattern matrix) and unique variances
| Factor1 | Factor2 | Factor3 | |
|---|---|---|---|
| bg2cost1 | 0.247 | 0.367 | -0.045 |
| bg2cost2 | -0.337 | 0.332 | -0.077 |
| bg2cost3 | -0.376 | 0.376 | 0.02 |
| bg2cost4 | -0.322 | 0.194 | 0.103 |
| bg2cost5 | 0.455 | 0.248 | 0.064 |
| bg2cost6 | 0.476 | 0.236 | -0.007 |