I've just discovered myself that all of this is true. The trouble with
supercolumns is all the more confusing since frequencies from -table- that
equal zero are just left blank. So after copy and paste, the values in columns
with zero freqs can be shifted incomprehensibly. Specifying the -table- option
"missing" can help a bit.
Furthermore, what if you log your output to a plan-text .log file? I have
found that the tables appear in TextPad with space-separated cells. Copying
and pasting this into a spreadsheet puts whole rows into single cells: another
mess. A .smcl log, viewed in the Sata Viewer, allows "copy table" just like
the Results window does. It would be nice if a .log log file would store the
tables with tab separators.
Thanks for the help.
--Chris
--
Christopher W. Ryan, MD
SUNY Upstate Medical University
Clinical Campus at Binghamton
and Wilson Family Practice Residency
[email protected]
On Mon, 3 Feb 2003 09:17:51 +1030, Stephen McDonald wrote:
>There are further inconsistencies in this command: the columns in
>the output
>tables of regression commands are separated by tabs after using Copy
>Table
>to copy and paste, but not columns from ANOVA tables which are, like
>the
>output of -table-, filled with spaces after the Copy Table command.
>
>Stephen McDonald
>
>-----Original Message-----
>From: [email protected]
>[mailto:[email protected]]On Behalf Of Philip Ryan
>Sent: Sunday, 2 February 2003 21:43
>To: [email protected]
>Subject: st: RE: how to get tables into publishable format
>
>
>Stephen McDonald wrote:
>==================
>You can also cut and paste using Shift-Ctrl-C (or the "copy table"
>function
>in the edit menu) once you have highlighted the table. This will put
>tab-delimited text into a Word document which can then be converted
>using
>relevant command in the "Table" menu of Word (exact command depends
>on which
>version). This works well for getting values across, but I usually
>need to
>"pretty-up" headings etc.
>==================
>
>This is true for 2-way tables such as those produced by -tabulate-.
>But it
>does not work for 3-way tables produced by -table- (that is, tables
>that
>have a "supercolumn" variable defined). On executing a Copy-Table
>command
>and pasting into Word/Excel, the supercolumns are nicely separated
>by tabs,
>but the columns within the supercolumn are separated by spaces. So
>too are
>column totals and supercolumn totals should they be specified. All
>this
>makes a copy into Excel or Word needlessly tedious.
>
>Phil
>
>
>Philip Ryan
>Associate Professor
>Department of Public Health
>Medical School
>University of Adelaide
>Adelaide 5005
>South Australia
>
>tel: +61 8 83033570
>fax: +61 8 82234075
>
>[email protected]
>http://www.public-health.adelaide.edu.au/
*
* 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/
