Pivoting data?

[paues]

I have a text file with monthly data (see attached example.txt) that I want to import. My problem is that the series are written horizontally while EViews assumes that they are written vertically. That is, EViews yields series named e.g. data200903 and not firstser.

Thus, I guess that I would need to pivot the data panel before I can give it a dated structure. I thought that the code below would get me started, but there seems to be some problem with the pagestack command.

Code: Select all

wfopen(type=text) example.txt colhead=1 delim=; pagestack data*

Any help would be much appreciated.

[EViews Gareth]

Unfortunately EViews currently doesn't allow opening of transposed data in the WFOPEN command.

Your best bet is to create a workfile of the correct size first, then use the old READ command, which support a (t) option for reading transposed data.

[paues]

I see. It is not possible to transpose data once a workfile has been created using the wfopen command?

[EViews Gareth]

Yes, but in general it requires far more work than using Read.