Along David idea, whenever I work in a project with non-stata users and I
need to provide them with a lot of tables that might need corrections along
the way. I write a program that produces stata datasets with the statistics
I need, then export them in ASCII tab separated files (readable with excel)
and then present them in nice tables generated with excel which are linked
to the original files generated by Stata. Going from excel to word is
straightforward.
If you detect mistakes, the program can be modified easily, while your nice
tables in excel will change automatically when you generate the new raw
data. This procedure is particularly efficient to generate tables when you
have tables with similar structures. You "program" only once in excel and
then copy in other pages or files.
I began doing this many, many years ago with SPSS for DOS.
Marcela
----- Original Message -----
From: "David Kantor" <[email protected]>
To: <[email protected]>
Sent: Wednesday, October 20, 2004 10:51 AM
Subject: Re: st: STATA Wish List
> At 11:14 AM 10/20/2004 +0100, Stephen Kay wrote:
> >[...]
> >
> >* Ability to quickly copy over selected output straight to
Microsoft
> >Word which looks as good as it does in the output window. I know you can
> >achieve this by running STATA's "translate" command but a quicker way
would
> >be preferred. A two way output screen similar in appearence to SPSS's
that
> >allows users to effortlessly copy over selected output to Word would be
> >ideal (but I think that's asking a bit much).
> >[...]
> > Unfortunately in my commercial environment I'm
> >often called upon to produce lots of mind numbing contingency tables and
it
> >is solely in this regard that SPSS has the advantage.
> >[...]
>
> If I had a need to mass-produce such tables, I would look into the
> possibility of having an automated process that would create the distilled
> datasets in Stata, translate them to SPSS (using Stat/Transfer or a
similar
> product), and launch SPSS to use that dataset and do whatever it needs to
> do to it.
>
> You might spend a whole day making that work, if it is indeed possible,
but
> it would be worthwhile if you succeed.
>
> --David
>
> David Kantor
> Institute for Policy Studies
> Johns Hopkins University
> [email protected]
> 410-516-5404
>
> *
> * 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/
