Victoria,
The approach in
http://www.stata.com/statalist/archive/2006-09/msg00837.html
ends with a -type- command to echo the contents of a text file to the
screen. If instead you end with something like
local excel="C:\Program Files\MSOffice\Office\Excel.exe"
winexec "`excel'" /out.txt
the file will be opened by Excel instead (see also -help shell-).
Many people seem to like -tabstat- (official Stata) combined with
-tabstatmat- (SSC) and -xml_tab- (SSC) for these kinds of tasks as
well; I could not possibly comment, as I do not use that approach.
On Dec 17, 2007 3:35 PM, Victoria wrote:
> Hi Austin,
> I have a similar issue to resolve,
> I tried your suggestion with
>
> http://www.stata.com/statalist/archive/2006-09/msg00837.html
>
> and succeeded in following the analogy with my data.
>
> What I obtain, however is text on the screen, and ideally I would like a
> table in Excel.
>
> Is there a solution to this?
>
> Thanks, Victoria
*
* 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/