# RE: st: RE: Summary statistics table problem

 From "Martin Weiss" To Subject RE: st: RE: Summary statistics table problem Date Tue, 28 Oct 2008 13:08:54 +0100

```Ok. Quick and dirty then:

**********
sysuse auto, clear
collapse (mean) mpg price, by(rep78)
xpose,clear
l, noo
**********

HTH
Martin

-----Original Message-----
From: owner-statalist@hsphsun2.harvard.edu
[mailto:owner-statalist@hsphsun2.harvard.edu] On Behalf Of George Hoffman
Sent: Tuesday, October 28, 2008 12:58 PM
To: statalist@hsphsun2.harvard.edu
Subject: Re: st: RE: Summary statistics table problem

Martin -
thanks, but not quite.
Tabstat var1 var2 ... Varn, stat(mean) by(byvar) either:
col(var): yields columns of the var1, var2, with the by(byvar) as rows
Col(stat): yields sequential single columns of output for each var1..varn

I'm looking for the by(byvar) to appear in columns side by side, with rows
for var1...varn

george

On 10/28/08 3:13 AM, "Martin Weiss" <martin.weiss1@gmx.de> wrote:

> -tabstat var1 var2, statistics( mean ) by(Hour6) nototal
columns(variables)-
> ?
>
>
> HTH
> Martin
>
> -----Original Message-----
> From: owner-statalist@hsphsun2.harvard.edu
> [mailto:owner-statalist@hsphsun2.harvard.edu] On Behalf Of George Hoffman
> Sent: Tuesday, October 28, 2008 4:18 AM
> To: statalist@hsphsun2.harvard.edu
> Subject: st: Summary statistics table problem
>
> This should be simple, but I can't find a straightforward way to do this.
> Xt  dataset, with hours 1-48 for time, also summarized by hour6 (1-6,
> 7-12,...)
> Many row variables.
>
> I want a table of means by hour6:
>
> Var         Hour6
>             1       2       3       4       5       6       7       8
> var1        50      55      55      57      60      62      61      57
> var2        47      34      23      12      6       5       7       6
> Etc
>
> ?? Thank you,
> George hoffman
>
>
> *
> *   For searches and help try:
> *   http://www.stata.com/help.cgi?search
> *   http://www.stata.com/support/statalist/faq
> *   http://www.ats.ucla.edu/stat/stata/
>
> *
> *   For searches and help try:
> *   http://www.stata.com/help.cgi?search
> *   http://www.stata.com/support/statalist/faq
> *   http://www.ats.ucla.edu/stat/stata/

*
*   For searches and help try:
*   http://www.stata.com/help.cgi?search
*   http://www.stata.com/support/statalist/faq
*   http://www.ats.ucla.edu/stat/stata/

*
*   For searches and help try:
*   http://www.stata.com/help.cgi?search
*   http://www.stata.com/support/statalist/faq
*   http://www.ats.ucla.edu/stat/stata/
```