I am estimating the alpha of several variables. I have specified asis, item, and label.
I need to be able to export r(ItemTestCorr), r(Alpha), and the labels. However, I can't find a way to export the labels. The matrix of r(ItemTestCorr) and r(Alpha) exports perfectly, but the labels do not. In this case, you know how labels are stored in matrices. I need your kind help to understand what I may be doing wrong. I share the code and the results. Thanks for your help!!
** Estimate the Cronbach's alpha for each item
alpha lit_a2_s lit_a4 lit_b2 lit_c1 lit_c2 mth_a6 mth_a7 mth_c4 mth_c5 mth_e9 mth_f1 emo_c16 emo_c4 emo_c5 emo_c6 emo_c9 soc_c2 soc_e2 soc_x1 soc_x3, asis item label
** Export the result of estimation in the Sheet called "Reliability"
putexcel set "$tables", sheet("Reliability") modify
** Indicate in the Excel file the name of each hypothesis test corresponds
putexcel A5 =("Score") B5=("Item-test correlation") C5=("Alpha"), bold border("bottom", "medium", "black")
putexcel A26 =("Test scale"), bold
** Save the name of matrix output
matrix itemcorr = (r(ItemTestCorr))'
matrix itemalpha = (r(Alpha))'
putexcel B6 = matrix(itemcorr)
putexcel C6 = matrix(itemalpha)
putexcel C26 = (r(alpha)), bold
Related Posts with Export labels from alpha output to Excel
Creating relative scale for two different variables for comparisonHi All, I am creating an index which investigates associations between ecological footprint (EF) an…
True discard of precision with roundHi all, I'm using Stata 14 and wish to round data in one of my variables to 1 dp. I shall be retaini…
esttab producing wrong estimates for imputed marginsHi, Im trying to use esttab to export my margins in some imputed data and while the estimates on the…
Creating dummy variable to indicate if trend increasing or decreasingHello! I am working on a panel dataset. I want to create a dummy variable that indicates weither m…
Year fixed effectsHi all, I am seeking for explanation on year fixed effects, why one would need them as a control in…
Subscribe to:
Post Comments (Atom)
0 Response to Export labels from alpha output to Excel
Post a Comment