Suppresing Cells in Tables

[Jason Schoeneberger]

Does anyone know of a way to suppress cells, or make them blank in a table when you have a small sample size?  I’m generating a number of Custom Tables, but we’re required to not show cells that are based on less than 10 cases? 

 

Thanks,

 

Jason

[Peck, Jon]

There is an extension command SPSSINC CENSOR TABLES that can do this.  You can download it from SPSS Developer Central (www.spss.com/devcentral).  It requires the Python plugin.  See the specifics on the modules for SPSS version requirements.

 

With version 17, the package includes a dialog box interface as well as traditional SPSS syntax.  Here is a usage example.

 

SPSSINC CENSOR TABLES

CRITLABEL="Count" TESTTYPE="<" CRITVALUE=5

DIRECTION=ROW NEIGHBORS=1

SUBTYPE="custom table"

/OPTIONS

SYMBOL=" ".

 

This says to blank out the cell to the right of the "count" statistics if the cell count is less than 5.

 

HTH,

Jon Peck

 

---

From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Jason Schoeneberger
Sent: Tuesday, March 31, 2009 5:50 PM
To: [hidden email]
Subject: [SPSSX-L] Suppresing Cells in Tables

 

Does anyone know of a way to suppress cells, or make them blank in a table when you have a small sample size?  I’m generating a number of Custom Tables, but we’re required to not show cells that are based on less than 10 cases? 

 

Thanks,

 

Jason

[Albert-Jan Roskam]

Hi Jon,

That's a very interesting and useful module. It is possible to blank out cells below a certain size to prevent individuals from being disclosed/revealed. But is it also able to prevent *groups* from being reveiled? I mean: a cell size can be very large, but if the SD is very small, one would still know the value of the given stratum.

Best wishes,
Albert-Jan


--- On Wed, 4/1/09, Peck, Jon <[hidden email]> wrote:

> From: Peck, Jon <[hidden email]>
> Subject: Re: Suppressing Cells in Tables
> To: [hidden email]
> Date: Wednesday, April 1, 2009, 2:34 AM
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> There is an
> extension command SPSSINC CENSOR TABLES that can do this.
> � You can
> download it from SPSS Developer Central (www.spss.com/devcentral).
> � It
> requires the Python plugin.�  See the specifics on the
> modules for SPSS
> version requirements.
>
>  �
>
> With version 17,
> the package includes a dialog box interface as well as
> traditional SPSS syntax.
> � Here is a usage example.
>
>  �
>
> SPSSINC CENSOR
> TABLES
>
> CRITLABEL="Count"
> TESTTYPE="<" CRITVALUE=5
>
> DIRECTION=ROW
> NEIGHBORS=1
>
> SUBTYPE="custom
> table"
>
> /OPTIONS
>
> SYMBOL="
> ".
>
>  �
>
> This says to
> blank out the cell to the right of the "count"
> statistics if the cell
> count is less than 5.
>
>  �
>
> HTH,
>
> Jon Peck
>
>  �
>
>
>
>
>
>
>
>
>
> From: SPSSX(r)
> Discussion [mailto:[hidden email]] On
> Behalf Of Jason Schoeneberger
>
> Sent:
> Tuesday, March 31, 2009 5:50
> PM
>
> To:
> [hidden email]
>
> Subject:
> [SPSSX-L] Suppresing
> Cells in Tables
>
>
>
>  �
>
> Does anyone know
> of a way to suppress cells, or make them blank
> in a table when you have a small sample size?�
> I’m generating a
> number of Custom Tables, but we’re required to not
> show cells that are
> based on less than 10 cases?�
>
>
> �
>
> Thanks,
>
>
>
> �
>
> Jason
>
>
>
>
>
>
>
>

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

[Peck, Jon]

The command is very general.  You choose a statistic and a criterion and specify which related cells should be blanked or replaced with a symbol of your choice.  The command does not know anything about the structure of the table.  You suppress a group of cells relative to the criterion cell.

Here is an extract from the dialog help.

In the field Label of Censoring Statistic, enter the text of the innermost level of the label for the row or column containing the censoring statistic.

Select the type of comparison to be done from the dropdown list. The test carried out is
abs(cell value) testtype critvalue.
For example, abs(cell count) < 5.

List the cells to be censored in the Neighboring rows or columns to censor field. The cells to be censored are indicated by their position relative to the censoring statistic. Negative numbers are to the left or above the censoring cell, and positive numbers are to the right or below that cell. Include 0 in the list to censor the censoring statistic itself.

For example, if a table has columns count, mean, standard deviation, you could censor the mean and standard deviation based on the count by entering
1 2
in the list.

-----Original Message-----
From: Albert-jan Roskam [mailto:[hidden email]]
Sent: Wednesday, April 01, 2009 1:53 AM
To: [hidden email]; Peck, Jon
Subject: Re: Suppressing Cells in Tables


Hi Jon,

That's a very interesting and useful module. It is possible to blank out cells below a certain size to prevent individuals from being disclosed/revealed. But is it also able to prevent *groups* from being reveiled? I mean: a cell size can be very large, but if the SD is very small, one would still know the value of the given stratum.

Best wishes,
Albert-Jan


--- On Wed, 4/1/09, Peck, Jon <[hidden email]> wrote:

> From: Peck, Jon <[hidden email]>
> Subject: Re: Suppressing Cells in Tables
> To: [hidden email]
> Date: Wednesday, April 1, 2009, 2:34 AM
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> There is an
> extension command SPSSINC CENSOR TABLES that can do this.
>  You can
> download it from SPSS Developer Central (www.spss.com/devcentral).
>  It
> requires the Python plugin.  See the specifics on the
> modules for SPSS
> version requirements.
>
>
>
> With version 17,
> the package includes a dialog box interface as well as
> traditional SPSS syntax.
>  Here is a usage example.
>
>
>
> SPSSINC CENSOR
> TABLES
>
> CRITLABEL="Count"
> TESTTYPE="<" CRITVALUE=5
>
> DIRECTION=ROW
> NEIGHBORS=1
>
> SUBTYPE="custom
> table"
>
> /OPTIONS
>
> SYMBOL="
> ".
>
>
>
> This says to
> blank out the cell to the right of the "count"
> statistics if the cell
> count is less than 5.
>
>
>
> HTH,
>
> Jon Peck
>
>
>
>
>
>
>
>
>
>
>
> From: SPSSX(r)
> Discussion [mailto:[hidden email]] On
> Behalf Of Jason Schoeneberger
>
> Sent:
> Tuesday, March 31, 2009 5:50
> PM
>
> To:
> [hidden email]
>
> Subject:
> [SPSSX-L] Suppresing
> Cells in Tables
>
>
>
>
>
> Does anyone know
> of a way to suppress cells, or make them blank
> in a table when you have a small sample size?
> I'm generating a
> number of Custom Tables, but we're required to not
> show cells that are
> based on less than 10 cases?
>
>
>
>
> Thanks,
>
>
>
>
>
> Jason
>
>
>
>
>
>
>
>

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