Hello Everyone,
I am using Stata 14.2/IC and running a factor analysis with the same variables from 15 cycles of data collection. I know that the user written program
by Ben Jenn (available at ssc) has the capacity to output results from factor analysis in several different formats. However I haven't been able to find examples of how to output results from several factor analysis into EXCEL sheets.
I have the following loop to conduct the factor analysis
and I am trying to use the following code to output the results in EXCEL
However, this code only outputs the results of one data collection cycle, and I want the results of every data collection cycle outputted in different sheets of the same EXCEL document.
Do you folks have any recommendations on where I can find an example code as a guide?
Thank you
Patrick
I am using Stata 14.2/IC and running a factor analysis with the same variables from 15 cycles of data collection. I know that the user written program
estout
I have the following loop to conduct the factor analysis
Code:
levelsof Cycle, local(Cycles) foreach Cycle of local Cycles { factor m1r m13r m16r m19r m23r m2r m7r /// m11r m18r m22r m26r m29r m3r m4r m8r m9r m12r m14r m25r m5r m10r m17r m20r /// m24r m27r m6r m15r m21r m28r m30r if Cycle == "`Cycle'",factors(5) }
and I am trying to use the following code to output the results in EXCEL
Code:
esttab using "excel.csv", /// cells("L[Factor1](t) L[Factor2](t) L[Factor3](t) L[Factor4](t) L[Factor5](t) Psi[Uniqueness]") /// nogap noobs nonumber nomtitle
Do you folks have any recommendations on where I can find an example code as a guide?
Thank you
Patrick
Comment