You are using the word "macro" in a non-Stata
sense here, but I guess we all know that.
I didn't grasp why you need to create tables
and graphs in Excel.
As far as the Stata calculation is concerned,
in broad terms your approach sounds a very indirect way
to do it. If you say more about your data structure,
someone can probably suggest a more direct approach.
Nick
[email protected]
Shafer, Marek
> I often need to create tables and graphs in Excel which look
> at labour trends over time, using many different datasets.
> If, for example, I wanted to look at the change in the
> employment rate of 18-21 year olds over a 15 year period, I
> would normally create a macro to tabulate 15 times, then
> manually read off the results from the log and input them
> into Excel. Is there a way that Stata can remove these
> results from each of the tabulations as it loops through the
> do file, leaving me with a single neat table at the end?
*
* 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/
