Grouping

Data can be grouped into categories, split into columns, combined from columns, extracted as subgroups from larger groupings, tabulated as counts, and expanded from tables of counts using these functions:

• CATEGORISE (transform continuous data into categories)

• EXTRACT (extract subsets of data based on search criteria)
   

• COMBINE (merge columns of data and form a group identifier for the merged column)

• SPLIT (split a merged column of data by its matching group identifier(s))
   

• TABULATE (make a two way table of counts from a row and a column variable)

• DETABULATE (expand a table of counts into a row and column variables)