Apologies, I was too quick on the send button, I thought I had read
'contents of the data'. Oops.
A solution might something along the lines of
preserve
tabulate varname1 [varname2], matcell(mymat) ...
svmat mymat
outsheet using mymat.dta
restore
This won't provide you with the column names or row names yet, but might be
possible by using the matcol() and matrow() options at -tabulate ...-. Let
me look further into it.
Patrick Joly
[email protected]
[email protected]
-----Original Message-----
From: Joly, Patrick: IAC
Sent: Friday, September 13, 2002 10:28 AM
To: [email protected]
Subject: st: RE: saving tables in spreadsheet format
outsheet is your friend (the reciprocal of insheet to load comma- or
tab-delimit files). see -help outsheet-. Tab-delimited is the default but
you may specify comma.
Patrick Joly
[email protected]
[email protected]
-----Original Message-----
From: [email protected] [mailto:[email protected]]
Sent: Friday, September 13, 2002 9:45 AM
To: [email protected]
Subject: st: saving tables in spreadsheet format
Hello statlist,
I was wondering if there is a program in Stata to output the content of a
table
into tab or comma separated values (so that it can be open automatically by
Excel or other spreadsheet programs). "outreg" is amazing, but as far as I
know
it only works with regression output. "outtable" is great too, but it only
converts matrices (and only to Tex).
the "Copy table" option works perfectly, but it is not really convenient for
a)
Large tables, b) Large number of tables.
if not available, I could try to write one.
thanks! best,
***************************
Guillermo Cruces
*
* 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/
