Dear Statalists, I have a problem since I am calculating the Shannon entropy for a very huge number of cells of a grid, but when I try to export the values for each cell all in an excel file I only get the values of the last cell.
Please, find my code here:
global geo "A1 A2 A3 A....."
foreach var of global geo {
entropyetc `var'
}
I tried many options to print all my results for example adding these lines:
matrix list r(entropyetc)
putexcel A1=matrix(r(entropyetc))

and I have also played with the results export function in the main menu. But I always obtain the last line of my results including Shannon exp_H Simpson rec_lambda and dissim for the last cell. Can you please help me?
Many thanks.