Statalist


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

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


From   Shehzad Ali <sia500@york.ac.uk>
To   statalist@hsphsun2.harvard.edu
Subject   Re: st: AW: simple question on two-way table
Date   17 Feb 2009 13:11:14 +0000

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).


-------------------- Week 10 -------------------- -------------------- Week 20 -------------------- ---.

           Mean Median SD Min Max Mean Median SD Min Max



A

B

C

.

.

.

J


Can you help me with the best way to do this?

Thank you,

Shehzad

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



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