I have downloaded the TED database "All data flat file - Adjusted version" from https://www.conference-board.org/data/economydatabase/index.cfm?id=27762.
But when opening this file
Code: Select all
wfopen "..\TED\TED_adjusted.txt"
It holds the country name C“te d'Ivoire in the alpha series countries.
when trying to structure the workfile using the command
Code: Select all
pagestruct(bal=m) indicator_short country @date(year)
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