I am trying to export a matrix from a stored result after running a PCA (https://www.stata.com/manuals/mvpca.pdf) and subsequently a screeplot (https://www.stata.com/manuals/mvscreeplot.pdf), with the PCA producing e-class results while screeplot produces r-class results.
My complication starts when I try to export a matrix of confidence intervals named r(ci), whilst it is also a name for the macro r(ci). Every time I want to use putexcel, it always returned a "type mismatch" error. The matrix r(ci) also returns only when I am using "matrix list" and not "matlist".
Is the only way to export it is to copy-paste it manually?
My complication starts when I try to export a matrix of confidence intervals named r(ci), whilst it is also a name for the macro r(ci). Every time I want to use putexcel, it always returned a "type mismatch" error. The matrix r(ci) also returns only when I am using "matrix list" and not "matlist".
Is the only way to export it is to copy-paste it manually?
Comment