EViews.com

Dear All,

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

Isaiah

That's a very generic question. You're going to have to give a lot more detail before anyone can answer sensibly.

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

Where is your year data?

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

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?

Dear Startz

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

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

Could you post the workfile that occurs when you open the file in Excel?

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

Yes, but we want the EViews file, not the Excel file.

Dear Gareth,
I have attached a short version of data as Eviews 8 would not let safe the entire data file.