[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]
st: Re: Stata and Excel
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
--- Yaseen Ghulam <Yaseen.Ghulam@port.ac.uk> 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
Do you Yahoo!?
Check out the new Yahoo! Front Page.
* For searches and help try: