Hi, I'm having a hard time trying to export three different tabstats to three different excel sheets using a loop so at the end I get sheet (indicador s_i) with the matrix results from local s_i... and finally the one with local w. The code actually estimates the tables correctly, however, the sheets get overwritten and in the end I only get the last tabstat on the three sheets. What should I do?
*Tablas de media y desviacion estandar de los indicadores 1996 y 2010
use indices_1996-2010
foreach a in s_i i w {
putexcel set indicadores_practica.xls, sheet(indicador `a') modify
local s_i "ind1_96_3 ind2_96_2 ind3_96_8 ind4_96_7 ind4_96_17 ind5_96_4"
local i "ind1_96_3_i ind2_96_2_i ind3_96_8_i ind4_96_7_i ind4_96_17_i ind5_96_4_i"
local w "ind1_96_3_w ind2_96_2_w ind3_96_8_w ind4_96_13_w ind4_96_17_w ind5_96_4_w"
foreach n in "`s_i'" "`i'" "`w'" {
tabstat `n', stat(mean sd) save
matlist r(StatTotal)
matrix results = r(StatTotal)'
matlist results
putexcel A1=matrix(results), names nformat(number_d2)
}
}
Related Posts with How can I export different tables to excel using different sheets?
Weighting data with AIPW and teffectsHello everyone, Actually, I try to understand how to use an IPW estimator. I have 11 treatments var…
Unexpected error from XTPMG outputHi dear all. I am having an unexpected error message from xtpmg output. I am using Stata 16 for Mac…
calculating or identifying start/stop dates according to a rule with consecutive observationsHi, this is a snap shot of my data set. Code: Code: * Example generated by -dataex-. To install:…
Pooled panel Heckman MLE vs. pooled panel Heckman Two-stepDear Statalist, I am running a pooled panel Heckman two-step estimation to find determinants of ins…
Taking Average by idHi Everyone, I have a dataset looking like this: Date id var1 var2 var3 var4... 2010 1 ... ... ... …
Subscribe to:
Post Comments (Atom)
0 Response to How can I export different tables to excel using different sheets?
Post a Comment