Page 1 of 1
combine many individual series into one dataset
Posted: Wed Jan 13, 2021 9:28 pm
by Mai LÊ
I have 45 time-series and I want to combine all of these series into 1 sheet so that I can extract it in excel file.
Could you please advise how to to it? Thanks!
Re: combine many individual series into one dataset
Posted: Wed Jan 13, 2021 9:53 pm
by EViews Gareth
You’ll have to provide more details
Re: combine many individual series into one dataset
Posted: Wed Jan 13, 2021 11:20 pm
by Mai LÊ
In eviews file, I have time series of stock market returns and corresponding short-time interest returns of 45 different countries.
Based on these series, I generate other 45 series.
Now, I would like to combine the series of each country into 1 sheet of data so that I can extract it back in excel 45 series that I newly generated.
Re: combine many individual series into one dataset
Posted: Thu Jan 14, 2021 2:51 am
by EViews Gareth
Are they not already in the same EViews workfile page?
Re: combine many individual series into one dataset
Posted: Thu Jan 14, 2021 3:10 am
by Mai LÊ
They are in the same workfile, but in separated series for each country.
Now I want to combine them in 1 table: columns are country 1, country 2...to country 45; rows are time series data points
Re: combine many individual series into one dataset
Posted: Thu Jan 14, 2021 3:15 am
by Mai LÊ
yes, you are right.
It's in separate pages for each country, and I want to combine all series in one page.
Re: combine many individual series into one dataset
Posted: Thu Jan 14, 2021 7:11 am
by EViews Gareth
You can copy and paste to put them into the same page