multiple dependent variables

[gregjackson05]

Got any suggestions on exporting results into excel, just interested in coefficients.

Thanks Greg

[EViews Gareth]

Put them into a matrix, then save the matrix to disk as a csv file. The programming guide has examples.

[gregjackson05]

Hi Gareth,
Haven't quite cracked that exporting program.
Is there no way to export mass equation results with the eview tabs. I thought OPEN - AS MODEL might be an option???
You will have worked out I'm no computer programmer and unless I read a specific example relating to my problem I struggle.

Any hints appreciated
Greg

[EViews Gareth]

As I said above, put them into a matrix. Then write the matrix to disk as a csv or xls. Something like:

Code: Select all

matrix(4,8) coefs '4 = no. of rows (equal to number of regressors), 8=number of dependent variables !colcounter = 1 'this will keep track of how many columns of the matrix we've filled for %dep dep1 dep2 dep3 dep4 equation eq{%dep}.ls {%dep} c x1 x2 x3 colplace(coefs, eq{%dep}.@coefs, !colcounter) !colcounter = !colcounter + 1 next for %dep dep100 dep101 dep102 dep103 equation eq{%dep}.ls {%dep} c x1 x2 x3 colplace(coefs, eq{%dep}.@coefs, !colcounter) !colcounter = !colcounter + 1 next coefs.write(t=xls) "c:\temp\myfile.xls"

[gregjackson05]

THANKYOU