Dated data table- sample

[tvonbrasch]

Hi

I have a quarterly workfile and I want to create a dated data table so that annual series are shown every fifth year, e.g.

table.JPG (11.79 KiB) Viewed 3669 times

How can I do this?

Thomas

[EViews Jason]

There is no native way to do it. You will have to freeze the dated data table into a table and then manually remove the columns.

This isn't the most sophisticated bit of code but gets the job done.

Code: Select all

'for an annual workfile where the last observation ends in 0 or 5 (ex: 1990 or 1995) freeze(mytable, mode=overwrite) group01.dtable for !i=@obsrange to 0 step -1 if(@mod(@obsrange-!i,5)<>0) then !col = !i+1 mytable.deletecol(!col) endif next

[tvonbrasch]

Hi

okey, thanks for this code!
Thomas