Tabout tab with freq and percent

[Rogerio Paris]

Hello everybody,

I need to have excel output of tab commands, but with percentage and frequency.

Lets take an example with this base and 2 categorical variables:

sysuse voter

tab inc

xtile population = pop, nquantiles(2)

When I use tabout, to put this in an excel file, i can only get frequencies OR percentages. But…. I need both.


If i do:

tabout population inc using file.xlsx

> i loose percentage

If i do:

tabout population inc using file.xlsx, percent

> I loose frequency


Do you have an idea on that ?

btw since 3 days i cannot open anymore the excel files created by tabout, but i dont think it will be a major problem.


Thanks you,

[Charlie Joyez]

Personally I don't see the difference between the two codes above, the percent option doesn't work because it doesn't know which percentage to display.
However you could easily have both frequency and percentages with the following line.

tabout population inc using filep.txt, cells(freq col)

Note that the col option will give you the column percentage, and could be replaced by the row option (or could be both displayed.)

Concerning the excel files that can't be opened, I'm afraid this is because tabout is made to produce text (.txt) and not .xls.

Hope this helps.
Charlie

[Oded Mcdossi]

Charlie point exactly to the problem with your code. however, tabout is able to work with MS Excel and to produce xls files but not xlsx files.

 tabout population inc using filep.xls, cells(freq col)

[Rogerio Paris]

Hello,
thank you for your replies, indeed it works with xls and it works with cell(freq col).

I just have a last concern. Tabout cell(freq row) exports freq and row percentage in a different way han tabulate. it's like two merged charts:

Apparently, there is no option,in the tabulate command, to put the freq and col in the same column or in the same cell, which would be very useful. If not I will have to arrange all the charts by hand...

thanks

[Oded Mcdossi]

You are right there is no such option. You may find some helpful examples in the PDF manual: http://www.ianwatson.com.au/stata/tabout_tutorial.pdf

[Rogerio Paris]

hi, thanks for the link. I managed to have interesting results now and I'll continue learning about tabout.

[Kamola Babamuradova]

Hello. Thanks for description of tabout command. Could you also share how to add P-values for characteristics? Beforehand thank you.