Sorting group members

[jthodge]

This is a question regarding Eviews 6.

Is there a command for sorting the group members in a group (i.e. sorting by series name)?
I am combining two groups into a single group and wish to export the data to an Excel file but would like the variables listed in alphabetical order.

For example:
group gp_odd ser01 ser03 ser05
group gp_even ser02 ser04 ser06
group gp_all gp_odd gp_even
write(b2,t=xls,t) "C:\Temp\all_series.xls" gp_all

This outputs the series listed as:
ser01 ser03 ser05 ser02 ser04 ser06
instead of:
ser01 ser02 ser03 ser04 ser05 ser06

[EViews Gareth]

That has me stumped. Can't, at the moment at least, think of a way to do it in EV6.

In EV7, you can use the @wsort command. But that doesn't help you much

[EViews Glenn]

Sometimes the hardest questions have the simplest answers
The wfsave command will write the Excel file with the series sorted by name...

Code: Select all

wfsave(type=excel) "all_series.xls" gp_all