Re: st: RE: Table with medians of a variable with many categoricalvariables

 From Jeph Herrin To statalist@hsphsun2.harvard.edu Subject Re: st: RE: Table with medians of a variable with many categoricalvariables Date Thu, 15 Mar 2007 16:48:43 -0400

```I don't think "quick question" deserves quite this
much discredit. In particular:

1. I would agree with you that just as simple question
may have unsimple answers, quick questions may have
unquick answers; but I don't see why one would
therefore refrain from framing either as what
they are.

2. "quick question" doesn't indicate to me either
triviality (see 1 above) or apology.

cheers,
Jeph

Nick Cox wrote:
```
Never say "I have a quick question".
1. If the question's quick, the answer may not be!

2. If you think your question is trivial, then don't ask it. If you think your question is interesting, it needs no
apology.
Nick n.j.cox@durham.ac.uk
Mehmet Eris

```I have a quick question about tables in Stata. I want to have table of
medians for one variable, say income,  for a bunch of categorical
variables, say household head's sex, educational level etc.

Table would something like the following:
=========================
median of income
========================
Sex:
Male
Female

Educational level:
Secondary
Vocational

.
.
.
.
====================

table A, c(median X) is sort of what I am looking for. It gives the
median of the variable X for each category in A. But this one
works for only one variable.  I don't want to do it one by one for
each row categorical variable. It will be really tedious as I have to
do it for so many times.

Is there any tricks or commands that I can use to achieve what I want
to do?  I also want to be able to export the table I get to Excel,
BTW.

Thanks so very much in advance!
*
*   For searches and help try:
*   http://www.stata.com/support/faqs/res/findit.html
*   http://www.stata.com/support/statalist/faq
*   http://www.ats.ucla.edu/stat/stata/

```
```*
*   For searches and help try:
*   http://www.stata.com/support/faqs/res/findit.html
*   http://www.stata.com/support/statalist/faq
*   http://www.ats.ucla.edu/stat/stata/

```
```*
*   For searches and help try:
*   http://www.stata.com/support/faqs/res/findit.html
*   http://www.stata.com/support/statalist/faq
*   http://www.ats.ucla.edu/stat/stata/
```