Nick/Lee
Thanks for your comments. I certainly understand and appreciate Stata Corp's
position. In that regard, I would like a generic solution similar to the one
you (Nick) mentioned, a while back, using , perhaps, something
like -matcell()- ( "The -matcell()- option of -tabulate- has matrix result."
Nick ). That way, I could export the table data into a standard ascii tab
delim file and import it into almost anything. My problem is that I needed
to use 'table' (for pweights/ 3 way tables, etc.) as opposed to tabulate. I
don't see an option in 'table' that will export the data into an ascii file.
Re Lee's comments: I am using the solution Lee suggested and it works
fine....just involves more steps. As Lee correctly surmized, I was trying to
use the table routine in (shhh....ms word) and I did not know about the
shortcoming Lee mentioned. Thanks Lee, very helpful.
Bottom line: I can live with the 'copy table' solution, it works. But if
there is a "simple, direct" way to get table output data from the 'table'
command into an ascii tab delim file, I would sure like to know it.
Wendell Joice
-----------------------------------------
I don't think so (I haven't read the entire manual).
For what it's worth, it is perhaps pertinent to
emphasise, especially for relatively new list members
not accustomed to the usual outbursts of prejudices
here from long-active members, myself included:
1. As a point of principle, Stata Corp is cross-platform
and in general aims to produce tools valid across
operating systems and independent of other software
which users may or may not have access to (or use).
There have been, and will continue to be, exceptions
to that, including the recent introduction of ODBC
functionality, but it's a strong Stata principle nevertheless.
2. In practice, Stata Corp developers mostly do not
use Microsoft software in a non-trivial way,
except for the purposes of
producing an executable which will run under Windows.
And a large fraction of official Stata innovation
is driven by an academic model of the developers
working on their own best ideas (in fact, Stata Corp is
more like the academy than much of the academy...).
3. In practice, although to a lesser extent, the majority of
the most productive user-programmers seem to behave
similarly, never use Word, Excel, etc., and would
have no interest in writing tools for interacting with
them -- in some cases even strong moral or technical
objections to the notion.
Nevertheless, it is, I guess, true that
4. One of the largest single groups of Stata users would use
as their other software (probably) their mailer, MS
Word and MS Excel.
But that's as may be. A more positive comment is what --
precisely -- do you need, want, expect?
Nick
[email protected]
*
* 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/
----- Original Message -----
From: "Lee Sieswerda" <[email protected]>
To: <[email protected]>
Sent: Friday, January 17, 2003 1:59 PM
Subject: st: RE: New ways to export tables from tabulate, etc.??
> There is already a good way to "export" tabular data. In Stata 7, the
"Copy
> table" option was introduced. It copies a table from the Stata output
screen
> onto the clipboard, intelligently removing the lines and inserting tabs
> between the table cells. In essence, it becomes a table in tab-delimited
> format, which is easily pasted into any spreadsheet. It doesn't work that
> well with Word, but that is because Word (well, Word 97 anyway) uses a
> non-standard table format and doesn't seem to recognize standard
> tab-delimited format. You can't blame Stata for MS Word's shortcomings.
> Regardless, if you really want to get a table from Stata into MS Word, you
> can first go through a spreadsheet.
>
> Lee
>
> Lee Sieswerda, Epidemiologist
> Thunder Bay District Health Unit
> 999 Balmoral Street
> Thunder Bay, Ontario
> Canada P7B 6E7
> Tel: +1 (807) 625-5957
> Fax: +1 (807) 623-2369
> [email protected]
> www.tbdhu.com
>
>
>
>
> > -----Original Message-----
> > From: Wendell Joice [SMTP:[email protected]]
> > Sent: Friday, January 17, 2003 12:56 PM
> > To: [email protected]
> > Subject: st: New ways to export tables from tabulate, etc.??
> >
> > This topic has been discussed before but with the advent of version 8 ,
I
> > was wondering if there is anything new in version 8 or elsewhere that
will
> > facilitate exporting output (tables) from stata commands such as
tabulate,
> > table, etc. to spreadsheets (Excel...) or word processors (Word...). I
am
> > not referring to simply exporting the graphic image of a table but
> > actually
> > exporting the tabular data into the table application of a spreadsheet
or
> > word processor, so that you can edit/manipulate the data in the
> > spreadsheet/processor.
> >
> >
> >
> > *
> > * 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/
> *
> * 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/
>
*
* 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/
