Hello,
I have an unbalanced data set I'd like to import into Eviews from Excel. However I am having trouble getting Eviews to recognise my data properly.
The Dataset consists of around 29000 observations, and has an idcode for every individual. From 1968 - 1988 each individual was interviewed a different number of times, rendering my panel data unbalanced.
Is anybody able to help me with this? The dataset in excel is attached.
Many Thanks
Importing Unbalanced Data From Execl
Moderators: EViews Gareth, EViews Moderator
-
- Posts: 4
- Joined: Mon Aug 08, 2016 10:10 am
-
- Fe ddaethom, fe welon, fe amcangyfrifon
- Posts: 13307
- Joined: Tue Sep 16, 2008 5:38 pm
-
- Posts: 4
- Joined: Mon Aug 08, 2016 10:10 am
Re: Importing Unbalanced Data From Execl
Sorry, here we go!
Thanks.
Thanks.
- Attachments
-
- wages.xls
- Panel dataset 29000 Obs.
- (3.66 MiB) Downloaded 357 times
-
- Fe ddaethom, fe welon, fe amcangyfrifon
- Posts: 13307
- Joined: Tue Sep 16, 2008 5:38 pm
Re: Importing Unbalanced Data From Execl
If I drag that file on to EViews, it automatically detects the panel structure without me needing to do anything. Just clicking "Finish" works.
Follow us on Twitter @IHSEViews
-
- Posts: 4
- Joined: Mon Aug 08, 2016 10:10 am
Re: Importing Unbalanced Data From Execl
Hello,
Thanks for your prompt reply. I ended up with the following on Eviews, and it looks like it has recognised the panel data!
I take it as I am ready to start creating dummy variables for my years, and running my regressions.
Thank you so much!
Thanks for your prompt reply. I ended up with the following on Eviews, and it looks like it has recognised the panel data!
I take it as I am ready to start creating dummy variables for my years, and running my regressions.
Thank you so much!
- Attachments
-
- eviews Screenshot
- Screen Shot 2016-08-08 at 19.11.13.png (448.4 KiB) Viewed 5756 times
-
- Posts: 4
- Joined: Mon Aug 08, 2016 10:10 am
Re: Importing Unbalanced Data From Execl
And the following for the years variable
- Attachments
-
- screen shot of years
- Screen Shot 2016-08-08 at 19.15.05.png (183.5 KiB) Viewed 5756 times
Return to “General Information and Tips and Tricks”
Who is online
Users browsing this forum: No registered users and 14 guests