It looks a bit of a mess. On a quick scan I would check the following stubs for consistency
and there may be others.
And the numeric suffixes don't seem to be consistent either.
There's not much point reshaping until you have a clean dataset with a consistent variable name convention.
Sorry, but I have to guess that this is messier than can be handled in a forum.
Code:
CentralAf* CoteDIvoi* SaoTome* SierraLeo* TZA* Tanzania* ZMB* ZWE* Zambia* Zimbabwe* otherafri*
And the numeric suffixes don't seem to be consistent either.
There's not much point reshaping until you have a clean dataset with a consistent variable name convention.
Sorry, but I have to guess that this is messier than can be handled in a forum.
Comment