SPSS Statistics

Hi,

I am looking for a way to highlight cells (or give cells a different background color) which are significant (marked with A,B,C,D,E and so on).

So far I cannot figure out how to do this and I hope it can be done because it makes it more uncluttered for the client to read the table.

I attached a .sav and .spss syntax file with which you can run our tables. Also attache an output file .spv  and an .jpg image file in which I clarify what the intention is.


------------------------------
Michel de Graaf
------------------------------

#SPSSStatistics

Hi. Check the OUTPUT MODIFY command. That will highlight cells in the output if you want.

------------------------------
Rick Marcantonio
Quality Assurance
IBM
------------------------------

Original Message:
Sent: Tue March 15, 2022 05:30 AM
From: Michel de Graaf
Subject: Highlight cells with significance

Hi,

I am looking for a way to highlight cells (or give cells a different background color) which are significant (marked with A,B,C,D,E and so on).

So far I cannot figure out how to do this and I hope it can be done because it makes it more uncluttered for the client to read the table.

I attached a .sav and .spss syntax file with which you can run our tables. Also attache an output file .spv  and an .jpg image file in which I clarify what the intention is.


------------------------------
Michel de Graaf
------------------------------

#SPSSStatistics

Hi,

I tried this. But strange enought only the last table is highlighted and not the tables at the beginning.

This is my table macro syntax:

DEFINE singresp (!POS !CHAREND('/')).
!DO !i !IN ( !1).
CTABLES
/VLABELS VARIABLES=ALL DISPLAY=DEFAULT
/TABLE !i [C] BY totaal [C][COUNT 'Abs' F40.0, COLPCT.COUNT '%' PCT40.1]
+ kruisa [C][COUNT 'Abs' F40.0, COLPCT.COUNT '%' PCT40.1]
+ kruisb [C][COUNT 'Abs' F40.0, COLPCT.COUNT '%' PCT40.1]
/SLABELS POSITION=ROW
/CATEGORIES VARIABLES=!i ORDER=A KEY=VALUE EMPTY=EXCLUDE TOTAL=YES POSITION=AFTER MISSING=EXCLUDE
/CATEGORIES VARIABLES=totaal kruisa kruisb
ORDER=A KEY=VALUE EMPTY=INCLUDE
/CRITERIA CILEVEL=95
/COMPARETEST TYPE=PROP ALPHA=0.05 ADJUST=BONFERRONI ORIGIN=COLUMN INCLUDEMRSETS=YES
CATEGORIES=ALLVISIBLE MERGE=YES STYLE=SIMPLE SHOWSIG=NO
/TITLES
TITLE="test"
CAPTION='2022'.
!DOEND.
!ENDDEFINE.

And the I run for example 3 tables:


singresp $A10mr A11 A8/.

And the I run this:

SPSSINC MODIFY TABLES subtype="customtable"SELECT="<<ALL>>"
DIMENSION= COLUMNS LEVEL = -1 SIGCELLS=ALLSIG SIGLEVELS=BOTH
PROCESS = PRECEDING
/STYLES APPLYTO=DATACELLS
BACKGROUNDCOLOR=255 255 0.

And the only the table from A8 is highlighted and not $A10mr and A11.

I already tried this:

singresp $A10mr/.
singresp A11/.
singresp A8/.

But then alos A8 is the only table that is getting highlighted.

------------------------------
Michel de Graaf
------------------------------

Original Message:
Sent: Tue March 15, 2022 11:27 AM
From: Rick Marcantonio
Subject: Highlight cells with significance

Hi. Check the OUTPUT MODIFY command. That will highlight cells in the output if you want.

------------------------------
Rick Marcantonio
Quality Assurance
IBM

Original Message:
Sent: Tue March 15, 2022 05:30 AM
From: Michel de Graaf
Subject: Highlight cells with significance

Hi,

I am looking for a way to highlight cells (or give cells a different background color) which are significant (marked with A,B,C,D,E and so on).

