Statalist


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: st: AW: simple question on two-way table


From   Austin Nichols <austinnichols@gmail.com>
To   statalist@hsphsun2.harvard.edu
Subject   Re: st: AW: simple question on two-way table
Date   Tue, 17 Feb 2009 12:09:23 -0500

Shehzad Ali <sia500@york.ac.uk>:
ssc inst tabstatmat
ssc inst xml_tab
bysort week: tabstat A B C D E F G H I J, stat(mean sd median min max)
col(stat) save
tabstatmat a
mat A=a'
xml_tab A, save(a.xls) replace

On Tue, Feb 17, 2009 at 8:11 AM, Shehzad Ali <sia500@york.ac.uk> wrote:
> Thanks, Martin. I tried:
>
> bysort week: tabstat A B C D E F G H I J, stat(mean sd median min max)
> col(stat)
>
> I get the summary which is presented for each week. Is there a way to export
> this into Excel so the summary stats for each week appear next to each other
> instead of how Stata shows it (as separate tables)?
>
> Apologies for posting twice. I thought the first post didnt go.
>
> Thanks,
> Shehzad
>
> On Feb 17 2009, Martin Weiss wrote:
>
>>
>> <>
>>
>> Look at -table- or -tabstat- with the -by- prefix or an appropriate -if-
>> qualifier...
>>
>>
>>
>> HTH
>> Martin
>>
>> -----Ursprüngliche Nachricht-----
>> Von: owner-statalist@hsphsun2.harvard.edu
>> [mailto:owner-statalist@hsphsun2.harvard.edu] Im Auftrag von Shehzad Ali
>> Gesendet: Dienstag, 17. Februar 2009 13:27
>> An: statalist@hsphsun2.harvard.edu
>> Betreff: st: simple question on two-way table
>>
>> Hi,
>>
>> I have a simple question about tabulation of summary statistics.
>>
>> I want a table with summary statistics (mean, median, SD, minimum and
>> maximum) for 5 time points for 10 variables. The columns should show time
>> points (10 weeks, 20 weeks, 30 weeks, 40 weeks, 50, weeks) and rows should
>> reflect the variables (A through J). Each column should be sub-divided into
>> 5 sub-columns for each of the summary statistic. I want the table to look
>> like this (not sure if this will copy well in the email).

*
*   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/



© Copyright 1996–2014 StataCorp LP   |   Terms of use   |   Privacy   |   Contact us   |   What's new   |   Site index