Automate highlighting Sig. differences in CTables?

[J P]

Hello,

I would like to devise a way to automate the highlighting (or something similar) statistically significant differences in CTables output. The current setup is to produce significance tests in a second table, then click on CTables to highlight rows where significant differences are located. My reports have well over 100 tables of 4-10 items per. So there is a lot of manual editing (and opportunity for human error).

A macro or script would be optimal. I've looked at Raynals SPSS tools/book and Krill's site but am not seeing anything that I can adapt.

Any assistance is greatly appreciated.

Thank you,

John

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

[Frans Marcelissen-4]

I suppose the spss extension MODIFY TABLE  is what you need. It has many features. 

An example is 

https://www.ibm.com/developerworks/community/blogs/ab16c38e-2f7b-4912-a47e-85682d124d32/entry/coloring_significance_in_spss_statistics_custom_tables_output?lang=en 

Frans

2015-08-13 16:43 GMT+02:00 J P <[hidden email]>:

Hello,

I would like to devise a way to automate the highlighting (or something similar) statistically significant differences in CTables output. The current setup is to produce significance tests in a second table, then click on CTables to highlight rows where significant differences are located. My reports have well over 100 tables of 4-10 items per. So there is a lot of manual editing (and opportunity for human error).

A macro or script would be optimal. I've looked at Raynals SPSS tools/book and Krill's site but am not seeing anything that I can adapt.

Any assistance is greatly appreciated.

Thank you,

John

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

[Jon K Peck]

There is a way to do this using extension commands.  It requires two steps.  First, merge the significance table into the main table using SPSSINC MERGE TABLES.  Second use SPSSINC MODIFY TABLES with the custom function customstylefunctions.colorIfEndsWithAtoZLetter

You could also write a script that would do this without merging, but usually people want both the indicator and the color.

I can provide more details if you want to go this way.


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




From:        J P <[hidden email]>
To:        [hidden email]
Date:        08/13/2015 08:43 AM
Subject:        [SPSSX-L] Automate highlighting Sig. differences in CTables?
Sent by:        "SPSSX(r) Discussion" <[hidden email]>

---

Hello,

I would like to devise a way to automate the highlighting (or something similar) statistically significant differences in CTables output. The current setup is to produce significance tests in a second table, then click on CTables to highlight rows where significant differences are located. My reports have well over 100 tables of 4-10 items per. So there is a lot of manual editing (and opportunity for human error).

A macro or script would be optimal. I've looked at Raynals SPSS tools/book and Krill's site but am not seeing anything that I can adapt.

Any assistance is greatly appreciated.

Thank you,
John
===================== To manage your subscription to SPSSX-L, send a message to LISTSERV@...(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