Display all layers in a custom table

[spruce18b]

I have created a custom table in three dimensions using the code below. Each layer of RACE is shown in a pivot table as a separate display by clicking on a drop down menu. Could someone please tell me how to show the entire table with all the layers shown together in one display? Thanks, Bill

GET   FILE='C:\Program Files (x86)\IBM\SPSS\Statistics\19\Samples\English\survey_sample.sav'.
SORT VARIABLES BY NAME (A).
* Custom Tables.
CTABLES
  /VLABELS VARIABLES=agecat DISPLAY=BOTH  /VLABELS VARIABLES=tvhours DISPLAY=LABEL
  /TABLE agecat [C] BY tvhours [S][MEDIAN, MEAN] by race
  /CATEGORIES VARIABLES=agecat ORDER=A KEY=VALUE EMPTY=INCLUDE MISSING=EXCLUDE
  /TITLES
    TITLE='Average Daily Number of Hours of Television Watched by Age Category.'.

[Anthony Babinec]

Was this answered? The following should get you close.
Note the /table subcommand.

* Custom Tables.
CTABLES
  /VLABELS VARIABLES=race agecat tvhours DISPLAY=DEFAULT
  /TABLE race > agecat BY tvhours [MEAN F40.1, MEDIAN F40.1]
  /CATEGORIES VARIABLES=race agecat ORDER=A KEY=VALUE EMPTY=INCLUDE
MISSING=EXCLUDE.

Tony Babinec
[hidden email]


-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of
spruce18b
Sent: Saturday, March 12, 2011 5:57 PM
To: [hidden email]
Subject: Display all layers in a custom table

I have created a custom table in three dimensions using the code below. Each
layer of RACE is shown in a pivot table as a separate display by clicking on
a drop down menu. Could someone please tell me how to show the entire table
with all the layers shown together in one display? Thanks, Bill

GET   FILE='C:\Program Files
(x86)\IBM\SPSS\Statistics\19\Samples\English\survey_sample.sav'.
SORT VARIABLES BY NAME (A).
* Custom Tables.
CTABLES
  /VLABELS VARIABLES=agecat DISPLAY=BOTH  /VLABELS VARIABLES=tvhours
DISPLAY=LABEL
  /TABLE agecat [C] BY tvhours [S][MEDIAN, MEAN] by race
  /CATEGORIES VARIABLES=agecat ORDER=A KEY=VALUE EMPTY=INCLUDE
MISSING=EXCLUDE
  /TITLES
    TITLE='Average Daily Number of Hours of Television Watched by Age
Category.'.


--
View this message in context:
http://spssx-discussion.1045642.n5.nabble.com/Display-all-layers-in-a-custom
-table-tp3537890p3537890.html
Sent from the SPSSX Discussion mailing list archive at Nabble.com.

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command SIGNOFF SPSSX-L For a list of
commands to manage subscriptions, send the command INFO REFCARD

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD