SPSSINC MODIFY TABLES

[Timothy Hennigar]

Ok – for various reasons I have been stuck in V14 land for what seems like forever … (12 years)

 

But with V24 and finally the STYLE=SIMPLE merge of significance test into CTables main table – I can now

try to move to V24 and forward for good.

 

With this I am similarly trying to move from my various old sbs scripts to take advantage of the many supplemental features

available in the extension commands and python functions contributed by many incl Jon. (THANKS SO MUCH!)

 

The first such application is

 

SPSSINC MODIFY TABLES with customstylefunctions.py – to remove the footnotes generated by the testing.

I copied the example in the function and modified Descriptives to 'Custom Table' and Process to ALL

and the following appears to work perfectly well.

 

*SPSSINC MODIFY TABLES subtype="'Custom Table'"

*SELECT=0

*DIMENSION= COLUMNS

*LEVEL = -1  PROCESS = ALL

*/STYLES  APPLYTO=DATACELLS

*CUSTOMFUNCTION="customstylefunctions.hideFootnotes".

 

 

The second application however seems more problematic.

I want to use the ‘reletter’ function to change the standard lettering provided by SPSS for the tests – again I copied the example

It already selected Custom Table so I Ieft that but changed Process to ALL (I was not sure of <<ALL>> - but left as is does not

seem to impact) and for the moment left the ‘xywz’ as is – while the command seems to proccss through all the tables – it does

not do anything ..

 

 

*SPSSINC MODIFY TABLES subtype="'Custom Table'"

*SELECT="<<ALL>>"

*DIMENSION= COLUMNS

*LEVEL = -1  PROCESS = ALL

*/STYLES  APPLYTO=BOTH

*CUSTOMFUNCTION="customstylefunctions.reletter(letters='xyzw')".

 

Idealy what I want as letters in the example would be replace

 

ABABCDABCDEABCABABABCD

 

with

 

BCDEFGHIJKLMNOPQRSTUVWX

 

but nothing is happening when run despite cyclcing through all the tables

 

 

 

Lasty for now I want to turn the text red for cells that include a significance letter (the letter, Ns, %s if there) – I assume this same function

using /STYLES=TEXTCOLOR = 255 0 0  for appropriately identified cells will work – but have not got part the relettering part to work yet

 

 

 

 

 

 

 

Thanks!

*********************************

Notice: This e-mail and any attachments may contain confidential and privileged information.  If you are not the intended recipient, please notify the sender immediately by return e-mail, do not use the information, delete this e-mail and destroy any copies.  Any dissemination or use of this information by a person other than the intended recipient is unauthorized and may be illegal.  Email transmissions cannot be guaranteed to be secure or error free. The sender therefore does not accept any liability for errors or omissions in the contents of this message that arise as a result of email transmissions.

 

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