exportin equation to excell

[huseyinky]

Dear all,

Is it possible to export several equations to excell?

[EViews Gareth]

You're going to have to explain what on earth you mean by that....

[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.

[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.

[huseyinky]

Thank you Gareth

Is there any example for this type of program? May be I can modify it.

[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



[huseyinky]

Thank you very much Gareth