Page 1 of 1

Panel data import

Posted: Mon Sep 17, 2012 4:11 pm
by Elenia
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!

Re: Panel data import

Posted: Mon Sep 17, 2012 4:56 pm
by EViews Gareth
Hard to tell you how to import the data without knowing how the data look in Excel.

Re: Panel data import

Posted: Mon Sep 17, 2012 6:52 pm
by Elenia
It looks like this (where D is number of the week, dummy variable). I can also attach excel file if needed.
Thank you!

Re: Panel data import

Posted: Mon Sep 17, 2012 7:13 pm
by EViews Gareth
Attach the Excel file.

Re: Panel data import

Posted: Mon Sep 17, 2012 8:21 pm
by Elenia
Here it is.

Re: Panel data import

Posted: Mon Sep 17, 2012 9:17 pm
by EViews Gareth
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.

Re: Panel data import

Posted: Tue Sep 18, 2012 4:29 pm
by Elenia
Thanks a lot for your help, but Eviews still doesnt let me type 'Week' in dated panel

Re: Panel data import

Posted: Tue Sep 18, 2012 4:56 pm
by EViews Gareth
Which version of EViews?

Re: Panel data import

Posted: Tue Sep 18, 2012 4:57 pm
by Elenia
Eviews 7

Re: Panel data import

Posted: Tue Sep 18, 2012 5:11 pm
by EViews Gareth

Re: Panel data import

Posted: Tue Sep 18, 2012 6:00 pm
by Elenia
Thanks a lot! And sorry for taking so much of your time.