unstack my data and date

[clubmed]

Hello,

I have an Excel file with monthly frequency (15 years), where the columns represent dates, then the rows represent both cross-sections

(aus, can, far) and variables (fuel, hyd, elc).
i import xls to the EViews, then i have make some step to unstack: this is the captue command

Code: Select all

rename _* m*
pagestack m? @ *?  *
pageunstack(namepat=*?) variable country var01 @ *
delete m
rename m* *

the problem it doesn't detect my data as monthly series when i use unstack? how can solve this.


*)i have rename here my series in the first step (rename _* m* ) because when i import my series it will be renamed like this _1998_01_01...., when i stack next unstack and make "delete _" it dosen't work but when i deleted it by right clic by the mouse it delete group named "_", and get the same result.

**) delete _ not work, but delete _ by right clic mouse it work.

[EViews Gareth]

Not clear what you're trying to do, but if you want to read that file in as a panel:

Code: Select all

wfopen panel_2.xlsx byrow
pagestack aus can fra @ ?*


[clubmed]

1/It work now.
2/I have followed just your tutoriel http://forums.eviews.com/viewtopic.php?f=7&t=74#p1330 for my first question in the topic.
3/ delete series named "_" by command not work, but by right clic it work. why?