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