Buzz,
I also find Stata graphs way superior to the Excel ones, although it
takes some time to learn how to generate exactly what you want.
If you have tables in Excel that you want to translate into Latex
there are several utilities that can help you. I refer you to this
webpage which I found very instructive when i was learning about this
stuff.
http://www.sifr.org/latex-guide.html
Good luck,
robert
On 2/15/06, Friedrich Huebler <[email protected]> wrote:
> Buzz,
>
> Why do you need Excel when you can make tables and graphs with Stata?
> Michael Blasnik describes how to use Stata and MS Word to generate
> the kind of report you seem to work on. For your information I
> include the abstract of his presentation at last year's Stata Users
> Group meeting in Boston.
>
> Friedrich Huebler
>
>
> Mass producing appendices using Stata and word processor mail merge
> http://www.stata.com/meeting/4nasug/mblasniknasug.ppt
> http://www.stata.com/meeting/4nasug/abstracts.html
>
> Abstract: Confronted with the task of producing a large appendix to a
> report that involved a page of tables and 3 graphs for each of 186
> panels, the author discovered an approach to automate this process
> using Stata combined with the mail-merge facilities of a word
> processor. A Stata do-file produces all 558 graphs and writes an
> ASCII file of data that also includes the graph file names for each
> panel. A one-page mail-merge document is set up in the word
> processor, and the Stata output is used as the data source to
> automatically create the entire 186-page appendix with all tables and
> graphs placed as desired. This session will outline how to employ
> this approach for such otherwise daunting tasks.
>
>
> --- Winfield Scott Burhans <[email protected]> wrote:
> > Roger, my hope is to use LaTex for a report set that is currently
> > generated from a series of Stata *.do files which create *.csv
> > files which
> > are then used as external data sources that automatically refresh
> > multiple
> > data ranges in Excel, which then are used in both tables and
> > graphics
> > generated from that data. The Excel file is printed and then
> > refreshed
> > with a new run of Stata. Currently this involves invoking Stata,
> > then the
> > Excel file, and then manually refreshing the Excel file after each
> > run
> > through the Stata *.do files. What drove me to Excel originally
> > was that
> > I needed the graphics in the report I printed, and I couldn't
> > figure out
> > an easy way to refresh the graphics in the report (this was created
> > several years ago). I assume I can do this in LaTex.
>
>
> __________________________________________________
> Do You Yahoo!?
> Tired of spam? Yahoo! Mail has the best spam protection around
> http://mail.yahoo.com
> *
> * 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/
