combine many individual series into one dataset

For questions regarding the import, export and manipulation of data in EViews, including graphing and basic statistics.

Moderators: EViews Gareth, EViews Jason, EViews Steve, EViews Moderator

Mai LÊ
Posts: 16
Joined: Mon May 06, 2019 7:09 am

combine many individual series into one dataset

Postby Mai LÊ » Wed Jan 13, 2021 9:28 pm

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!

EViews Gareth
Fe ddaethom, fe welon, fe amcangyfrifon
Posts: 12694
Joined: Tue Sep 16, 2008 5:38 pm

Re: combine many individual series into one dataset

Postby EViews Gareth » Wed Jan 13, 2021 9:53 pm

You’ll have to provide more details
Follow us on Twitter @IHSEViews

Mai LÊ
Posts: 16
Joined: Mon May 06, 2019 7:09 am

Re: combine many individual series into one dataset

Postby Mai LÊ » Wed Jan 13, 2021 11:20 pm

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.

EViews Gareth
Fe ddaethom, fe welon, fe amcangyfrifon
Posts: 12694
Joined: Tue Sep 16, 2008 5:38 pm

Re: combine many individual series into one dataset

Postby EViews Gareth » Thu Jan 14, 2021 2:51 am

Are they not already in the same EViews workfile page?
Follow us on Twitter @IHSEViews

Mai LÊ
Posts: 16
Joined: Mon May 06, 2019 7:09 am

Re: combine many individual series into one dataset

Postby Mai LÊ » Thu Jan 14, 2021 3:10 am

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

Mai LÊ
Posts: 16
Joined: Mon May 06, 2019 7:09 am

Re: combine many individual series into one dataset

Postby Mai LÊ » Thu Jan 14, 2021 3:15 am

yes, you are right.
It's in separate pages for each country, and I want to combine all series in one page.

EViews Gareth
Fe ddaethom, fe welon, fe amcangyfrifon
Posts: 12694
Joined: Tue Sep 16, 2008 5:38 pm

Re: combine many individual series into one dataset

Postby EViews Gareth » Thu Jan 14, 2021 7:11 am

You can copy and paste to put them into the same page
Follow us on Twitter @IHSEViews


Return to “Data Manipulation”

Who is online

Users browsing this forum: No registered users and 14 guests