Working with all the series in a WF

[shm83]

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

[trubador]

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

[shm83]

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