EViews.com

Hi

I have downloaded the TED database "All data flat file - Adjusted version" from https://www.conference-board.org/data/e ... m?id=27762.

But when opening this file It holds the country name C“te d'Ivoire in the alpha series countries.

when trying to structure the workfile using the command i get the error message:

Series specified for unstacking does not have valid values for forming series names in "PAGEUNSTACK SUPERID YEAR @ VALUE".

how do I change the name of the country in the alpha series so that the name is valid?

i tried something like

country=@replace(country,"C“te d'Ivoire","C_te_d_Ivoire")

but then i get the error message:

Unmatched quotes in "GENR COUNTRY=@REPLACE(COUNTRY,"C“TE D"...

I believe the problem arises because C“te d'Ivoire has “ in the name
Thomas

Is your copy up to date? I don't get an error when I do the pagestruct. It seems to work just fine.

thanks for your quick reply,

yes, my Eviews is up to date. (Dec 27 2016)

try the command then i get the message

Series specified for unstacking does not have valid values for forming series names in "PAGEUNSTACK SUPERID YEAR @ VALUE".

Thomas

Yep, you can't have illegal characters in series names, so unstacking using that ID will fail. Not only" characters, but also spaces, parenthesis etc... will cause it to fail.

You can use the @makevalidname function to tidy up the ID series, but it is probably too long still, since the data series will be appended to the names.

hi

thanks, the @makevalidname function is perfect.

but now, when i run the following code where i have shortened the names:
i get the following error:

Indices do not uniquely identify observations in "PAGESTRUCT(BAL=SE) INDICATOR_SHORT COUNTRY @DATE(YEAR)".

what is it about this dataset that I am missing here? have I done something wrong with the unstack command?

Thomas

I think your method of contracting the country names down is not unique - some countries get bound together as one.

For example, your country codes starting with i are: Which were translated from the countries: It is a shame the source didn't include country ISO codes for you.

Aha, that explains it.

in the data, there is an alpha series called indicator_long, holding information about each data series, when using commands such as to unstack the workpage, how can I change the code so that the information in the alpha series "indicator_long" is included as a description in each of the unstacked series, i.e., the unstacked series "avghr_aus" holds the description "Annual hours worked per worker".

Thomas