So far I cannot figure out how to do this and I hope it can be done because it makes it more uncluttered for the client to read the table.

I attached a .sav and .spss syntax file with which you can run our tables. Also attache an output file .spv  and an .jpg image file in which I clarify what the intention is.


------------------------------
Michel de Graaf
------------------------------

#SPSSStatistics

There is a syntax control to select all output or only the last. Let me look that up.

------------------------------
Rick Marcantonio
Quality Assurance
IBM
------------------------------

Original Message:
Sent: Tue March 15, 2022 11:42 AM
From: Michel de Graaf
Subject: Highlight cells with significance

Hi,

I tried this. But strange enought only the last table is highlighted and not the tables at the beginning.

This is my table macro syntax:

DEFINE singresp (!POS !CHAREND('/')).
!DO !i !IN ( !1).
CTABLES
/VLABELS VARIABLES=ALL DISPLAY=DEFAULT
/TABLE !i [C] BY totaal [C][COUNT 'Abs' F40.0, COLPCT.COUNT '%' PCT40.1]
+ kruisa [C][COUNT 'Abs' F40.0, COLPCT.COUNT '%' PCT40.1]
+ kruisb [C][COUNT 'Abs' F40.0, COLPCT.COUNT '%' PCT40.1]
/SLABELS POSITION=ROW
/CATEGORIES VARIABLES=!i ORDER=A KEY=VALUE EMPTY=EXCLUDE TOTAL=YES POSITION=AFTER MISSING=EXCLUDE
/CATEGORIES VARIABLES=totaal kruisa kruisb
ORDER=A KEY=VALUE EMPTY=INCLUDE
/CRITERIA CILEVEL=95
/COMPARETEST TYPE=PROP ALPHA=0.05 ADJUST=BONFERRONI ORIGIN=COLUMN INCLUDEMRSETS=YES
CATEGORIES=ALLVISIBLE MERGE=YES STYLE=SIMPLE SHOWSIG=NO
/TITLES
TITLE="test"
CAPTION='2022'.
!DOEND.
!ENDDEFINE.

And the I run for example 3 tables:


singresp $A10mr A11 A8/.

And the I run this:

SPSSINC MODIFY TABLES subtype="customtable"SELECT="<<ALL>>"
DIMENSION= COLUMNS LEVEL = -1 SIGCELLS=ALLSIG SIGLEVELS=BOTH
PROCESS = PRECEDING
/STYLES APPLYTO=DATACELLS
BACKGROUNDCOLOR=255 255 0.

And the only the table from A8 is highlighted and not $A10mr and A11.

I already tried this:

singresp $A10mr/.
singresp A11/.
singresp A8/.

But then alos A8 is the only table that is getting highlighted.

------------------------------
Michel de Graaf

Original Message:
Sent: Tue March 15, 2022 11:27 AM
From: Rick Marcantonio
Subject: Highlight cells with significance

Hi. Check the OUTPUT MODIFY command. That will highlight cells in the output if you want.

------------------------------
Rick Marcantonio
Quality Assurance
IBM

Original Message:
Sent: Tue March 15, 2022 05:30 AM
From: Michel de Graaf
Subject: Highlight cells with significance

Hi,

I am looking for a way to highlight cells (or give cells a different background color) which are significant (marked with A,B,C,D,E and so on).

So far I cannot figure out how to do this and I hope it can be done because it makes it more uncluttered for the client to read the table.

I attached a .sav and .spss syntax file with which you can run our tables. Also attache an output file .spv  and an .jpg image file in which I clarify what the intention is.


------------------------------
Michel de Graaf
------------------------------

#SPSSStatistics

Original Message:
Sent: 3/15/2022 11:43:00 AM
From: Rick Marcantonio
Subject: RE: Highlight cells with significance

There is a syntax control to select all output or only the last. Let me look that up.

------------------------------
Rick Marcantonio
Quality Assurance
IBM
------------------------------

