I developed an iterative loop to calculate Metaan for a total of 39 studies. I have been trying to export Metaan results (scalars) to excel sheet using and modifying the following code. I am only able to export the very last result and not all the results in the same column. Is there a way I can modify the code to get the result I want?


putexcel set testing.xls, modify

forvalues i = 1/40 {
display `i'
metaan ES SE if Study <`i', dl
return list

putexcel (B2) = rscalars
}