Collapsing Small Categories (GPL)

If you are creating a graph with several, small categories (that is, categories with a small sum), you may want to collapse those categories into a larger, common category. Following is an example that collapses small categories in a pie chart.

Figure 1. GPL for collapsing small categories

* Open sample file Employee Data.sav.
GGRAPH
  /GRAPHDATASET NAME="graphdataset" VARIABLES=educ salary
  /GRAPHSPEC SOURCE=INLINE.
BEGIN GPL
  SOURCE: s=userSource(id("graphdataset"))
  DATA: educ = col(source(s), name("educ"), unit.category())
  DATA: salary = col(source(s), name("salary"))
  TRANS: educ_collapsed = collapse(category(educ), minimumPercent(5.0), 
                                   sumVariable(salary), otherValue("Other"))
  COORD: polar.theta()
  SCALE: linear(dim(1), dataMinimum(), dataMaximum())
  GUIDE: axis(dim(1), null())
  GUIDE: legend(aesthetic(aesthetic.color.interior), 
                          label("Educational Level (years)"))
  ELEMENT: interval.stack(position(summary.sum(salary)), 
                          color.interior(educ_collapsed))
END GPL.