wks.col.categorical.sort
Contents
Syntax
wks.col.categorical.sort
Type
numeric
Access
Read/write
Description
Read or set the sort method for column n: 0 = unsorted, 1 = ascending, 2 = descending and 3 = customizable (arbitrary).
- Notes: "Unsorted" follows order of appearance in the column. Sort method=3 is Read Only.
Examples
EX1
- This example shows how to set column as categorical. This script imports data, filters the data, sets a column of data as categorical then sorts the filtered categories in ascending order using
wks.col.categorical.sort. Ordering becomes important when creating the stack plot. Sorting in ascending order then plotting the stack "top to bottom" preserves alphabetical ordering of categories, from top to bottom.
// import automobile.dat to a new book fn$ = system.path.program$ + "Samples\Statistics\automobile.dat"; newbook; impASC fn$; // apply filter to column = Make to show only Buick Chrysler GMC Lincoln Saturn wks.col2.filter=1; wks.col2.filterx$ = make; wks.col2.filter$ = "make="Buick" or make="Chrysler" or make="GMC" or make="Lincoln" or make="Saturn""; wks.runfilter(); // set col(2) as categorical and sort in ascending order wks.col2.categorical.type=2; wks.col2.categorical.sort=1; //refresh column filter wks.runfilter(); // unstack worksheet to columns by make wunstackcol -r 2 irng1:=[%H]automobile!C"Power" irng2:=[%H]automobile!B"Make" nonstack:=1 other:=[%H]automobile!A"Year" extract:=0; // create stack plot of col(1) vs. col(2) to end, type=scatter plotstack iy:=(1,2:end) plottype:=scatter order:=0 link:=1 xlink:=1;