Hello everyone,

I've just come across tab2xl and have been trying to include it in a loop to get a two-way tab for my variables as follows:

foreach var of global catmyco {
tab2xl `var' totalmyco using test1, row (1) col (1) missing sheet ("testsheet1")
}

However, it's only giving me an excel sheet for the last variable in the global catmyco. The append option is not allowed.
Does anyone know of a way to get everything in a single sheet?

p.s: Tabout works, but it just seems like tab2xl would be an easier option.

foreach var of global catmyco {
tabout `var' totalmyco using bivar.xls, c(freq col) mi append
}


Thank you!