I don't have an answer for Mr Ghulam, but perhaps he's thinking of getting
data into Excel from within the Microsoft program. I know people who use
Excel to query databases for example and have the cells linked to graphs, so
whenever they update the query the values are automatically reflected in the
graphs. I think what he's looking for is the possibility of invoking stata
from Excel, having it process a do-file using data within the Excel sheet,
and then having that summarized data appear within the Excel sheet. I have
no clue whether Excel is even capable of interacting with a shell OS in that
way. It uses ODBC to pass information to and from databases though, and
Stata is ODBC capable, so perhaps there's some synergistic potential there.
-----Original Message-----
From: [email protected]
[mailto:[email protected]] On Behalf Of Friedrich Huebler
Sent: Thursday, November 04, 2004 1:54 PM
To: [email protected]
Subject: st: Re: Stata and Excel
Yaseen,
Your message implies that you have Stat/Transfer. In your do-file,
you can save the results as a Stata data file and then convert this
file with -stcmd- to an Excel file. This file could then be linked to
your other Excel files.
save results.dta, replace
stcmd stata results.dta excel results.xls /y
Friedrich Huebler
--- Yaseen Ghulam <[email protected]> wrote:
> Dear Stata users,
>
> Is there anyway of linking stata and MS Excel? I mean we run the
> model from our
> do files, do the predictions and other calculations and excel get
> the predicted
> values direcly from Stata. Our objective is to present these
> coefficents and
> predicted values in excel pivot tables. One way may be creating log
> files or
> coping and pasting or using stat transfer, but we are interested
> that excel should
> get the values in a way as it gets values from other sheets or
> excel file.
>
> Yaseen Ghulam
> Lecturer Banking and Finance
> University of Portsmouth
> Economics Department
> U.K.
__________________________________
Do you Yahoo!?
Check out the new Yahoo! Front Page.
www.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/
