User manual SPSS TABLES 14.0

[. . . ] SPSS Tables 14. 0 TM For more information about SPSS® software products, please visit our Web site at http://www. spss. com or contact SPSS Inc. 233 South Wacker Drive, 11th Floor Chicago, IL 60606-6412 Tel: (312) 651-3000 Fax: (312) 651-3668 SPSS is a registered trademark and the other product names are the trademarks of SPSS Inc. No material describing such software may be produced or distributed without the written permission of the owners of the trademark and license rights in the software and the copyrights in the published materials. The SOFTWARE and documentation are provided with RESTRICTED RIGHTS. [. . . ] Layer variables do not affect the preview on the canvas pane unless the layer variable is the statistics source variable and you change the summary statistics. E Click OK to create the table. 90 Chapter 4 Figure 4-16 Simple layered table At first glance, this table doesn't look any different than a simple table of a single categorical variable. The only difference is the presence of the label Gender Male at the top of the table. E Double-click the table in the Viewer window to activate it. E You can now see that the label Gender Male is actually a choice in a drop-down list. E Click the down arrow on the drop-down list to display the whole list of layers. Figure 4-17 List of layers in activated pivot table In this table, there is only one other choice in the list. E Select Gender Female from the drop-down list. 91 Stacking, Nesting, and Layers with Categorical Variables Figure 4-18 Simple layered table with different layer displayed Two Stacked Categorical Layer Variables If you have more than one categorical variable in the layers, you can either stack or nest the layer variables. By default, layer variables are stacked. (Note: If you have any scale layer variables, layer variables can only be stacked. ) E Open the table builder (Analyze menu, Tables, Custom Tables). E If you don't already have Age category in the rows and Gender in the layers, follow the directions above for creating a layered table. E Drag and drop Highest degree from the variable list to the Layer list below Gender. 92 Chapter 4 Figure 4-19 Stacked layer variables in table builder The two radio buttons below the Layer list in the Layer Output group are now activated. The default selection is Show each category as a layer. This is equivalent to stacking. E Click OK to create the table. E Double-click the table in the Viewer window to activate it. E Click the down arrow on the drop-down list to display the whole list of layers. Figure 4-20 List of stacked layers in activated pivot table 93 Stacking, Nesting, and Layers with Categorical Variables There are seven layers in the table: two layers for the two Gender categories and five layers for the five Highest degree categories. For stacked layers, the total number of layers is the sum of the number of categories for the layer variables (including any total or subtotal categories you have requested for the layer variables). Two Nested Categorical Layer Variables Nesting categorical layer variables creates a separate layer for each combination of layer variable categories. E Open the table builder (Analyze menu, Tables, Custom Tables). E If you haven't done so already, follow the directions above for creating a table of stacked layers. E In the Layer Output group, select Show each combination of categories as a layer. This is equivalent to nesting. E Click OK to create the table. E Double-click the table in the Viewer window to activate it. E Click the down arrow on the drop-down list to display the whole list of layers. Figure 4-21 List of nested layers in activated pivot table There are 10 layers in the table (you have to scroll through the list to see all of them), one for each combination of Gender and Highest degree. For nested layers, the total number of layers is the product of the number of categories for each layer variable (in this example, 5 x 2 = 10). 94 Chapter 4 Printing Layered Tables By default, only the currently visible layer is printed. To print all layers of a table: E Double-click the table in the Viewer window to activate it. E From the Viewer window menus, choose: Format Table Properties. . . [. . . ] The original syntax file is not altered. Convert only TABLES commands in the syntax file. Other commands in the file are not altered. Retain the original TABLES syntax in commented form. [. . . ]