restructure workfile

[tvonbrasch]

Hi Eviews team,

i have imported data into the workfile unstacking (attached), with a list of countrynames (as an alpha), a series named gfcf and a series named year (= 2005 for all countries)

what is the command to structure the workfile as an annual workfile (2005 2005) with the gfcf variable for each country, i.e., gfcf_countryname ?

sincerely
thomas von brasch

[EViews Gareth]

Code: Select all

series crossid = @trend+1 pagecreate(page=2) a 2002 2005 31 series year = @val(@datestr(@date, "YYYY")) copy 1\country 2\country @src crossid @dest crossid copy 1\gfcf 2\gfcf @src crossid year @dest crossid year alpha validnames = @makevalidname(country) pageunstack(namepat="*_?") validnames dateid @ gfcf

[tvonbrasch]

Thank you Gareth! that was just what i was looking for.
Thomas