I am using the the coffee.sav dataset, this is the syntax to recreate where i am currently at.
Recode brand (1=1) (ELSE=0) into AA.
exe.
Var lab AA 'Brand AA'.
Val lab AA 0'0'
1'AA'.
* Custom Tables.
CTABLES
/VLABELS VARIABLES=image AA DISPLAY=DEFAULT
/TABLE image [C] BY AA [C][ROWPCT.COUNT PCT40.1]
/CATEGORIES VARIABLES=image AA ORDER=A KEY=VALUE EMPTY=INCLUDE
/CRITERIA CILEVEL=95.
* Custom Tables.
CTABLES
/VLABELS VARIABLES=image brand DISPLAY=DEFAULT
/TABLE image BY brand [ROWPCT.COUNT PCT40.1]
/CATEGORIES VARIABLES=image brand ORDER=A KEY=VALUE EMPTY=INCLUDE
/CRITERIA CILEVEL=95.
I want to be able to easily hide a value from my output, for example: Hide 0 in variable AA but it still counting in the calculation.
Or in the second table hide values CC and DD but still receive the same percentages.
Is there an easy way to do this directly in the custom table?
------------------------------
Joachim Mohn Raanaas
------------------------------
#SPSSStatistics