Page 1 of 1

restructure workfile

Posted: Tue Feb 04, 2014 1:44 pm
by 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

Re: restructure workfile

Posted: Tue Feb 04, 2014 2:26 pm
by 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

Re: restructure workfile

Posted: Wed Feb 05, 2014 12:11 am
by tvonbrasch
Thank you Gareth! that was just what i was looking for.
Thomas