Re: Custom Tables - Suppressing Rows based on a condition

Posted by Jon K Peck on
URL: http://spssx-discussion.165.s1.nabble.com/Custom-Tables-Suppressing-Rows-based-on-a-condition-tp5727353p5727358.html

I only see three columns in your table image, but leaving that aside, HIDESMALLCOUNTS applies to individual cells, not entire rows.
You can do this, however, using the SPSSINC CENSOR TABLE extension command.  Here is an example using the employee data.sav file shipped with Statistics.  All the syntax was pasted from the dialogs.

CTABLES
  /VLABELS VARIABLES=jobcat salary DISPLAY=DEFAULT
  /TABLE jobcat BY salary [MEAN, COUNT F40.0]
  /CATEGORIES VARIABLES=jobcat ORDER=A KEY=VALUE EMPTY=INCLUDE MISSING=EXCLUDE.

SPSSINC CENSOR TABLES
CRITLABEL="Count" TESTTYPE="<" CRITVALUE=30
DIRECTION=ROW NEIGHBORS=0 -1
SUBTYPE="custom table"
/OPTIONS APPENDCAPTION=YES CONDITIONALCAPTION=YES
SYMBOL="---".

It does not remove the row, but it replaces all the cell statistics with ---.

Jon Peck (no "h") aka Kim
Senior Software Engineer, IBM
[hidden email]
phone: [phone]




From:        Schwarzerzander <[hidden email]>
To:        [hidden email]
Date:        09/22/2014 07:03 PM
Subject:        [SPSSX-L] Custom Tables - Suppressing Rows based on a condition
Sent by:        "SPSSX(r) Discussion" <[hidden email]>

---

When using Custom tables in SPSS, I cannot hide small counts when using a
subcategory as a break variable. i tried to use the *censor table* option in
spss, but it doesnt suppress the rows, i am probably using the wrong
instructions.  another option would be to use *modify table*. but the same
outcome, it doesnt do anything

i would like to suppress all the rows where the cell shows a value less than
100 in column 4.

 <http://spssx-discussion.1045642.n5.nabble.com/file/n5727353/ct.jpg>

Thank you very much for your help.

Steve



--
View this message in context: http://spssx-discussion.1045642.n5.nabble.com/Custom-Tables-Suppressing-Rows-based-on-a-condition-tp5727353.html
Sent from the SPSSX Discussion mailing list archive at 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


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