 |
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: st: AW: simple question on two-way table
Thank you, Martin, Neil and Austin. All the suggestions were very helpful.
Here are quick follow-up questions for Austin:
1. Following the -tabstatmat- code, -xml_tab A, save(a.xls) replace- gives
me the following error:
-file can not be saved at this location-
Looking at the help file for xml_tab, it suggests closing Excel files but I
don't have any open.
2. When I tried:
bysort week: tabstat A B C D E F G H I J, stat(mean sd median min max)
col(stat) save
tabstatmat a
I get the following error: - no tabstat results in memory-
Instead if I tried:
tabstat A B C D E F G H I J, stat(mean sd median min max) col(stat)
by(week) save
tabstatmat a
It worked. I don't why.
Can you help here please?
Thank you,
Shehzad
On Feb 17 2009, Austin Nichols wrote:
Shehzad Ali <[email protected]>:
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'
On Tue, Feb 17, 2009 at 8:11 AM, Shehzad Ali <[email protected]> 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: [email protected]
[mailto:[email protected]] Im Auftrag von Shehzad Ali
Gesendet: Dienstag, 17. Februar 2009 13:27
An: [email protected]
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/
--
Shehzad I Ali
Department of Social Policy & Social Work
University of York
YO10 5NG
+44 (0) 773-813-0094
*
* 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/