Page 2 of 2
Re: multiple dependent variables
Posted: Tue Apr 26, 2011 5:33 pm
by gregjackson05
Got any suggestions on exporting results into excel, just interested in coefficients.
Thanks Greg
multiple dependent variables
Posted: Tue Apr 26, 2011 5:57 pm
by EViews Gareth
Put them into a matrix, then save the matrix to disk as a csv file. The programming guide has examples.
Re: multiple dependent variables
Posted: Wed Apr 27, 2011 2:07 pm
by 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
Re: multiple dependent variables
Posted: Wed Apr 27, 2011 2:14 pm
by 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"
Re: multiple dependent variables
Posted: Wed Apr 27, 2011 7:18 pm
by gregjackson05
THANKYOU