Tables with Layers

[Jon K Peck]

Pivot tables can have rows, columns, and, a third dimension, layers.  Run this syntax using employee data.sav to see what this looks like.  Double click the resulting table to see how to work with layers.

CTABLES
  /TABLE educ [C] BY gender [C] > salary [S][MEAN] BY jobcat [C].

If you are using the CTABLES gui, click the Layers control at the top to open an area for specifying the layer variable(s).

When you export the table from the Viewer via File > Export you can choose to export each layer (category value) as a separate table.


Jon Peck (no "h") aka Kim
Senior Software Engineer, IBM
[hidden email]
phone: [phone]