st: Re: tabstat: values in columns instead of rows?

["Hendro Hendratno" <hendratno@dnet.net.id>]

Jan,

This is my ado file that used to create multiple variables in the row of 
table. It's simillar with collapse command but the result with appear in the 
screen rather than change the data.

Bests,

Hendro

----- Original Message ----- 
From: "Sauermann, Jan" <Jan.Sauermann@iwh-halle.de>
To: <statalist@hsphsun2.harvard.edu>
Sent: Wednesday, April 12, 2006 4:56 PM
Subject: st: tabstat: values in columns instead of rows?



> Dear Statalist-Users,
>
> I want to create a cross-table in the following form:
>
>        | VAR1 == 0                  | VAR1 == 1                  | Total
> --------+----------------------------+----------------------------|-------------
> X_1     | mean of X_1 (if VAR1 == 0) | mean of X_1 (if VAR1 == 1) | mean 
> of X_1
> X_2     | mean of X_2                | mean of X_2                | mean 
> of X_2
>  .     |    .                       |    .                       |   .
>  .     |    .                       |    .                       |   .
>  .     |    .                       |    .                       |   .
>  .     |    .                       |    .                       |   .
>  .     |    .                       |    .                       |   .
> X_N     | mean of X_N                | mean of X_N                | mean 
> of X_N
> ------------------------------------------------------------------|-------------
>
> where all variables (VAR1, X_1 ... X_N) are binary. A similar result could 
> be achieved by
>
> tabstat X_1 X_2 ... X_N, by(VAR1)
>
> with the result:
>
> Summary statistics: mean
>  by categories of: VAR1
>
>    VAR1 |     X_1     X_2       X_3        X_4
> ---------+----------------------------------------
>       0 |  .1119746  .8359621  .2555634  .5063582
>       1 |  .0486352  .6175836  .1630881  .5350927
> ---------+----------------------------------------
>   Total |  .0530139  .6494703   .169481  .5331062
> --------------------------------------------------
>
>
> However, we would like to have this table with columns "VAR1 == 0" and 
> "VAR1 == 1", analogue to the example above.
>
>
> Kind regards, Jan
>
>
>
>
> --
>
> ---------------------------------------
> Jan Sauermann
>
> Halle Institute for Economic Research (IWH)
>
> Kleine Maerkerstrasse 8 | phone: +49 345 7753-855
> D - 06108 Halle (Saale) | fax:   +49 345 7753-799
> http://www.iwh-halle.de | mail:  jsa@iwh-halle.de
>
>
> *
> *   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/

Attachment: tabcollps.hlp
Description: Binary data

Attachment: tabcollps.ado
Description: Binary data