Page 1 of 1

How to export a vector to excel ?

Posted: Thu Dec 16, 2010 2:21 am
by Rosa.hh
Dear all,

I am using Eviews 7 and a panel database of 13 countries for the period 1990q1-2009q2. How do I export a vectoR to excel? My final goal is to create a table but I dont know if it is possible to create a table with several vectors in Eviews.

I tried converting a vector into a matrix so that I could later on export the matrix to excel; here is the program but the data of the vector is being changed (numbers are different than originals) which is something I want to avoid.

Any idea of how should I export a vector to excel? I enclose the database.

Thank you a lot!

'transform vector into matrix:

vector rmr_lags1= @mrnd(29)
matrix rmr1= @unvec(rmr_lags1,29)

vector rmr_lags2= @mrnd(29)
matrix rmr2= @unvec(rmr_lags2,29)

vector rmr_lags4= @mrnd(29)
matrix rmr4= @unvec(rmr_lags4,29)

smpl @all
series rmrl1_series
mtos(rmr1, rmrl1_series)

ps: I've been visiting the forum a lot this week as I am new to Eviews and need to work with it, great forum!

Re: How to export a vector to excel ?

Posted: Thu Dec 16, 2010 5:02 am
by Rosa.hh
I found out how to do it. Here are the codes

'transforms vector into matrix:
matrix rmrl1= rmr_lags1

'transform matrix into series:
series rmrl1_series
group rmrl1_s
mtos(rmrl1, rmrl1_series )

Re: How to export a vector to excel ?

Posted: Thu Dec 16, 2010 9:25 am
by EViews Glenn
I'm not sure if I"m misunderstanding the original question, but if you want to write a vector object to an Excel spreadsheet, you can use the just use the write command as in...

Code: Select all

vector rmr_lags1 = @mrnd(29) rmr_lags1.write(t=xls) rmr_lags1.xls