I tried it but think I not sure what the right "censor label" should be. I want it to not show the stat testing only. I used this syntax but it did not work. Thanks in Advance.
SPSSINC CENSOR TABLES
CRITLABEL="Significance Testing" TESTTYPE="<" CRITVALUE=30
DIRECTION=ROW NEIGHBORS=0 LABELOFFSET=0
SUBTYPE="'Custom Table'" PROCESS=PRECEDING
/OPTIONS APPENDCAPTION=YES CONDITIONALCAPTION=NO
SYMBOL="**".
------------------------------
Ratna Wynn
------------------------------
Original Message:
Sent: Thu January 23, 2025 04:10 PM
From: Jon Peck
Subject: Supressing Stat testing results from custom tables
That's not quite right, but a better solution would be SPSSINC CENSOR TABLES (Utilities > Censor Table) if you have the cell count in the table. You give it the censoring criterion row or column, the test value, the type of test (<), and the rows or columns to censor.relative to the censoring criterion cell. That will blank it out or substitute some symbol of your choice.
CENSOR TABLES is on the Extension Hub if you don't already have it.
--
Original Message:
Sent: 1/23/2025 3:33:00 PM
From: Ratna Wynn
Subject: RE: Supressing Stat testing results from custom tables
I am looking to suppress the test results for only those cells where the base size is less than 30. I tried to use the modify table function and would be ok if it just changed to red font the stat results where the base is small. The code I tried is below. But it did not seem to work.
SPSSINC MODIFY TABLES subtype="'Custom Table'"
SELECT='A' 'B' 'C'
REGEXP=YES DIMENSION=COLUMNS LEVEL = 0 SIGCELLS=ALLSIG SIGLEVELS=BOTH
PROCESS = ALL HIDE=NO
/STYLES APPLYTO="'Count' <30"
TEXTCOLOR=239 51 56
USEABS=NO HMSCALE=LINEAR.
------------------------------
Ratna Wynn
------------------------------
Original Message:
Sent: Thu January 23, 2025 12:20 PM
From: Jon Peck
Subject: Supressing Stat testing results from custom tables
Do you mean to omit particular cells from the proportion or means tests? There is no way to do that, and if you could, it would bias the results as the test sample input to the test would depend on the cells being tested.
If you mean to suppress the test results for the whole table, that could be done with some custom Python code, but if you have the test results in a separate table, you could just ignore them when appropriate.
--