EViews.com

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

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")

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.

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

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

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

So you have a 3D panel?

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

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

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)!!

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

And the solution was??? ^

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

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!