Importing Unbalanced Data From Execl

For requesting general information about EViews, sharing your own tips and tricks, and information on EViews training or guides.

Moderators: EViews Gareth, EViews Moderator

economics_student1
Posts: 4
Joined: Mon Aug 08, 2016 10:10 am

Importing Unbalanced Data From Execl

Postby economics_student1 » Mon Aug 08, 2016 10:16 am

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

EViews Gareth
Fe ddaethom, fe welon, fe amcangyfrifon
Posts: 11262
Joined: Tue Sep 16, 2008 5:38 pm

Re: Importing Unbalanced Data From Execl

Postby EViews Gareth » Mon Aug 08, 2016 10:41 am

No attachment.
Follow us on Twitter @IHSEViews

economics_student1
Posts: 4
Joined: Mon Aug 08, 2016 10:10 am

Re: Importing Unbalanced Data From Execl

Postby economics_student1 » Mon Aug 08, 2016 10:49 am

Sorry, here we go!

Thanks.
Attachments
wages.xls
Panel dataset 29000 Obs.
(3.66 MiB) Downloaded 33 times

EViews Gareth
Fe ddaethom, fe welon, fe amcangyfrifon
Posts: 11262
Joined: Tue Sep 16, 2008 5:38 pm

Re: Importing Unbalanced Data From Execl

Postby EViews Gareth » Mon Aug 08, 2016 11:05 am

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

economics_student1
Posts: 4
Joined: Mon Aug 08, 2016 10:10 am

Re: Importing Unbalanced Data From Execl

Postby economics_student1 » Mon Aug 08, 2016 11:14 am

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!
Attachments
Screen Shot 2016-08-08 at 19.11.13.png
eviews Screenshot
Screen Shot 2016-08-08 at 19.11.13.png (448.4 KiB) Viewed 1090 times

economics_student1
Posts: 4
Joined: Mon Aug 08, 2016 10:10 am

Re: Importing Unbalanced Data From Execl

Postby economics_student1 » Mon Aug 08, 2016 11:15 am

And the following for the years variable
Attachments
Screen Shot 2016-08-08 at 19.15.05.png
screen shot of years
Screen Shot 2016-08-08 at 19.15.05.png (183.5 KiB) Viewed 1090 times


Return to “General Information and Tips and Tricks”

Who is online

Users browsing this forum: No registered users and 3 guests