BANKSCOPE data restructure to panel data

[lana]

Hi,
I get data from bankscope and I don't know how to re-structure it into panel data. Could any one help me please
thank you

[trubador]

How to enter data into a Panel workfile

[lana]

How to enter data into a Panel workfile

thank you for your responde. actually my data look like in the attachement capture2 but when I try to import the data into eviews I don't know what should I put in "cross section ID series" and "date series" (attachement capture1")

[EViews Gareth]

Whatever the name of the column containing dates you put in the date series box, and the name of the column containing cross-sections you put in the cross section series box.

[lana]

that's what I did on the pictures (PAYS.CODE = country code) but it didn't work. I get an error message (PAYS.CODE) not defined) ! . but i got it in the data

[EViews Gareth]

You can't have a "." in an EViews series name. Try pays_code

[lana]

It works but now I have an other error message (repeated values found in source id series)!
actually I have for the same periode (2006-2014) data for each bank in each country (please can you check picture 2)
thank you

[EViews Gareth]

So you have a 3D panel?

[lana]

I don't know what is it. believe me it's my first experience with the panel data. can you explain me what is it and how can I treat it using eviews
thanks

[EViews Gareth]

Traditional panels are 2 dimensional. You have a time index and a cross-section index. Nearly all econometric theory works only with 2D panels.

[lana]

thank you for the explanation. I realize that I was wrong it is just banks and years (without coutry). I've juste tried now but it's the same ("repeated values in the ressource id series)!!

[lana]

thank you for your help. I find the solution finally!! :D

[dmauricio]

And the solution was??? ^

Thank you, I'm going through the same issue...

[StudentGroningen]

Hi all, and lana in particular,

how did you manage to get the excel model as in capture2.docx??
I am struggling with my bankscope export, because I don't know how to import it to EViews (it is not like one of the examples on http://forums.eviews.com/viewtopic.php?f=7&t=74

My excel model looks like this (example):

Bank..........Total assets 2014.......Total assets 2013.......Total asset 2012......Equity 2014........Equity 2013......Equity 2012 etc
Citigroup............80........................70..........................60...................40....................35..................30
JP Morgan...........70........................60..........................50...................30....................25..................20
etc

I have 4939 banks, 11 variables and 15 years in total. Do you know a way to import this file into EViews? Or how to restructure my Excel model in a way that it can be imported easily?

Thanks!