Merge two panel workfiles or pages

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

jfgeli
Posts: 72
Joined: Fri Jan 30, 2009 6:29 pm

Merge two panel workfiles or pages

Postby jfgeli » Thu Feb 09, 2017 10:54 am

Hi there,
I need two merge 2 panels. I have each panel on a page on Eviews. It is a panel that contains economic and institutional indicators for serveral countries. Is there a way to create, let´s say, a 3rd page that would merge both panels? Ideally, I need to tell Eviews to merge by obsid and period. In my case, it would need country and year.
Thanks!
Fede

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

Re: Merge two panel workfiles or pages

Postby EViews Gareth » Thu Feb 09, 2017 1:40 pm

How do the current pages differ?

Same countries, different series, or same series different countries? Or different dates?
Follow us on Twitter @IHSEViews

jfgeli
Posts: 72
Joined: Fri Jan 30, 2009 6:29 pm

Re: Merge two panel workfiles or pages

Postby jfgeli » Tue Apr 04, 2017 6:56 am

Sorry for not coming back before...managed to do it already ;)
Thanks!

shineK
Posts: 24
Joined: Sat Jun 09, 2018 12:23 am
Location: New Taipei City,Taiwan
Contact:

Re: Merge two panel workfiles or pages

Postby shineK » Sun Jun 17, 2018 12:10 am

Hi there,

i need to do a match merge with 2 excel files according to column "cusip"(1st file > cusip_alpha, 2nd > "s_comp_cusip") and create a new column named "DS_S", which is on the basis of the 1st file column "type" after merging, in the 2nd file. How do i write the program in the Eviews?
Note: i had tried to use match merge in "import" function but it didn't succeed...

P.s. This is my first time post on the Eviews, if there is any problem, please feel free to send the message to me, thank you.
Best,
SK :D

EViews Steve
EViews Developer
Posts: 788
Joined: Tue Sep 16, 2008 3:00 pm
Location: Irvine, CA

Re: Merge two panel workfiles or pages

Postby EViews Steve » Sun Jun 17, 2018 7:43 am

I would suggest you first import them separately into an EViews workfile, then perform the match merge within EViews.


Return to “Data Manipulation”

Who is online

Users browsing this forum: No registered users and 15 guests