SPSSINC MODIFY TABLES question

[Mario Giesel]

 

Hello, SPSS friends,

 

I experimented a bit with ex post table modification via SPSSINC MODIFY TABLES (SPSS V21).

Here's what I did:

 

* =================================================.

DATA LIST FREE (' ') / bought1 bought2 gender.
BEGIN DATA
1 1 1
1 0 1
1 1 2
1 0 2
9 1 2
END DATA.
VARIABLE LABELS bought1 "Bought product 1" / bought2 "Bought product 2" / gender "Gender".
VALUE LABELS bought1 bought2 0 'No' 1 'Yes' 9 'Question not received' / gender 1 "Male" 2 "Female".
MISSING VALUES bought1 bought2 (9).

CTABLES
  /VLABELS VARIABLES=bought1 bought2 DISPLAY=DEFAULT
  /TABLE (bought1  + bought2)[COUNT F40.0, ROWPCT.COUNT F40.1] BY gender
  /CLABELS ROWLABELS=OPPOSITE
  /CATEGORIES VARIABLES=bought1 bought2 ORDER=A KEY=VALUE EMPTY=INCLUDE MISSING=EXCLUDE.

* Color definition works.
SPSSINC MODIFY TABLES SUBTYPE="*"
SELECT = ["No"] DIMENSION=COLUMNS LEVEL = -2 PROCESS = ALL
/STYLES BACKGROUNDCOLOR=0 191 255.

* Hiding not.
SPSSINC MODIFY TABLES SUBTYPE="*"
SELECT = ["No"] DIMENSION=COLUMNS LEVEL = -2 HIDE = TRUE PROCESS = ALL.

* =================================================.

 

My goal is to remove redundant "No" categories from the table.

I succeed to color them. However, hiding them doesn't work.

Is there a way to do that also?

 

Thanks for any help,

  Mario