How to export a vector to excel ?
Posted: Thu Dec 16, 2010 2:21 am
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!
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!