import data on panel workfile
Posted: Tue Nov 22, 2016 10:43 am
Dear all,
I am trying to build a panel workfile in order to have variables that shows observations in 82 quarters for 25 countries.
Even if the post in that link http://forums.eviews.com/viewtopic.php?t=74 is really clear, and I managed to create several panel workfiles, this time I'm not succeeding in doing it.
If I apply the first method indicated in the link: I have problems with date in the panel.
Moreover this undated panel has too many observations.
When I try to set the date using the country variable (var01) to indicate cross-identities and the date variable to indicate time, it says the following: "indicies do not uniquely identify observeations. 51168 duplicate date(s) found. create CELLID series to identify observations."
I really don't know how to solve this problem.
If I apply the third approach, the one that in the first page of import shows all year' series, when I do the unstaking with respect to the variable, it cannot proceed in doing it and appears to me this text: "id series do not uniquely identify workfile observations"
I have no idea how to overcome this problems.
I also noticed that when I create my panel workfile it creates two series for date, one called DATEID the other with the name I give it while importing. This extravariable doesn't appear in the pictures shown by Eviews Gareth in the link, I don't know if this can be the cause of the huge amount of observations that I have in the first case. I wuld be really grateful if somebody would help me
thanks in advance
Giovanna
I am trying to build a panel workfile in order to have variables that shows observations in 82 quarters for 25 countries.
Even if the post in that link http://forums.eviews.com/viewtopic.php?t=74 is really clear, and I managed to create several panel workfiles, this time I'm not succeeding in doing it.
If I apply the first method indicated in the link: I have problems with date in the panel.
Moreover this undated panel has too many observations.
When I try to set the date using the country variable (var01) to indicate cross-identities and the date variable to indicate time, it says the following: "indicies do not uniquely identify observeations. 51168 duplicate date(s) found. create CELLID series to identify observations."
I really don't know how to solve this problem.
If I apply the third approach, the one that in the first page of import shows all year' series, when I do the unstaking with respect to the variable, it cannot proceed in doing it and appears to me this text: "id series do not uniquely identify workfile observations"
I have no idea how to overcome this problems.
I also noticed that when I create my panel workfile it creates two series for date, one called DATEID the other with the name I give it while importing. This extravariable doesn't appear in the pictures shown by Eviews Gareth in the link, I don't know if this can be the cause of the huge amount of observations that I have in the first case. I wuld be really grateful if somebody would help me
thanks in advance
Giovanna