EViews.com

Posted: **Tue Sep 10, 2013 5:13 am**

Good afternoon.

First of all I would like to thank you all the help you offer within this forum. It has been very useful and helpful during my first days with the software.
Now I have a problem and I am stuck.

I would like to pass all the series I could find in the WF through a proccess/program.
As there is a command (@wlookup) which find all the series (@wlookup("*","series")), I wonder if there exists a way so I can "do something" with every series.

Building a matrix with all the series would be excellent, although not mandatory as I can work with the series themselves.

Thank you in advance!

PS I am using Eviews 7

Posted: **Tue Sep 10, 2013 6:13 am**

Code: Select all

'Create a list for all series
%slist = @wlookup("*","series")

'Determine the number of series in case of further use
!nlist = @wcount(%slist)

'Create a group for all series
group allseries.add {%slist}

'Create a matrix w/o NAs
stom(allseries,matseries)
'stomna(allseries,matseries)

'You can work with each series anytime.
'There are many ways to do that.
'Below are the two of them:

'Example-1
for %s {%slist}
  !mean_{%s} = @mean({%s})
next

'Example-2
for !i = 1 to !nlist
   %ser = allseries.@seriesname(!i)
    !mean_{%ser} = @mean({%ser})
next

Posted: **Wed Sep 11, 2013 12:29 am**

Thanks a lot Trubador, it really helped me loads :D

EViews.com

Working with all the series in a WF

Working with all the series in a WF

Re: Working with all the series in a WF

Re: Working with all the series in a WF