Highlight Small base values below 30 in Ctables

[jagadishpchary]

Dear All,

I need to provide * in the Ctables wherever the base is less than 30. Could
you please let me know if there any option in CTables to provide starmark
(*) above the value.

Many thanks for the help in advance.

Regards,
Jagadish



--
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 Peck]

If you want to hide small count cells, you can use something like

  /HIDESMALLCOUNTS COUNT=5

The SPSSINC CENSOR TABLES extension command provides more flexible censoring, but it still replaces the values with the  censoring symbol.

SPSSINC CENSOR TABLES

CRITLABEL="Count"  TESTTYPE="<" CRITVALUE=30

DIRECTION=ROW NEIGHBORS=0

SUBTYPE="customtable" PROCESS=LATEST

/OPTIONS APPENDCAPTION=YES CONDITIONALCAPTION=YES

CAPTION= "less than 30"

SYMBOL="*".

You could add a footnote or insert a * using a small custom function with the SPSSINC MODIFY TABLES extension  command.  Details if that's  what  you want to do.

On Thu, Oct 8, 2020 at 9:20 AM jagadishpchary <[hidden email]> wrote:

Dear All,

I need to provide * in the Ctables wherever the base is less than 30. Could
you please let me know if there any option in CTables to provide starmark
(*) above the value.

Many thanks for the help in advance.

Regards,
Jagadish



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

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

[jagadishpchary]

Hi Jon,

Thanks for the code.

However when I run the code it says 'LATEST is not a valid option for
keyword PROCESS'.
Could you please run the table highlighting the small values for me to
understand executing the code?

Regards,
Jagadish



--
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 Peck]

Change PROCESS=LATEST to PROCESS=PRECEDING.

On Thu, Oct 8, 2020 at 11:00 AM Jon Peck <[hidden email]> wrote:

If you want to hide small count cells, you can use something like

  /HIDESMALLCOUNTS COUNT=5

The SPSSINC CENSOR TABLES extension command provides more flexible censoring, but it still replaces the values with the  censoring symbol.

SPSSINC CENSOR TABLES

CRITLABEL="Count"  TESTTYPE="<" CRITVALUE=30

DIRECTION=ROW NEIGHBORS=0

SUBTYPE="customtable" PROCESS=LATEST

/OPTIONS APPENDCAPTION=YES CONDITIONALCAPTION=YES

CAPTION= "less than 30"

SYMBOL="*".

You could add a footnote or insert a * using a small custom function with the SPSSINC MODIFY TABLES extension  command.  Details if that's  what  you want to do.

On Thu, Oct 8, 2020 at 9:20 AM jagadishpchary <[hidden email]> wrote:

Dear All,

I need to provide * in the Ctables wherever the base is less than 30. Could
you please let me know if there any option in CTables to provide starmark
(*) above the value.

Many thanks for the help in advance.

Regards,
Jagadish



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

[Jon Peck]

If you just want to highlight the small cells, you can use SPSSINC MODIFY TABLES.  This code would color the background of small count cells.

SPSSINC MODIFY TABLES subtype="CUSTOMTABLE"

SELECT=Count 

DIMENSION= COLUMNS LEVEL = -1  SIGLEVELS=BOTH 

PROCESS = PRECEDING 

/STYLES  APPLYTO="x < 30"

BACKGROUNDCOLOR=255 255 0.

On Fri, Oct 9, 2020 at 6:40 AM Jon Peck <[hidden email]> wrote:

Change PROCESS=LATEST to PROCESS=PRECEDING.

On Thu, Oct 8, 2020 at 11:00 AM Jon Peck <[hidden email]> wrote:

If you want to hide small count cells, you can use something like

  /HIDESMALLCOUNTS COUNT=5

The SPSSINC CENSOR TABLES extension command provides more flexible censoring, but it still replaces the values with the  censoring symbol.

SPSSINC CENSOR TABLES

CRITLABEL="Count"  TESTTYPE="<" CRITVALUE=30

DIRECTION=ROW NEIGHBORS=0

SUBTYPE="customtable" PROCESS=LATEST

/OPTIONS APPENDCAPTION=YES CONDITIONALCAPTION=YES

CAPTION= "less than 30"

SYMBOL="*".

You could add a footnote or insert a * using a small custom function with the SPSSINC MODIFY TABLES extension  command.  Details if that's  what  you want to do.

On Thu, Oct 8, 2020 at 9:20 AM jagadishpchary <[hidden email]> wrote:

Dear All,

I need to provide * in the Ctables wherever the base is less than 30. Could
you please let me know if there any option in CTables to provide starmark
(*) above the value.

Many thanks for the help in advance.

Regards,
Jagadish



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

--

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