Importing Panel data from Excel
Posted: Sun Apr 04, 2010 4:19 pm
Hey guys,
a quick question,I'm busy loading panel data into Eviews. I followed the guide over here: viewtopic.php?f=7&t=74 (the one with usa unemployment etc) but still managed to stumble on some problems. I work with Eviews 5.1 (university licenses only allow us to have 5.1 on personal laptops). When I add my data following the tutorial everything's fine uptill the reshaping. When I reshape and enter my time and cross section variables (which are recdats and ID) I get this error: http://i43.tinypic.com/j9rgc7.jpg
My data looks as follows: http://i44.tinypic.com/n4e5vt.jpg
NOF will be my independent variable on which I have to do OLS (mostl ikely regression), all the other variables are dependent except for recdats, no, ID.
Recdats is the time indicator (i can only import a year variable instead of recdats but the problem remains and gets even worse with about 30 duplications). No is actually not needed (still have to remove it) and ID should be my unique cross section identifier.
My data consists of the recommendation of financial analysts covering different firms, I made ID as an unique link between an analyst and a company. For instance analyst A with company Coca Cola has ID 1 throughout time and analyst A with company pepsi has ID 2, analyst B with coca cola has ID 3 and so on. I have a total of 1784 observations and 1688 ID's (which is logical since some companies-analyst duo's return over time). I deleted all extra information I deemed redundant such as analyst unique codes or firm unique codes (which I used to create the ID variable) also ticker etc. If you think I deleted necessary data do tell and ask if I have that kind of information..
What am I doing wrong that I get the error? When following the guide I enter recdats as date series and ID as cross section identifier.
Thank you, if something's not clear just ask.
a quick question,I'm busy loading panel data into Eviews. I followed the guide over here: viewtopic.php?f=7&t=74 (the one with usa unemployment etc) but still managed to stumble on some problems. I work with Eviews 5.1 (university licenses only allow us to have 5.1 on personal laptops). When I add my data following the tutorial everything's fine uptill the reshaping. When I reshape and enter my time and cross section variables (which are recdats and ID) I get this error: http://i43.tinypic.com/j9rgc7.jpg
My data looks as follows: http://i44.tinypic.com/n4e5vt.jpg
NOF will be my independent variable on which I have to do OLS (mostl ikely regression), all the other variables are dependent except for recdats, no, ID.
Recdats is the time indicator (i can only import a year variable instead of recdats but the problem remains and gets even worse with about 30 duplications). No is actually not needed (still have to remove it) and ID should be my unique cross section identifier.
My data consists of the recommendation of financial analysts covering different firms, I made ID as an unique link between an analyst and a company. For instance analyst A with company Coca Cola has ID 1 throughout time and analyst A with company pepsi has ID 2, analyst B with coca cola has ID 3 and so on. I have a total of 1784 observations and 1688 ID's (which is logical since some companies-analyst duo's return over time). I deleted all extra information I deemed redundant such as analyst unique codes or firm unique codes (which I used to create the ID variable) also ticker etc. If you think I deleted necessary data do tell and ask if I have that kind of information..
What am I doing wrong that I get the error? When following the guide I enter recdats as date series and ID as cross section identifier.
Thank you, if something's not clear just ask.