Re: st: Re: XML output

["roy wada" <roywada@hotmail.com>]

At the bottom of document created by -xmlsave- are these lines:

</Worksheet>
</Workbook>

Between them you can insert additional xml sheet using -file- command. You 
can grab it from another document created by -xmlsave- and capture the lines 
between these two lines:

<Worksheet ss:Name="Sheet1">
... the lines here ...
</Worksheet>

Make sure you change "Sheet1" to "Sheet2" when you insert the new lines. In 
the end you should get something like this at the bottom of the merged 
document:

</Worksheet>
<Worksheet ss:Name="Sheet2">
... lines here ...
</Worksheet>
</Workbook>

It shouldn't take too long (if you know what to do). My guess is that 
StataCorp will eventually incorporate multiple-sheet feature into -xmlsave-, 
making this unnecessary.

Roy


Ed Al-Hussainy wrote:

Subject: Re: st: Re: XML output

apologies - i meant OUTREG2

http://econpapers.repec.org/software/bocbocode/s456416.htm

On 12/6/05, Kit Baum <baum@bc.edu> wrote:

> ivreg2 does not have any XML output options. It does have the
> capability to save estimates, internally to Stata.
>
> Kit Baum, Boston College Economics
> http://ideas.repec.org/e/pba1.html
>
>
> On Dec 6, 2005, at 2:33 AM, statalist-digest wrote:
>
> > I'm writing a Stata program that needs to save regression and data
> > output to multiple MS Excel worksheets. Has anyone tweaked the xml
> > output options in IVREG2 or XMLSAVE to enable this sort of thing? If
> > not, does anyone have any recommendations regarding where I should
> > start? Thanks much.

*
*   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/