Change display order for group spreadsheet.
The sort command changes the sort order settings for spreadsheet display of the group.
Syntax
group_name.sort(series1[, series2, series3])
Follow the keyword with a list of the series you wish to use to determine display order. You may specify up to three series for sorting. If you list two or more series, sort uses the values of the second series to resolve ties in the first series, and values of the third series to resolve ties in the first and second. By default, EViews will sort in ascending order. For purposes of sorting, NAs are considered to be smaller than any other value.
The series may be specified using the name or index of a series in the group. For example, if you provide the integer “2”, EViews will use the second series. To sort by the original workfile observation order, use the integer “0”, or the keyword “obs”.
To sort in descending order, precede the series name or index with a minus sign (“-”).
Examples
gr1.sort(x,y)
change the display order for group GR1, sorting by the series X and Y, with ties in X resolved using Y.
If X is the first series in group GR1 and Y is the second series,
gr1.sort(1,-2)
sorts first in ascending order by X and then in descending order by Y.
gr1.sort(obs)
returns the display order for group GR1 to the original (by observation).
Cross-references
See
“Spreadsheet” for additional discussion.