Stata The Stata listserver
[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]

st: Re: how to get tables into publishable format


From   "Christopher W. Ryan" <cryan@binghamton.edu>
To   <statalist@hsphsun2.harvard.edu>
Subject   st: Re: how to get tables into publishable format
Date   Sun, 2 Feb 2003 19:09:52 -0500

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
cryan@binghamton.edu


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: owner-statalist@hsphsun2.harvard.edu
>[mailto:owner-statalist@hsphsun2.harvard.edu]On Behalf Of Philip Ryan
>Sent: Sunday, 2 February 2003 21:43
>To: statalist@hsphsun2.harvard.edu
>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
>
>philip.ryan@adelaide.edu.au
>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/



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