Posted by
Ki Park on
Sep 27, 2018; 8:16pm
URL: http://spssx-discussion.165.s1.nabble.com/Coloring-the-tables-based-on-sig-t-tp5736722p5736730.html
Hi Jon,
I have been following these two threads and when I use this code, to
"MERGE=YES" when making the Ctable, the MODIFY TABLE does not work.
CTABLES
/VLABELS VARIABLES=income age DISPLAY=NONE
/TABLE income [C][COLPCT.COUNT PCT40.1] by age
/SLABELS POSITION=ROW
/CATEGORIES VARIABLES=income age ORDER=A KEY=VALUE EMPTY=INCLUDE
MISSING=EXCLUDE
/CRITERIA CILEVEL=95
/COMPARETEST TYPE=PROP ALPHA=0.05 ADJUST=BONFERRONI ORIGIN=COLUMN
INCLUDEMRSETS=YES
CATEGORIES=ALLVISIBLE MERGE=YES STYLE=SIMPLE SHOWSIG=no.
SPSSINC MODIFY TABLES subtype="CustomTable" SELECT="<<ALL>>" DIMENSION=
COLUMNS PROCESS = PRECEDING
/STYLES APPLYTO=DATACELLS
CUSTOMFUNCTION="customstylefunctions.colorIfEndsWithAtoZLetter(r=255,g=0,b=0)".
It works when you do in 'steps' like this.
CTABLES
/VLABELS VARIABLES=income age DISPLAY=NONE
/TABLE income [C][COLPCT.COUNT PCT40.1] by age
/SLABELS POSITION=ROW
/CATEGORIES VARIABLES=income age ORDER=A KEY=VALUE EMPTY=INCLUDE
MISSING=EXCLUDE
/CRITERIA CILEVEL=95
/COMPARETEST TYPE=PROP ALPHA=0.05 ADJUST=BONFERRONI ORIGIN=COLUMN
INCLUDEMRSETS=YES
CATEGORIES=ALLVISIBLE MERGE=no SHOWSIG=no.
SPSSINC MERGE TABLES MATCHLABEL="Column N %" ATTACH=rows MODE=MERGE
/OPTIONS HIDE=no APPENDTITLE=No APPENDCAPTION=Yes ADDLABELLEAF=Yes
HALIGN=RIGHT SEPARATOR="\n" .
SPSSINC MODIFY TABLES subtype="CustomTable" SELECT="<<ALL>>" DIMENSION=
COLUMNS PROCESS = PRECEDING
/STYLES APPLYTO=DATACELLS
CUSTOMFUNCTION="customstylefunctions.colorIfEndsWithAtoZLetter(r=255,g=0,b=0)".
I am just curious why is this first combination does not work.
Ki
--
Sent from:
http://spssx-discussion.1045642.n5.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