Page 1 of 1
exportin equation to excell
Posted: Tue Apr 21, 2009 10:10 am
by huseyinky
Dear all,
Is it possible to export several equations to excell?
Re: exportin equation to excell
Posted: Tue Apr 21, 2009 10:17 am
by EViews Gareth
You're going to have to explain what on earth you mean by that....
Re: exportin equation to excell
Posted: Tue Apr 21, 2009 10:32 am
by huseyinky
For example I run several regression and save them as eq1, eq2 etc (about 100 equations) . I want to export thesee quation results to excell. Otherwise I have to open equations by one by and copy coefficietns and test statistics then paste on excell.
Re: exportin equation to excell
Posted: Tue Apr 21, 2009 10:34 am
by EViews Gareth
Best way is to write a program that loops through each of your equations, freezing the results into a table then writing the table to disk as a csv file.
Re: exportin equation to excell
Posted: Tue Apr 21, 2009 10:38 am
by huseyinky
Thank you Gareth
Is there any example for this type of program? May be I can modify it.
Re: exportin equation to excell
Posted: Tue Apr 21, 2009 10:49 am
by EViews Gareth
Code: Select all
create u 100
series y=nrnd
series x1=nrnd
series x2=nrnd
equation e1.ls y c x1
equation e2.ls y c x2
for %eqname e1 e2
freeze(mytab) {%eqname}.stats
%name = "c:\temp\" + %eqname + "_table"
mytab.save %name
d mytab
next
Re: exportin equation to excell
Posted: Tue Apr 21, 2009 11:06 am
by huseyinky
Thank you very much Gareth