Panel data import

For questions regarding the import, export and manipulation of data in EViews, including graphing and basic statistics.

Moderators: EViews Gareth, EViews Steve, EViews Moderator, EViews Jason

Elenia
Posts: 8
Joined: Sun Sep 16, 2012 7:03 pm

Panel data import

Postby Elenia » Mon Sep 17, 2012 4:11 pm

Hello,
My question might sound stupid but I just started working with Eviews and some things are not that obvious to me.
I have panel data and when I import data from excel file I get question about date series - and I type 'week' and that's obviously wrong since eviews doesn't let me continue with that. What should i type then? What i have is weekly sales and price promotion information for 5 products (for each product there are 261 weekly observations; total number of observations is 1305). Also I don't really understand what am I suppose to specify in cross section ID series: if I want to regress sales as a function of price and other variables, should I type sales or what?
Thanks in advance for any help!

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

Re: Panel data import

Postby EViews Gareth » Mon Sep 17, 2012 4:56 pm

Hard to tell you how to import the data without knowing how the data look in Excel.

Elenia
Posts: 8
Joined: Sun Sep 16, 2012 7:03 pm

Re: Panel data import

Postby Elenia » Mon Sep 17, 2012 6:52 pm

It looks like this (where D is number of the week, dummy variable). I can also attach excel file if needed.
Thank you!
Attachments
File.jpg
File.jpg (282.74 KiB) Viewed 7275 times

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

Re: Panel data import

Postby EViews Gareth » Mon Sep 17, 2012 7:13 pm

Attach the Excel file.

Elenia
Posts: 8
Joined: Sun Sep 16, 2012 7:03 pm

Re: Panel data import

Postby Elenia » Mon Sep 17, 2012 8:21 pm

Here it is.
Attachments
scan pro WEEKLY one retailer adj.xls
(956.5 KiB) Downloaded 311 times

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

Re: Panel data import

Postby EViews Gareth » Mon Sep 17, 2012 9:17 pm

Just open the file in EViews, accepting the default settings, then hit Proc->Structure/Resize Current Page, change the type to dated panel, enter "week" as the date series, and "product" as the cross-section.

Elenia
Posts: 8
Joined: Sun Sep 16, 2012 7:03 pm

Re: Panel data import

Postby Elenia » Tue Sep 18, 2012 4:29 pm

Thanks a lot for your help, but Eviews still doesnt let me type 'Week' in dated panel

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

Re: Panel data import

Postby EViews Gareth » Tue Sep 18, 2012 4:56 pm

Which version of EViews?

Elenia
Posts: 8
Joined: Sun Sep 16, 2012 7:03 pm

Re: Panel data import

Postby Elenia » Tue Sep 18, 2012 4:57 pm

Eviews 7

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

Re: Panel data import

Postby EViews Gareth » Tue Sep 18, 2012 5:11 pm


Elenia
Posts: 8
Joined: Sun Sep 16, 2012 7:03 pm

Re: Panel data import

Postby Elenia » Tue Sep 18, 2012 6:00 pm

Thanks a lot! And sorry for taking so much of your time.


Return to “Data Manipulation”

Who is online

Users browsing this forum: No registered users and 2 guests