Original Message:
Sent: Tue March 15, 2022 11:42 AM
From: Michel de Graaf
Subject: Highlight cells with significance

Hi,

I tried this. But strange enought only the last table is highlighted and not the tables at the beginning.

This is my table macro syntax:

DEFINE singresp (!POS !CHAREND('/')).
!DO !i !IN ( !1).
CTABLES
/VLABELS VARIABLES=ALL DISPLAY=DEFAULT
/TABLE !i [C] BY totaal [C][COUNT 'Abs' F40.0, COLPCT.COUNT '%' PCT40.1]
+ kruisa [C][COUNT 'Abs' F40.0, COLPCT.COUNT '%' PCT40.1]
+ kruisb [C][COUNT 'Abs' F40.0, COLPCT.COUNT '%' PCT40.1]
/SLABELS POSITION=ROW
/CATEGORIES VARIABLES=!i ORDER=A KEY=VALUE EMPTY=EXCLUDE TOTAL=YES POSITION=AFTER MISSING=EXCLUDE
/CATEGORIES VARIABLES=totaal kruisa kruisb
ORDER=A KEY=VALUE EMPTY=INCLUDE
/CRITERIA CILEVEL=95
/COMPARETEST TYPE=PROP ALPHA=0.05 ADJUST=BONFERRONI ORIGIN=COLUMN INCLUDEMRSETS=YES
CATEGORIES=ALLVISIBLE MERGE=YES STYLE=SIMPLE SHOWSIG=NO
/TITLES
TITLE="test"
CAPTION='2022'.
!DOEND.
!ENDDEFINE.

And the I run for example 3 tables:


singresp $A10mr A11 A8/.

And the I run this:

SPSSINC MODIFY TABLES subtype="customtable"SELECT="<<ALL>>"
DIMENSION= COLUMNS LEVEL = -1 SIGCELLS=ALLSIG SIGLEVELS=BOTH
PROCESS = PRECEDING
/STYLES APPLYTO=DATACELLS
BACKGROUNDCOLOR=255 255 0.

And the only the table from A8 is highlighted and not $A10mr and A11.

I already tried this:

singresp $A10mr/.
singresp A11/.
singresp A8/.

But then alos A8 is the only table that is getting highlighted.

------------------------------
Michel de Graaf

Original Message:
Sent: Tue March 15, 2022 11:27 AM
From: Rick Marcantonio
Subject: Highlight cells with significance

Hi. Check the OUTPUT MODIFY command. That will highlight cells in the output if you want.

------------------------------
Rick Marcantonio
Quality Assurance
IBM

Original Message:
Sent: Tue March 15, 2022 05:30 AM
From: Michel de Graaf
Subject: Highlight cells with significance

Hi,

I am looking for a way to highlight cells (or give cells a different background color) which are significant (marked with A,B,C,D,E and so on).

So far I cannot figure out how to do this and I hope it can be done because it makes it more uncluttered for the client to read the table.

I attached a .sav and .spss syntax file with which you can run our tables. Also attache an output file .spv  and an .jpg image file in which I clarify what the intention is.


------------------------------
Michel de Graaf
------------------------------

#SPSSStatistics

Thank you! That causes the problem.

------------------------------
Michel de Graaf
------------------------------

Original Message:
Sent: Tue March 15, 2022 11:46 AM
From: Jon Peck
Subject: Highlight cells with significance

You have PROCESS = PRECEDING

Use PROCESS=ALL to do all tables of the specified type(s).

--

Jon K Peck
jkpeck@gmail.com

Original Message:
Sent: 3/15/2022 11:43:00 AM
From: Rick Marcantonio
Subject: RE: Highlight cells with significance

There is a syntax control to select all output or only the last. Let me look that up.

------------------------------
Rick Marcantonio
Quality Assurance
IBM

Original Message:
Sent: Tue March 15, 2022 11:42 AM
From: Michel de Graaf
Subject: Highlight cells with significance

