panel data importation from dif excel sheets
Posted: Fri Mar 25, 2016 2:44 am
Hi All,
I would like to ask about your help. I have panel data ( including dummy explanatory variables) in over 500 companies, separated by year. Each sheet in my excel is dedicated to a different year. how can i import the file and transform it to panel data.
I have read the threads of Eviews Gareth adn especially the 3rd and 4th one, but in my case i have no data that ara regenareted like in his thread.
Is it possible to suggest me the code or the steps?
I attach you a part of my sample in order to see the format that i have
Thank you in advance
T
I would like to ask about your help. I have panel data ( including dummy explanatory variables) in over 500 companies, separated by year. Each sheet in my excel is dedicated to a different year. how can i import the file and transform it to panel data.
I have read the threads of Eviews Gareth adn especially the 3rd and 4th one, but in my case i have no data that ara regenareted like in his thread.
Is it possible to suggest me the code or the steps?
I attach you a part of my sample in order to see the format that i have
Thank you in advance
T