Reshaping Data

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

isaiah
Posts: 13
Joined: Wed Sep 07, 2011 1:06 pm

Reshaping Data

Postby isaiah » Wed Nov 11, 2015 11:25 pm

Dear All,

Can someone help me on how to reshape the data that I have attached please.

Isaiah
Attachments
EVIEWS FORUM.xls
Reshaping Data
(770.5 KiB) Downloaded 59 times

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

Re: Reshaping Data

Postby EViews Gareth » Wed Nov 11, 2015 11:31 pm

That's a very generic question. You're going to have to give a lot more detail before anyone can answer sensibly.
Follow us on Twitter @IHSEViews

isaiah
Posts: 13
Joined: Wed Sep 07, 2011 1:06 pm

Re: Reshaping Data

Postby isaiah » Mon Nov 16, 2015 11:25 pm

Dear Gareth

Sorry that the question was not specific. I would like to reshape the data to be a panel data format. For example:
Bank Country Year Var1 Var2 Var2
HSBC UK 2015 0.2 0.17 0.16
HSBC UK 2014 0.7 0.21 0.19
BARCLAYS US 2015 0.8 0.34 0.41
BARCLAYS US 2014 0.71 0.24 0.51

Hope this will help.

Thanking you in anticipation.

Isaiah

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

Re: Reshaping Data

Postby EViews Gareth » Tue Nov 17, 2015 7:17 am

Where is your year data?
Follow us on Twitter @IHSEViews

isaiah
Posts: 13
Joined: Wed Sep 07, 2011 1:06 pm

Re: Reshaping Data

Postby isaiah » Tue Nov 17, 2015 9:26 am

Dear Gareth

I had attached the data on my previous email. Nevertheless, it is attached herein. I would like to reshape the data to be a panel data format. For example:
Bank Country Year Var1 Var2 Var2
HSBC UK 2015 0.2 0.17 0.16
HSBC UK 2014 0.7 0.21 0.19
BARCLAYS US 2015 0.8 0.34 0.41
BARCLAYS US 2014 0.71 0.24 0.51


Thanking you in anticipation.

Isaiah
Attachments
EVIEWS FORUM.xlsx
(1.1 MiB) Downloaded 51 times

startz
Non-normality and collinearity are NOT problems!
Posts: 3384
Joined: Wed Sep 17, 2008 2:25 pm

Re: Reshaping Data

Postby startz » Tue Nov 17, 2015 9:36 am

When I drag-and-dropped the file onto EViews 9, it came up as a bank by year panel. What is it different that you want?

isaiah
Posts: 13
Joined: Wed Sep 07, 2011 1:06 pm

Re: Reshaping Data

Postby isaiah » Thu Nov 19, 2015 2:29 am

Dear Startz

I am using Eviews 6 and it does not come as a panel.
isaiah

startz
Non-normality and collinearity are NOT problems!
Posts: 3384
Joined: Wed Sep 17, 2008 2:25 pm

Re: Reshaping Data

Postby startz » Thu Nov 19, 2015 7:21 am

An EViews 6 question is probably going to need the EViews staff for an answer.

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

Re: Reshaping Data

Postby EViews Gareth » Thu Nov 19, 2015 7:39 am

Could you post the workfile that occurs when you open the file in Excel?
Follow us on Twitter @IHSEViews

isaiah
Posts: 13
Joined: Wed Sep 07, 2011 1:06 pm

Re: Reshaping Data

Postby isaiah » Fri Nov 20, 2015 2:13 am

Dear Gareth,

I have attached an excel file that I trying to import to Eviews. I have also tried Eviews 8 students version.

Regards,
Isaiah
Attachments
EVIEWS FORUM.xls
(770.5 KiB) Downloaded 49 times

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

Re: Reshaping Data

Postby EViews Gareth » Fri Nov 20, 2015 6:39 am

Yes, but we want the EViews file, not the Excel file.
Follow us on Twitter @IHSEViews

isaiah
Posts: 13
Joined: Wed Sep 07, 2011 1:06 pm

Re: Reshaping Data

Postby isaiah » Sun Nov 22, 2015 10:15 am

Dear Gareth,
I have attached a short version of data as Eviews 8 would not let safe the entire data file.
Attachments
Eviews Forum Short version data.WF1
(34.51 KiB) Downloaded 61 times


Return to “Data Manipulation”

Who is online

Users browsing this forum: No registered users and 9 guests