SPSSX Discussion - Re: Coloring the tables based on sig t

Re: Coloring the tables based on sig t

Posted by Jon Peck on Sep 27, 2018; 9:06pm
URL: http://spssx-discussion.165.s1.nabble.com/Coloring-the-tables-based-on-sig-t-tp5736722p5736732.html

When you display the significance indicators directly with CTABLES (MERGE=YES STYLE=SIMPLE), the cells are actually different from the two table version with the merging by MERGE TABLES even though they look about the same. The significance indicator is sort of a superscript rather than a value in the cell. You will see this if you double click a cell with a marker in the pivot table editor.

The MODIFY TABLES custom function works on letters that are actually present in the cells as regular text, and it doesn't find any of these.

Of course, you don't need that function in this case, since the indicators already appear in the cells, but you can use new functionality in MODIFY TABLES as of V24 to format these cells. From the syntax help...

SIGLEVELS This keyword narrows the selection made on the main dialog to those cells that meet the significance criteria specified here. In most cases, the significance criteria would be used with the "<<ALL>>" selection specification, but if there is a subset selected there, the significance specifications are applied within that.

This keyword applies only to Statistics version 24 or later and to output from Custom Tables (CTABLES) where significance markers are shown in the main table and are the simple (not APA) type.

ALLSIG selects all cells with any significance marker. Significance markers are special letter codes that appear in the cell

Alternatively, you can specify the specific significance markers to be selected by entering a significance pattern. The pattern can be a simple list of the column markers. For example, "AB" would select only cells where columns lettered A or B are listed as significantly different. The letter codes are shown in the column headers when significance results are merged rather than being shown in a separate table. You might use this when you want to focus on a few specific categories.

Subtables across the columns occur when the column dimension has a nested specification such as job category within gender (gender > jobcat), or when there are multiple categorical variables stacked in that dimension (jobcat + gender). You can further specify which subtables the selection applies to by listing the subtable numbers after each letter code. For example, A01B2 indicates that only A-significant cells should be selected in subtables 0 and 1 and only B-significant codes should be selected in subtable 2. You can identify subtables in the output, because the column lettering for significance restarts from (A) across the table for each subtable.

In a nested table, the innermost dimension repeats, so you would probably want the selection to apply across all the nested subtables. However, if variables are stacked across the columns, the meaning of the significance letters will be different in each subtable, and you might want the selection to apply only to particular subtables.

Subtable numbering starts from 0. Up to ten subtables can be referenced using this notation.

SIGLEVELS specifies which significance levels should be selected. One or two significance levels can be shown in a table. If there are two, the more significant values are indicated in upper case letters and the less significant in lower case. In selecting, you can specify that both levels are selected or that only one or the other is selected. If there is only one level in the table, choose BOTH or UPPER.

On Thu, Sep 27, 2018 at 2:16 PM Ki Park <[hidden email]> wrote:

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

Jon K Peck
[hidden email]

===================== 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