Undated Panel

[javiersan]

Hi,

I have 11 series in a panel dated anually from 1970...2004 and 146 countries identified by their iso code in a stacked format in Excel. I import it to Eviews and unstack it with the following code which works well:

Code: Select all

wfopen "mydata.xls" colhead=1 namepos=first range="Data" pagestruct iso @date(year) pageunstack(namepat="?_*") iso year @ *

All the series created in the file are well dated from 1970.

However, when I store them to a new database, they are stored in an undated format. I have verified that the series start in 1970 and end in 2004 so I don't understand why they are stored this way. Any ideas why?

Thanks,

Javier

[javiersan]

Actually, let me restate the problem.

After

wfopen "mydata.xls" colhead=1 namepos=first range="Data"
pagestruct iso @date(year)

A workfile and page are created with the following Range/sample indications:
Range: 1970 2004 x 146 -- 5110 obs
Sample: 1970 2004 -- 5110 obs

with indicators "Year" and "Iso". This looks ok, but when I run the instruction:

Code: Select all

pageunstack(namepat="?_*") iso year @ *

the following Range/sample appear:
Range: 1 35 (indexed) -- 35 obs
Sample: 1 35 -- 35 obs

The "Year" and "Iso" (now as a pool object) have been transferred to a new page but not the date Range (I would have expected the Range to be 1970 2004). Thus, when I store the created series (>1500), they are undated.

I have followed these instructions with other stacked panels and the dating was transferred when unstacking the series, and I don't understand what went wrong this time. Any help appreciated.

Regards,

Javier

[EViews Gareth]

I think we'd need to see the data to help with this.