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!
Related Posts with Tab2xl issues
generate random number using loopforv i = 1/10{ if mod(`i',2)==0 gen z`i' = rnormal() if mod(`i',2)==1 gen z`i' = runiform() } i want…
adding multiple tables to an existing sheet in excel or buliding two/three way table?Hello, I'm trying to build three tables (each one for a country based on var country_id) in excel. …
rdbwselect "mass points detected in running variable" errorHello, I am having some problems with the rdbwselect command. I have been running rdbwselect dummy a…
xtgee with IPWHi. I am looking at the effect of non-employer based health insurance on self-employment on panel da…
How to export difference-in-differences table from Stata to Latex?I'm trying to export the results from a difference-in-differences from Stata to Latex. I tried the f…
Subscribe to:
Post Comments (Atom)
0 Response to Tab2xl issues
Post a Comment