Hi,

I tried this. But strange enought only the last table is highlighted and not the tables at the beginning.

This is my table macro syntax:

DEFINE singresp (!POS !CHAREND('/')).
!DO !i !IN ( !1).
CTABLES
/VLABELS VARIABLES=ALL DISPLAY=DEFAULT
/TABLE !i [C] BY totaal [C][COUNT 'Abs' F40.0, COLPCT.COUNT '%' PCT40.1]
+ kruisa [C][COUNT 'Abs' F40.0, COLPCT.COUNT '%' PCT40.1]
+ kruisb [C][COUNT 'Abs' F40.0, COLPCT.COUNT '%' PCT40.1]
/SLABELS POSITION=ROW
/CATEGORIES VARIABLES=!i ORDER=A KEY=VALUE EMPTY=EXCLUDE TOTAL=YES POSITION=AFTER MISSING=EXCLUDE
/CATEGORIES VARIABLES=totaal kruisa kruisb
ORDER=A KEY=VALUE EMPTY=INCLUDE
/CRITERIA CILEVEL=95
/COMPARETEST TYPE=PROP ALPHA=0.05 ADJUST=BONFERRONI ORIGIN=COLUMN INCLUDEMRSETS=YES
CATEGORIES=ALLVISIBLE MERGE=YES STYLE=SIMPLE SHOWSIG=NO
/TITLES
TITLE="test"
CAPTION='2022'.
!DOEND.
!ENDDEFINE.

And the I run for example 3 tables:


singresp $A10mr A11 A8/.

And the I run this:

SPSSINC MODIFY TABLES subtype="customtable"SELECT="<<ALL>>"
DIMENSION= COLUMNS LEVEL = -1 SIGCELLS=ALLSIG SIGLEVELS=BOTH
PROCESS = PRECEDING
/STYLES APPLYTO=DATACELLS
BACKGROUNDCOLOR=255 255 0.

And the only the table from A8 is highlighted and not $A10mr and A11.

I already tried this:

singresp $A10mr/.
singresp A11/.
singresp A8/.

But then alos A8 is the only table that is getting highlighted.

------------------------------
Michel de Graaf

Original Message:
Sent: Tue March 15, 2022 11:27 AM
From: Rick Marcantonio
Subject: Highlight cells with significance

Hi. Check the OUTPUT MODIFY command. That will highlight cells in the output if you want.

------------------------------
Rick Marcantonio
Quality Assurance
IBM

Original Message:
Sent: Tue March 15, 2022 05:30 AM
From: Michel de Graaf
Subject: Highlight cells with significance

Hi,

I am looking for a way to highlight cells (or give cells a different background color) which are significant (marked with A,B,C,D,E and so on).

So far I cannot figure out how to do this and I hope it can be done because it makes it more uncluttered for the client to read the table.

I attached a .sav and .spss syntax file with which you can run our tables. Also attache an output file .spv  and an .jpg image file in which I clarify what the intention is.


------------------------------
Michel de Graaf
------------------------------

#SPSSStatistics

Original Message:
Sent: 3/15/2022 11:28:00 AM
From: Rick Marcantonio
Subject: RE: Highlight cells with significance

Hi. Check the OUTPUT MODIFY command. That will highlight cells in the output if you want.

------------------------------
Rick Marcantonio
Quality Assurance
IBM
------------------------------

Original Message:
Sent: Tue March 15, 2022 05:30 AM
From: Michel de Graaf
Subject: Highlight cells with significance

Hi,

I am looking for a way to highlight cells (or give cells a different background color) which are significant (marked with A,B,C,D,E and so on).

So far I cannot figure out how to do this and I hope it can be done because it makes it more uncluttered for the client to read the table.

I attached a .sav and .spss syntax file with which you can run our tables. Also attache an output file .spv  and an .jpg image file in which I clarify what the intention is.


------------------------------
Michel de Graaf
------------------------------

#SPSSStatistics