Illegal panel structure

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

paues
Posts: 218
Joined: Fri Apr 15, 2011 7:16 am
Location: Stockholm, Sweden

Illegal panel structure

Postby paues » Thu Dec 20, 2012 9:34 am

When running this line of code

Code: Select all

PageLoad imp.txt delim=tab na="NA"
I get an error message "Illegal panel structure SERIES01 is nested within subsequent dimensions of the panel structure." What does it mean? What can I do about it? The series seem to be imported just fine - an unstructured panel much similar (except for the number of series and observations) to what I get by running this line of code

Code: Select all

PageLoad fb.txt delim=tab na="NA"
Attachments
Fb.txt
Imports just fine
(7.17 KiB) Downloaded 545 times
imp.txt
Gives illegal panel structure error
(31.01 KiB) Downloaded 542 times

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

Re: Illegal panel structure

Postby EViews Gareth » Thu Dec 20, 2012 9:47 am

EViews' automatic detection routines appear to be thinking that it is a 3-dimensional panel, when it is, in fact, a 2-dimensional. You could modify your line to be:

Code: Select all

PageLoad imp.txt delim=tab na="NA" @id series02 series03

paues
Posts: 218
Joined: Fri Apr 15, 2011 7:16 am
Location: Stockholm, Sweden

Re: Illegal panel structure

Postby paues » Thu Dec 20, 2012 10:08 pm

I haven't had a chance to try out your suggestion yet, but I wonder: Is the data in imp.txt a 2-dimensional panel, as you claim? Isn't it 3-dimensional? There are 4 columns and each combination of the first 3 columns corresponds to a unique value in the fourth column. That should make it 3-dimensional. Or is my logic (or my understanding of the data in imp.txt) faulty?

To give you a sense of what my next step would be (in case my approach here might be less than optimal), I want to make a table identical to the text file, that is 4 columns and ~900 rows (and many other tables from similar text files with varying number of columns and rows such as the attached fb.txt).

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

Re: Illegal panel structure

Postby EViews Gareth » Thu Dec 20, 2012 11:09 pm

I believe series02 and series03 perfectly predict series01. i.e. they are enough to uniquely identify the observations. Are there combinations of series02 and series03 that having varying values of series01?

paues
Posts: 218
Joined: Fri Apr 15, 2011 7:16 am
Location: Stockholm, Sweden

Re: Illegal panel structure

Postby paues » Fri Dec 21, 2012 2:03 am

No, you are correct. There are no combinations of series02 and series03 that have varying values of series01. Thank you. But that still begs the question why this causes an error. While I can see that nested series would be a problem if one tried to apply a structure to the page, this page is unstructured. And, as the code below shows, it is possible to create a similar page consisting of only ones (where the problem would arguably be more prevalent) both by creating the series in EViews and by loading my new text file ones.txt.

Code: Select all

pagecreate u 10 series series01=1 series series02=1 series series03=1 series series04=1

Code: Select all

pageload ones.txt delim=tab na="NA"
Attachments
ones.txt
Four series=1
(88 Bytes) Downloaded 428 times

paues
Posts: 218
Joined: Fri Apr 15, 2011 7:16 am
Location: Stockholm, Sweden

Re: Illegal panel structure

Postby paues » Fri Dec 21, 2012 4:10 am

Moreover, as I pointed out in my first post, the series in imp.txt are imported just fine. When I elaborate on my first code snippet to get the below, it works just as I intended (as do all the subsequent steps) except from the error message in the log.

Code: Select all

!errbefore=@errorcount !maxerrbefore=@maxerrcount setmaxerrs !maxerrbefore+1 pageload imp.txt delim=tab na="na" seterrcount !errbefore setmaxerrs !maxerrbefore
So the real question seems to be, why does this cause an error message in EViews? (And thereby, this topic is perhaps be better suited for the "Bug Report" forum.)

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

Re: Illegal panel structure

Postby EViews Gareth » Fri Dec 21, 2012 8:56 am

The data can be brought in fine, and there is no reason why you can't have those series in a workfile. What you cannot do is use those series to structure it as a 3-d panel. For some reason, EViews is detecting it as a 3-d panel anyway, and hence throwing the error.

paues
Posts: 218
Joined: Fri Apr 15, 2011 7:16 am
Location: Stockholm, Sweden

Re: Illegal panel structure

Postby paues » Fri Dec 21, 2012 9:04 am

Is there someway to specify in the pageload command that it should be imported as an unstructured page?

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

Re: Illegal panel structure

Postby EViews Gareth » Fri Dec 21, 2012 9:49 am

Yes:

Code: Select all

PageLoad imp.txt delim=tab na="NA" @freq u

paues
Posts: 218
Joined: Fri Apr 15, 2011 7:16 am
Location: Stockholm, Sweden

Re: Illegal panel structure

Postby paues » Fri Dec 21, 2012 10:05 am

Thank you!


Return to “Data Manipulation”

Who is online

Users browsing this forum: No registered users and 2 guests